Greater than Less than issue
 

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

=IF(OR(I67350, 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!!!!

Greater than Less than issue
 

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)

"Jon" wrote in message
...
Hello,
I'm having an issue with the following formula:

=IF(OR(I67350, 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!!!!

Greater than Less than issue
 

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(I67600,"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".

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Jon" wrote:

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

=IF(OR(I67350, 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!!!!

Greater than Less than issue
 

=IF(I67<350,"LO",IF(I67600,"HI","")


--
---
HTH

Bob


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



"Jon" wrote in message
...
Hello,
I'm having an issue with the following formula:

=IF(OR(I67350, 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!!!!

Greater than Less than issue
 

hi
try it this way....
=IF(I7<350,"Lo",IF(I7600,"Hi","Middle"))

regards
FSt1

"Jon" wrote:

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

=IF(OR(I67350, 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!!!!

Greater than Less than issue
 

Jon -

=IF(I67<350,"LO",IF(I67600,"HI","It's between 350 and 600, inclusive"))

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"Jon" wrote in message
...
Hello,
I'm having an issue with the following formula:

=IF(OR(I67350, 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!!!!

Greater than Less than issue
 

Try this:

=If(I67600,"Hi","Lo")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Jon" wrote in message
...
Hello,
I'm having an issue with the following formula:

=IF(OR(I67350, 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!!!!