IF formula -

[Guest]

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)

 

[Don Guillett]

start with the highest
=if(b11>10000,500,if(b11>8000,300 etc

 

[Guest]

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?

 

[Sandy]

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)

 

[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

 

[Guest]

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


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

 

[Guest]

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

 

[Dana DeLouis]

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

300,0)=IF(B11>10001, 500,0)

Just to be different...

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

 

[Don Guillett]

Yes, you did NOT do as I suggested. You don't need the <10000, etc. Just the

moving from large to small.

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.

 

[Don Guillett]

Sandy, See my post. You do NOT need the <<