FRANK

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

Fernando Duran

Hi Frank, it's late, but one last question, I need to use the OR, in
one of the formulas, but how you wrte in Excel? , because I have a
nested IF, and I want to add another one, that will say, a or b, to do
something, i just need the syntax...
Thanks
 
Hi Fernando!

Frank is probably off to sleep.

On its own:

=OR(A1=7,B1=9)
Returns TRUE if either A1 is 7 or B1 is 9

The requirement of an IF function condition is that it should return
TRUE or FALSE so the structure of using OR in an IF function is:

=IF(OR(A1=7,B1=9),"One or more is met","None is met")

In general terms:

=IF(OR(Logical1,Logical2),Value_if_true,Value_if_false)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Frank!

OK! These people who work late into the night....

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top