Greater than Less than issue

J

Jon

Hello,
I'm having an issue with the following formula:

=IF(OR(I67>350, I67<600)),"LO","HI")

Basically if I67 is less than 350 I want it to say LO in the cell I'm
putting the formula in. If it's greater than 600 I want it to say HI. Thanks
in advance for your assistance!!!!
 
R

Ron Coderre

Try this:

=IF(I67<350,"LO",IF(I67>=600,"HI",""))

or...if you want to ignore a non-numeric I67:
=IF(ISNUMBER(I67),IF(I67<350,"LO",IF(I67>=600,"HI","")),"")

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
K

Kassie

As it stands, your argument is that IF(I67 is greater than 350, the answer
should be "LO", else it should be "HI". The less than part, IF(I67 is less
than 600, then the answer should be "LO", else it should be "HI", and as a
result you will ALWAYS get "LO"

The correct formula would be =IF(I67<375,"LO",IF(I67>600,"HI",""))

Anything below 375 would result in "LO". Anything above 600 would result in
"HI", and anything between 375 and 600 would leave the cell blank. If you
change the "" at the end to eg "MID", the result in the last argument would
be "MID".
 
B

Bob Phillips

=IF(I67<350,"LO",IF(I67>600,"HI","")


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top