Computers and Technology

Use an IF function in cell H10 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. It is 1% for all sales that total more than $5, but are less than or equal to $10. No commission is paid on sales that total $5 or less. Reference the threshold levels (cells F5 and F6) in your logical tests for your IF function and the commission rates (cells G5 and G6) as your "value_if_true" and "value_if_false" arguments. Use appropriate relative and absolute references.

answer
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 09:40, vanessacasillas452
In the lab, which of the following displayed a list of all installed services and included a description of the service, the current state, and whether the service started automatically or manually? a. the services manager b. the applications summary c. the recommended services d. list the safe services list
Answers: 2
image
Computers and Technology, 22.06.2019 18:00, jabezslade22
What is the first view you place in your drawing?
Answers: 1
image
Computers and Technology, 23.06.2019 15:00, billlyyyyyyyyyy
Visually impaired individuals generally rely on the for navigation. thus, designers need to ensure that mouse-specific inputs, such as pointing, clicking, and hovering, can be done without a mouse.
Answers: 1
image
Computers and Technology, 24.06.2019 02:20, isabelsmhl
Peter is thinking of a number which isless than 50. the number has 9 factors. when he adds 4 to the number, itbecomes a multiple of 5. what is thenumber he is thinking of ?
Answers: 1
Do you know the correct answer?
Use an IF function in cell H10 to calculate the commission rate for the total sale for order 1. The...

Questions in other subjects: