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: 3

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 17:00
In addition to using the icons to adjust page margins, a user can also use
Answers: 1
question
Computers and Technology, 22.06.2019 04:30
Eye injuries usually occur as a result of all of the following things, except: a) proper machine operation b) battery explosion c) falling or flying debris d) electric welding arc
Answers: 2
question
Computers and Technology, 23.06.2019 22:00
Jackson, who works in the finance department of a company, is holding a seminar for other employees on how to file taxes. only three employees sign up to attend the seminar. which device can he use to share his presentation with a group of three employees?
Answers: 1
question
Computers and Technology, 23.06.2019 23:30
What can you prevent issues related to downloading content form the internet
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
English, 18.06.2021 14:00
question
Mathematics, 18.06.2021 14:00
Questions on the website: 13722362