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")

Question

Harold Benson

Computers & Technology

30 July, 23:57

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")

+4

Answers (2)

Know the Answer?

Deegan Payne · Answer 1

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

Roy Henson · Answer 2

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".