excel error message

[mrpearl11]

When i put the following formula I get an error message. Not sure why or how to fix it.

=IF((A6+B6)<=50,(A6*.11)*.2,IF(A6+B6)<=1000,((A6-50)*0.06+5.5,IF(A6+B6)>1000.01,(A6-1000)*0.02+62.5

A6 =1200
B6=17.04

 

[VoG]

Try

=IF(A6+B6<=50,A6*0.11*0.2,IF(A6+B6<=1000,(A6-50)*0.06+5.5,IF(A6+B6>1000.01,(A6-1000)*0.02+62.5)))

 

[njimack]

You're enclosing each IF condition within a set of brackets. The following doesn't give you an error, although I'm not sure it returns the result you were expecting...

=IF(A6+B6<=50,(A6*0.11)*0.2,IF(A6+B6<=1000,(A6-50)*0.06+5.5,IF(A6+B6>1000.01,(A6-1000)*0.02+62.5)))

 

[mrpearl11]

thank you very much, that works. I was at my wits end trying to figure out what i was missing.

you guys are talented and quick.