Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than Less than issue
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!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than Less than issue
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(I67600,"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". -- Hth Kassie Kasselman Change xxx to hotmail "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!!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than Less than issue
Try this:
=If(I67600,"Hi","Lo") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if value is greater than # * by 20% if less * by 40 | New Users to Excel | |||
Greater Than but Less than | Excel Worksheet Functions | |||
IF greater than Zero | Excel Worksheet Functions | |||
IF greater than...IF less than....====== | Excel Discussion (Misc queries) | |||
Greater then/less then | Excel Worksheet Functions |