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
Which employee could work both in Interactive Media and in Programming and Software Development?
Answers (1)
Arnold Smith is a former hacker and programmer for an underground investigative journalism organization that focused on hacking government and corporate systems in order to leak information on criminal activity.
Answers (1)
Why is ipsec considered to be a transparent security protocol?
Answers (1)
Who is a second-degree contact on a professional networking profile? A. a person who has accepted a user's request to be a contact B. a person who is in the contact list of one of your contacts C. a potential contact recommended by LinkedIn D.
Answers (1)
What are some locations in the Word interface where you can control indents? Check all that apply. a. in the Font dialog box b. on the Ruler c. in the Paragraph dialog box d. on the View tab
Answers (1)
New Questions in Computers & Technology
In the borders and shading dialog box where would you look to see if your border will have two sides
Answers (2)
When you save a Notepad file for the first time, you must also A. print a copy for your records. B. give it a name. C. check the file for errors. D. indicate the date and time.
Answers (1)
If a company doesn't distribute a computing use policy stating an employer's right to inspect employees' computers freely, including e-mail and Web use, employees have an expectation of privacyA. TrueB. False.
Answers (1)
Give 5 computer input devices and explain how they work
Answers (1)
Take some time to do some research about small businesses in your area. Select one and using HTML design a simple site that educates people on what it has to offer. You will not be able to create a shopping cart or include detailed information.
Answers (1)