N
nader
some one help with the function (OR)
I dont know how to use this function
thankyou for al
I dont know how to use this function
thankyou for al
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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
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
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
N
nader
thankyou very mush for help
it was good for m
it was good for m
J
JulieD
you're welcome