problems with nested IF

[CharJT]

Hi

I'm trying to create a spreadsheet for my husband, who has to pay commissions based on the amount. However, no matter what is typed in D3, the result is always 4.8. (I get that I goofed up somewhere...I just can't figure out where!)

This is the equation:

=IF(AND(D3>0.01,D3<0.99),0.3,IF(AND(D3>1,D3<9.99),0.35,IF(AND(D3>10,D3<24.99),0.6,IF(AND(D3>25,D3<49.99),1.2,IF(AND(D3>50,D3<199.99),2.4,IF(AND(D3>200,D3<499.99),3.6,4.8))))))

What have I done wrong?

Thank you for your help

Char

 

[hbgray]

you missed integers inbetween the ranges

 

[CharJT]

got it...thanks! (must just be too late...)

 

[Aladin Akyurek]

Try to use a lookup table of commissions and a lookup formula instead of a chain of IFs.