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, 22.06.2019 12:40
In a response of approximately 50 words, explain why it would be essential for the successful a/v technician to participate in additional coursework, presentations and seminars offered by equipment manufacturers as well as annual conferences attended by colleagues in the industry.
Answers: 1
question
Computers and Technology, 24.06.2019 12:00
An npn transistor is correctly biased and turned on if the a. base is negative. b. collector is negative. c. collector is positive with respect to the emitter and negative with respect to the base. d. collector is the most positive lead followed by the base.
Answers: 1
question
Computers and Technology, 24.06.2019 13:00
George heard about the benefits of a data warehouse. he wants to try implementing one for his organization. however, he is afraid that transferring data to the data warehouse will affect transaction time. which element ensures that transactions are not affected when moving data to a warehouse? when data is transferred to a data warehouse, the a area frees the source system to continue transaction processing.
Answers: 2
question
Computers and Technology, 24.06.2019 15:00
Universal windows platform is designed for which windows 10 version?
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, 22.06.2019 22:00
question
History, 22.06.2019 22:00
Questions on the website: 13722361