View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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!!!!