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, 21.06.2019 16:00
Write a loop that prints each country's population in country_pop. sample output for the given program with input 'china: 1365830000,india: 1247220000,united states: 318463000,indonesia: 252164800': united states has 318463000 people. india has 1247220000 people. indonesia has 252164800 people. china has 1365830000 people.
Answers: 2
question
Computers and Technology, 23.06.2019 07:00
You need a quick answer from a coworker. the most effective way to reach your coworker is through a. cloud server b. instant message c. teleconference d. telepresence
Answers: 1
question
Computers and Technology, 23.06.2019 11:20
Http is the protocol that governs communications between web servers and web clients (i.e. browsers). part of the protocol includes a status code returned by the server to tell the browser the status of its most recent page request. some of the codes and their meanings are listed below: 200, ok (fulfilled)403, forbidden404, not found500, server errorgiven an int variable status, write a switch statement that prints out the appropriate label from the above list based on status.
Answers: 2
question
Computers and Technology, 23.06.2019 15:20
What does a bonus object do? a. subtracts lives b. keeps track of a player's health c. gives a player an advantage d. makes text appear
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
History, 31.03.2020 08:21
question
Computers and Technology, 31.03.2020 08:32
Questions on the website: 13722363