IF Function - Calculation not working
 

=IF(C7<=2000,0,IF(C7<=6000,(C7-2000)*10%,IF(AND(C7<=10000,B76000),6000*10%+(C7-6000)*15%,6000*10%+4000*15%+(C7-10000)*20%)))


"amandooshna" wrote:

I have sum:

=IF(C7=10000,SUM(6000*10%)+(4000*15%)+((C7-10000)*20%),IF(C7<=10000,IF(B76000,SUM(6000*10%)+ ((C7-6000)*15%),IF(C7<=6000,SUM((C7-2000)*10%),IF(C7<=2000,0)))))

And this works, however when I change one of the input figures, then the
total comes our wrong.
my calculation is based on 10% from $2m - $6m, 15% from $6m-$10m and 20%
$10m and above.

Have I got my sum wrong?