Problem with Nested "IF"

[craterman]

When I use the statement below If the A1 cell value is under 749, it
works however, if the value in cell A1 is over 750 it always returns a
"no". Can someone tell me what I am missing? I am using excel 2003.

=IF(A1<749,"no Commission",IF(A1>=750<1499,"50",IF(A1>=1500<4999,"100",IF(A1>=5000<9999,"150",IF(A1>=1000<19999,"200",IF(A1>=20000<29999,"300",IF(A1>=30000<49999,"500","No")))))))

Thank You

 

[Frank Kabel]

Hi
you can't have a condition such as
A1>=750<1499
the correct syntax would be
AND(A1>=750,A1<1499)

Though in your case I would do this differently:
1. Setup a separate lookup sheet (e.g. call this 'lookup') with the
following layout:
A B
1 0 no Commission
2 750 50
3 1500 100
4 5000 150
.....

Now use the following formula
=VLOOKUP(A1,'lookup'!A1:B20,2,TRUE)

--
Regards
Frank Kabel
Frankfurt, Germany

When I use the statement below If the A1 cell value is under 749, it
works however, if the value in cell A1 is over 750 it always returns a
"no". Can someone tell me what I am missing? I am using excel 2003.

=IF(A1<749,"no

Commission",IF(A1>=750<1499,"50",IF(A1>=1500<4999,"100",IF(A1>=5000<999