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

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 15:00
Plz ( which is an example of a good url?
Answers: 1
question
Computers and Technology, 23.06.2019 16:30
How to do this programming flowchart?
Answers: 3
question
Computers and Technology, 24.06.2019 08:00
How can smart devices benefit businesses, organizations, and social communities in the global marketplace?
Answers: 1
question
Computers and Technology, 24.06.2019 15:50
Subscribe to j p g a m e t u b e on you tube ?
Answers: 2
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, 22.09.2019 04:50
question
Biology, 22.09.2019 04:50
Questions on the website: 13722363