IF formula -

S

sssspro

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(B11>10001, 500,0)
 
S

sssspro

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

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

Am I missing sometihng? parenthases, =, commas?
 
S

Sandy

sssspro said:
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(B11>10001, 500,0)
Click to expand...
 
S

Sandy

=IF(B11<6500,0,IF(AND(B11>6500,B11<8000),150,IF(AND(B11>8000,B11<10000),300,IF(B11>10000,500,"None"))))


You'll need to modify this a bit... If you have a value of either 6500,
8000, or 10000 it will reurn a false ("None" string). Incorporate in
greater than or equal to, less than or equal to's to get it to accept
those values


HTH

Sandy
 
S

sssspro

THANK YOU THANK YOU THANK YOU!!!!!!


It works!!! I knew I had to be close. I appreciate your help, and yes it
did help!
 
T

themediumtee

It looks like you have too many arguments...Don suggested:
=if(b11>10000,500,if(b11>8000,300 etc

But, you have
=IF(B11>10001,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
 
D

Dana DeLouis

=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B11>10001, 500,0)
Click to expand...

Just to be different...

=150*((B11>6500)+(B11>8000))+200*(B11>10000)
 
D

Don Guillett

Yes, you did NOT do as I suggested. You don't need the <10000, etc. Just the
moving from large to small.
Click to expand...
Think about it. An if formula says that if this is true then 500 but if it
is not true move on to the next test.
 
Top