Using "OR" in an IF statement
="The "&LOWER(OR(J3="Invest",K3="Invest"))&" condition" :-)
--
HTH
Bob
"Mike H" wrote in message
...
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?
|