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)