how does that continue with this:

=IF(B6<7000,B6*0.45,IF(B6<9000,B6*0.5,IF(B6<13000, B6*0.55,IF(B6<16000,B6*0.6,B6))))

right now any number 16000 is simply multiplied by 100%

Corey

"Roger Govier" wrote:

Hi

=IF(A116000,A1,(A10)*45%+(A17000)*5%+(A19000)* 5%+(A113000)*5%)

Regards

Roger Govier


cbrock wrote:
I am trying to create a formula that will calculate commissions depending on
bechmarks.
Example:
IF <7000 then multiply by 45%
IF 7000, but <9000 then multiply by 50%
IF 9000, but <13000 then multiply by 55%

The final part of the formula should be as follows:
If 13000, but <16000 then multiply by 60%, IF 16000, 100% of the amount

16000 is multiplyed by 100%