|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 8th, 2010, 02:54 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using "OR" in an IF statement
I am trying to use the command OR in an If statement and I am having no luck.
In Lotus 123 I could string commands by using #OR# to produce a common result. For example: =IF(J3="INVEST" #OR# IF(K3 = "INVEST",1,"NO")) I can't seem to make this work in Excel. Can anyone provide me with a correction? 
|
|
#2
March 8th, 2010, 02:59 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using "OR" in an IF statement
Doug,
Like this =IF(OR(J3="Invest",K3="Invest"),"The true condition","the false condition") If the true or false condition is numeric then drop the quotes -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Doug" wrote: I am trying to use the command OR in an If statement and I am having no luck. In Lotus 123 I could string commands by using #OR# to produce a common result. For example: =IF(J3="INVEST" #OR# IF(K3 = "INVEST",1,"NO")) I can't seem to make this work in Excel. Can anyone provide me with a correction?
|
|
#3
March 8th, 2010, 03:29 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using "OR" in an IF statement
="The "&LOWER(OR(J3="Invest",K3="Invest"))&" condition" :-)
-- HTH Bob "Mike H" wrote in message news  Doug, Like this =IF(OR(J3="Invest",K3="Invest"),"The true condition","the false condition") If the true or false condition is numeric then drop the quotes -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Doug" wrote: I am trying to use the command OR in an If statement and I am having no luck. In Lotus 123 I could string commands by using #OR# to produce a common result. For example: =IF(J3="INVEST" #OR# IF(K3 = "INVEST",1,"NO")) I can't seem to make this work in Excel. Can anyone provide me with a correction?
|
|
#4
March 8th, 2010, 04:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using "OR" in an IF statement
=SIGN(COUNTIF(J3:K3,"invest"))
"Doug" wrote: I am trying to use the command OR in an If statement and I am having no luck. In Lotus 123 I could string commands by using #OR# to produce a common result. For example: =IF(J3="INVEST" #OR# IF(K3 = "INVEST",1,"NO")) I can't seem to make this work in Excel. Can anyone provide me with a correction?
|
|
#5
March 8th, 2010, 04:32 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using "OR" in an IF statement
Or with 'invest' in J3 or k3
="You could have miscon"&LOWER(OR(J3="Invest",K3="Invest"))&"d my advice to the OP"  -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Bob Phillips" wrote: ="The "&LOWER(OR(J3="Invest",K3="Invest"))&" condition" :-) -- HTH Bob "Mike H" wrote in message news Doug, Like this =IF(OR(J3="Invest",K3="Invest"),"The true condition","the false condition") If the true or false condition is numeric then drop the quotes -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Doug" wrote: I am trying to use the command OR in an If statement and I am having no luck. In Lotus 123 I could string commands by using #OR# to produce a common result. For example: =IF(J3="INVEST" #OR# IF(K3 = "INVEST",1,"NO")) I can't seem to make this work in Excel. Can anyone provide me with a correction? .
|
|
#6
March 8th, 2010, 06:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using "OR" in an IF statement
Miscontrued?
-- HTH Bob "Mike H" wrote in message ... Or with 'invest' in J3 or k3 ="You could have miscon"&LOWER(OR(J3="Invest",K3="Invest"))&"d my advice to the OP" -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Bob Phillips" wrote: ="The "&LOWER(OR(J3="Invest",K3="Invest"))&" condition" :-) -- HTH Bob "Mike H" wrote in message news Doug, Like this =IF(OR(J3="Invest",K3="Invest"),"The true condition","the false condition") If the true or false condition is numeric then drop the quotes -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Doug" wrote: I am trying to use the command OR in an If statement and I am having no luck. In Lotus 123 I could string commands by using #OR# to produce a common result. For example: =IF(J3="INVEST" #OR# IF(K3 = "INVEST",1,"NO")) I can't seem to make this work in Excel. Can anyone provide me with a correction? .
|
|
#7
March 8th, 2010, 07:49 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using "OR" in an IF statement
I knew you'd notice LOL
-- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Bob Phillips" wrote: Miscontrued? -- HTH Bob "Mike H" wrote in message ... Or with 'invest' in J3 or k3 ="You could have miscon"&LOWER(OR(J3="Invest",K3="Invest"))&"d my advice to the OP" -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Bob Phillips" wrote: ="The "&LOWER(OR(J3="Invest",K3="Invest"))&" condition" :-) -- HTH Bob "Mike H" wrote in message news
Doug,Like this =IF(OR(J3="Invest",K3="Invest"),"The true condition","the false condition") If the true or false condition is numeric then drop the quotes -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Doug" wrote: I am trying to use the command OR in an If statement and I am having no luck. In Lotus 123 I could string commands by using #OR# to produce a common result. For example: =IF(J3="INVEST" #OR# IF(K3 = "INVEST",1,"NO")) I can't seem to make this work in Excel. Can anyone provide me with a correction? . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
