It looks like you have too many arguments...Don suggested:
=if(b1110000,500,if(b118000,300 etc

But, you have
=IF(B1110001,500,0),IF...

You're saying if B11 is greater than 10001, insert 500, if not, insert 0.
Don is saying if B11 is greater than 10000, insert 500, if not, if B11 is
greater than 8000, insert 300. The '0' that you have is the "if not" section
of the argument.

Hope this makes sense!!

MT

"sssspro" wrote:


Thank you Don. I did this, and it still didn't work.

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

Am I missing sometihng? parenthases, =, commas?



"Don Guillett" wrote:

start with the highest
=if(b1110000,500,if(b118000,300 etc

--
Don Guillett
SalesAid Software

"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)