subject

Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $5 or less. Reference the threshold levels (cells F13 and F14) in your logical tests for your IF function and the commission rates (cells G13 and G14) as your "value_if_true" and "value_if_false" arguments. Use appropriate relative and absolute references.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 08:00
The managing director of a company sends a christmas greeting to all his employees through the company email. which type of network does he use? he uses an .
Answers: 3
question
Computers and Technology, 24.06.2019 23:00
People should never use telepresence when virtually meeting with a group of co-workers. true false
Answers: 1
question
Computers and Technology, 25.06.2019 17:00
Denny often uses his word-processing program. which of the following would denny do to more easily access this program and increase his productivity? create a shortcut for it on quick launch delete it from the start menu move it to the recycle bin put it in his my documents folder . pls
Answers: 1
question
Computers and Technology, 26.06.2019 01:00
Which of these refer to information about the variables in mail merges? a. template b. email c. data source d. letter e. folder
Answers: 1
You know the right answer?
Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The...
Questions
question
Mathematics, 15.01.2020 07:31
question
Chemistry, 15.01.2020 07:31
question
Mathematics, 15.01.2020 07:31