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 a user visits a web page with an embedded video, leaves without clicking on anything, and the session times out, how will Google Analytics report the session?
Answers (1)
Whats the best way to get into a computers programming to get past firewalls
Answers (2)
How does montag know that the mechanical hound leaves faber's house alone?
Answers (1)
Alcohol is a gateway drug. true or false?
Answers (2)
File servers are appropriate devices to use in an enterprise storage system. a. True b. False
Answers (1)
New Questions in Computers and Technology
Polymorphic refers to a malware
Answers (1)
6. Social Security is a federal program created in 1965 to provide a financial safety net to older Americans. True False 7. The ability to set attainable goals is important in time management. True False 8.
Answers (1)
How might your use of computers and knowledge of computers affect your personal and professional success
Answers (1)
Jenifer has a usb pen. She uses disk management to front the usb memory pen. State what happens to the data
Answers (1)
You are creating some Webpages for a project using a GUI HTML editor. Your supervisor directs you to collaborate with another developer to include jа vascript into several of the pages. How can you include this code in your pages?
Answers (1)
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?