View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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!!!!