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.
Answers (1)
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “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 ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers
You Might be Interested in
What was one of the first ways that health information technology (health IT) changed the way healthcare workers practice? A. Use of electronic health records (EHRs) B. Use of wireless phone systems C. Use of automated BP monitors D.
Answers (1)
How do you calculate typing speed
Answers (1)
Technician A says that a longer piston stroke creates more engine torque. Technician B says that a shorter piston stroke allows for higher engine rpm. Who is correct?
Answers (1)
Choose all items that represent characteristics of a work samples. provides examples of creative work such as writing, film, or art is always in a digital format can be referenced in your resume and taken to job interviews is well organized and easy
Answers (1)
Fill the validateForm function to check that the phone number contains a number (use the isNaN function) and that the user name is less than 11 characters long.
Answers (1)
New Questions in Computers & Technology
A perfect binary tree is a complete binary tree with all levels fully filled. Add a method in the BST class to return true if the tree is a perfect binary tree.
Answers (1)
T F Static local variables are not destroyed when a function returns.
Answers (1)
Give five factors affecting the kitchen design
Answers (1)
Which of these is an application to control
Answers (1)
Suggest how an engineer responsible for drawing up a system requirements specification might keep track of the relationships between functional and non-functional requirements.
Answers (1)