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

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

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

http://www.freefilehosting.net/download/3fbf1

Regards,
Ryan---


--
RyGuy


"Sarah@LaborSource" wrote:

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

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

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

"Sarah@LaborSource" wrote:

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

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

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

"Mike H" wrote:

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

"Sarah@LaborSource" wrote:

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

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

Sarah,

Your welcome and thanks for the feedback.

Mike

"Sarah@LaborSource" wrote:

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

"Mike H" wrote:

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

"Sarah@LaborSource" wrote:

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