How to make "If,then" formulas with THREE outcomes

S

Sarah@LaborSource

Hello. I am trying to create a formula to calculate commissions. I need to
make a formula that says:

If sales are below $150K, commission is 1.25%. If sales are $150-$200,
commission is 1.75%. If sales are above $200, commission is 2.5%.

Thanks!
Sarah
 
M

Mike H

To work out the commision on A1 try this

=IF(A1<150000,A1*0.0125,IF(A1<200000,A1*0.0175,A1*0.025))

Mike
 
S

Sarah@LaborSource

THanks Mike. Don't exactly understand it all, but it worked like a charm.
Sarah
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating custom formulas 3
Sales Commission Calculation 3
how to calculate commissions 6
MORE THAN 8 IF CONDITION IN A FORMULA IS NOT ACCEPTING 3
How do I set up multiple if statements in Excel? 2
Commission Calculation with IF Stmt. 2
how do I combine multiple IF statements to come up with 1 value? 6
Need help with a function 2

Top