A formula in "works" it does now work

[imchipper]

"(=IF <=10 X 3),1,0), ((>=10.01<15 X 2.75), 1,0), ((>=15.01<=20 X 2.5),1, 0), ((>=20.01<=50 X 2.25), 1,0), ((>=50.01<=100 X 2), 1, 0), ((>=100.01<=200 X 1.75), 1, 0), ((>=200.01<=500X1.5),1,0), ((>=500.01X1.3,1,0))

It seems so simple yet there is an error...please help

 

[Anne Troy]

You have no cell references in your formula. Make a table that contains the multiplications already performed, and then use a vlookup.

See:

http://www.theofficeexperts.com/excel.htm#TheDreadedVlookup