Using "OR" in an IF statement

[Doug]

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?

 

[Mike H]

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.

 

[Bob Phillips]

="The "&LOWER(OR(J3="Invest",K3="Invest"))&" condition"

 

[Teethless mama]

=SIGN(COUNTIF(J3:K3,"invest"))

 

[Mike H]

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]

Miscontrued?

--

HTH

Bob

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.

 

[Mike H]

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.