Calculate the commission rate for the total sale

Assignment Help Financial Management

Reference no: EM131834482 , Length: word count : 500

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.

Reference no: EM131834482

Questions Cloud

Discuss the attitude and behavioral changes toward listening : Identify and discuss the attitude and behavioral changes toward listening that have occurred over the past decades.

Problem of aerial search : A problem of aerial search. State conditions for the validity of the following assertion: if N ships are distributed at random over a region of the ocean

Determine the current value of the bond : Determine the current value of the bond if present market conditions justify a 14 percent required rate of return.

Number of matches approximately obeys a poisson probability : The number of matches approximately obeys a Poisson probability law. Consider the number of matches obtained by distributing M balls, numbered

Calculate the commission rate for the total sale : 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 l

What are the opportunities for marketers : What are the opportunities for marketers associated with using this type of data? How reliable/useful are these types of analyses?

What is the probability of having 5 or fewer cases : In a city of 1,000,000 what is the probability of having 5 or fewer cases? State your assumptions.

Calculate the probability that a blanket : Calculate the probability that a blanket will contain 2 or more defects.

What sort of risk mitigation program would you implement : Assume that you are an Enterprise Risk Manager in your company, what sort of risk mitigation program would you implement?

User Account

All Pages