But if you've got a first condition of IF(B11<=6500,... (assuming that the
B1 was a misprint for B11), then you don't need the test for B116500 in the
second IF statement.
--
David Biddulph

"Beege" wrote in message
. ..
And don't forget equal signs for the event X=6500 etc.

=IF(B1<=6500,0,IF(AND(B116500,B11<=8000),150....

Beege

"Dave F" wrote in message
...
Use the following syntax:

=IF(B1<6500,0,IF(AND(B116500,B11<8000),150....

Make sure your parentheses are correct.

Dave
--
Brevity is the soul of wit.


"sssspro" wrote:

Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be
appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)