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, 21.06.2019 20:20
Wireless communications is likely to be viewed as an essential part of an enterprise network infrastructure when: select one: a. mobile communication is needed b. communication facilities must be installed at low initial cost c. communication must take place in a hostile or difficult terrain that makes wired communication difficult or impossible d. the same information must be broadcast to many locations
Answers: 1
question
Computers and Technology, 22.06.2019 15:00
When designing content as part of your content marketing strategy, what does the "think" stage represent in the "see, think, do, care" framework?
Answers: 3
question
Computers and Technology, 23.06.2019 07:00
What are three software programs for mobile computing?
Answers: 1
question
Computers and Technology, 23.06.2019 07:30
What is the original authority for copyright laws
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
Chemistry, 29.01.2021 21:10
question
English, 29.01.2021 21:10
question
Mathematics, 29.01.2021 21:10
question
Mathematics, 29.01.2021 21:10
question
Mathematics, 29.01.2021 21:10
question
Spanish, 29.01.2021 21:10
Questions on the website: 13722367