some one help with the function (OR)

N

nader

some one help with the function (OR)
I dont know how to use this function

thankyou for al
 
T

Tushar Mehta

Did you check the help file? What part of the explanation didn't you
understand?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
J

JulieD

Hi
the OR function is used to check if at least one of multiple conditions are
met
=OR(A1=5,B1=10)
will return true if either (or both) A1=5 or B1=10 and will return false
only if neither of them are true.
with an OR fuction you can test up to 30 criteria ... if any one of them is
met then true is returned and false is only returned if none of the criteria
are met.

this function is generally nested in an IF function e.g.
=IF(OR(A1=5,B1=10),"One or more conditions met","No conditions met")
and is used as an alternative to the AND function which requires ALL of the
conditions to be met for true to be returned.

Hope this helps
Cheers
JulieD
 
C

CLR

Hi nader...........

Used with an IF function, it would go something like this.........

=IF(OR(A1=1,A2=1),"YES","NO")

......if either A1 OR A2 equals 1, then enter YES, otherwise enter
NO...........


hth
Vaya con Dios,
Chuck, CABGx3
 
Top