One way:

=SUMPRODUCT(--(C7{0,6000,10000}),(C7-{0,6000,10000}),
{0.1,0.05,0.05})*(C7=2000)

See

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

for an explanation of how it works, and some ways to make it more
flexible for changes to the formula.

The reason your formula doesn't work (aside from having B7 instead of C7
in one location), is that if C7<=6000, the SUM will always be executed
so the last IF() is never evaluated.

Note that your SUM()s are superfluous. SUM(6000*10%) just adds the
overhead of the SUM function to its equivalent (6000*10%).



In article ,
amandooshna wrote:

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

This above sum works, execpt for the last IF function. For some reason my
result always comes out with a negative, when it should be 0. Any
suggestions on why? Or what I should do to change?

Thanks!