Greater than Less than issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jon - 19 Mar 2008 18:56 GMT

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

=IF(OR(I67>350, 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 to this Message

Ron Coderre - 19 Mar 2008 19:07 GMT

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)

> Hello,
> I'm having an issue with the following formula:
[quoted text clipped - 5 lines]
> Thanks
> in advance for your assistance!!!!

Reply to this Message

Kassie - 19 Mar 2008 19:11 GMT

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

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> Hello,
> I'm having an issue with the following formula:
[quoted text clipped - 4 lines]
> putting the formula in. If it's greater than 600 I want it to say HI. Thanks
> in advance for your assistance!!!!

Reply to this Message

Bob Phillips - 19 Mar 2008 19:11 GMT

=IF(I67<350,"LO",IF(I67>600,"HI","")

Signature

---
HTH

Bob

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

> Hello,
> I'm having an issue with the following formula:
[quoted text clipped - 5 lines]
> Thanks
> in advance for your assistance!!!!

Reply to this Message

FSt1 - 19 Mar 2008 19:13 GMT

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

regards
FSt1

Reply to this Message

Mike Middleton - 19 Mar 2008 19:13 GMT

Jon -

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

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

> Hello,
> I'm having an issue with the following formula:
[quoted text clipped - 5 lines]
> Thanks
> in advance for your assistance!!!!

Reply to this Message

RagDyer - 19 Mar 2008 20:06 GMT

Try this:

=If(I67>600,"Hi","Lo")

Signature

HTH,

RD

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

> Hello,
> I'm having an issue with the following formula:
[quoted text clipped - 5 lines]
> Thanks
> in advance for your assistance!!!!

Reply to this Message