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
You have been assigned to work with a web developer to troubleshoot the output of a cgi application. your job is to type commands into a terminal, and the web developer will read the output. you cannot see what you are typing into the terminal.
Answers (1)
Which line (s) immediately flush the output buffer? 1. System. out. print ("One for the money"); 2. System. out. print ("Two for the show/n"); 3. System. out. println ("Three to get ready"); 4. System. out. print ("And four to go"); 5. System. out.
Answers (1)
After installing a second hard drive what needs to be done to the hard drive and what do these 2 tasks do?
Answers (1)
A security specialist is notified about a certificate warning that users receive when using a new internal website.
Answers (1)
To share a document in my online electronic journal, I should select the option to
Answers (1)
New Questions in Computers and Technology
Which operator is used for quotient division in java
Answers (1)
Shreya has combined all the cells in a single leftmost column in a table. Instead of identifying the category multiple times, she would like to combine these cells and then structure the word "Appliances" vertically in the cell.
Answers (1)
Liquid water can change into a gas and become part of the air. When water is a gas, what is it called? A. air pressure B. rain C. water vapor
Answers (1)
When a disk is formatted, it is impossible to recover the data that was on the disk?
Answers (1)
1. What words might you add to the Microsoft spelling dictionary? 2. What are some advantages of wrapping text around on a row? 3. How could using "Find & Select" in the editing tab benefit you?
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?