Ask Question
Computers and TechnologyComputers and Technology
13 May, 20:44

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

+3
Answers (2)
  1. 13 May, 23:52
    0
    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".
  2. 14 May, 00:05
    0
    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
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “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 ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers
You Might be Interested in
If you delete a file from removable media, it is stored in the recycle bin where you can recover it until you empty the recycle bin.
Answers (1)
Which memory part is connected to the processor? Which memory part is connected to the processor?
Answers (1)
TRUE/FALSE The Interrupt Vectors stored in the Interrupt Vector table are really just the addresses of the interrupt service routines
Answers (1)
Based on the information presented in this unit, would you advise a young couple to force feed brussels sprouts to their toddler? Explain.
Answers (1)
Find the number of ideal integers within the given segment [low, high] inclusive. An ideal number is a positive integer that has only 3 and 5 as prime divisors.
Answers (1)
New Questions in Computers and Technology
In the state of Florida your first conviction for DUI can result in your vehicle being impounded for: A. 20 days B. 10 Days C. 5 Days D. 15 Days
Answers (1)
Write the definition of a class employee base on the modular specification:. A data member for Id of type int (private). A data member for EmpName of type string (private). A data member for Salary of type double (private).
Answers (1)
What target audience does your product serve?
Answers (1)
What's the best way to use a lectern during your speech?
Answers (1)
Which information in the passage supports the argument that plastic bags are a threat to animals? A. Plastic bags are everywhere. B. Plastic bags are hard to get rid of. C. Plastic bags do not decompose once eaten. D.
Answers (2)
Home » Computers and Technology » 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.
Sign Up Forgot Password?