nested functions

[Linda]

I am trying to create a nested function that returns a
value of a bonus figure paid at
5% over a certain amount e.g .total sales over 2000 and
2% at a lower amount e.g .total sales over 1500 and no
bonus at a lesser amount (1200)
I have used the if function but when calculated the cel
shows the formula as opposed to the actual figure..I
simply can not figure it out and it is driving me nuts!!!!

 

[Andy B]

Linda

I've tried this formula to work out the bonus:
=IF(D18>2000,(D18-2000)*0.05,IF(D18>1500,(D18-1500)*0.02,""))
and it works OK.
Make sure you have Calculation set to automatic and that in
Tools/Options/View the Formulas option is not ticked.

Andy.

 

[Nathan]

This formula will calculate the Bonus on the sales value
as well.
=IF(C7>=2000,C7*0.05,IF(AND(C7>=1500,C7<2000),C7*0.02,IF
(C7<1500,C7*0,)))
Hope it helps