Help, Formula Problem

[DPars]

I am trying to find a Formula code for working out a commision charg
which is worked out from a final sale figure, ie. sales price $100.00
commison charges are $0.01 - $29.99 5%, $30.00 - $69.99 3.5% $70.0
2%.

Is there a formula that will work this figure out for you, please hel
before my head caves in:rolleyes

 

[Peo Sjoblom]

For a possible solution see:

http://www.mcgimpsey.com/excel/variablerate.html

 

[Domenic]

I am trying to find a Formula code for working out a commision charge
which is worked out from a final sale figure, ie. sales price $100.00 -
commison charges are $0.01 - $29.99 5%, $30.00 - $69.99 3.5% $70.00
2%.

Is there a formula that will work this figure out for you, please help
before my head caves in

Assuming that the sales price is in cell A1, and that you mean sales equal
to or greater than $70.00, try,

=IF(AND(A1>0,A1<=29.99),A1*0.05,IF(AND(A1>=30,A1<=69.99),A1*0.035,IF(A1>=70,
A1*0.02,"")))

Hope this helps!

 

[DPars]

Super site, many thanks, I will be a firm visitor there now.

 

[DPars]

Sometimes in Life Domenic we all need a little help, it's nice to kno
there are people out there still willing to give it. Thanks alot!!

 

[Domenic]

Sometimes in Life Domenic we all need a little help, it's nice to know
there are people out there still willing to give it. Thanks alot!!

You're welcome!