Using "OR" in an IF statement

  • Thread starter Thread starter Doug
  • Start date Start date
D

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?
 
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.
 
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.
 
Miscontrued?

--

HTH

Bob

Mike H said:
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.
Click to expand...
 
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.
 
Back
Top