Thread: Greater than Less than issue
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton Mike Middleton is offline
external usenet poster
  
Posts: 762
Default 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!!!!


Reply With QuoteReply With Quote