IF formula -
=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)
Just to be different...
=150*((B116500)+(B118000))+200*(B1110000)
--
Dana DeLouis
Windows XP & Office 2003
"sssspro" wrote in message
...
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)
|