In a spreadsheet, cells b2 through b10 store the cost price of items and cells c2 through c10 store the selling price. if the selling price exceeds the cost price, you earn a profit. otherwise, you suffer a loss. which formula will you use to determine whether you earn a profit? =if(c2> b2; "profit"; "loss")=if(c2b2; "loss"; "profit")=if(c2> b2; "profit"; "profit")

The correct formula to use is =IF(C2>B2;"Profit";"Loss"). The condition set is that if the selling price(C Column) is greater than the cost price(B Column), you earn a profit. When encoded in the formula, the translation in this statement would be C2>B2. When you use the formula =IF(C2>B2;"Profit";"Loss"), the first word will be shown when the condition set is applicable. In this case, if the condition is true, it displays the word "Profit" but otherwise, it displays "Loss".