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?

One way:

=MAX(C7-2000,0)*10%+MAX(C7-6000,0)*5%+MAX(C7-10000,0)*5%

Tim C

"amandooshna" wrote in message
...
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?

I noticed in the formula that your conditions are as ff:

a. if C7 =10000
b. if C7 <=10000
c. if C7 <=6000
d. if C7 <=2000

Try removing the "=" sign on either condition a or b, since if the value of
C7 = 10000, conditions a & b are TRUE, and this could be the error since
Excel will follow the first condition. Same also applies when the value of C7
= 2000 orless, conditions b, c, & d are all TRUE, hence Excel will follow
condition b.

Also, try to use the AND function to specifiy the range of value you use on
your conditions, ie:

=IF(AND(C7<=10000,C7=6000),CONDITION1,CONDITION2)

Hope this helped.

--
sandyboy


"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?