View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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!!!!