The OR function , one of many EXCEL logical functions, is used to evaluate a number of logical conditions, passed as arguments to the function. The function will return a single value of TRUE or FALSE.
Syntax
OR(logical1, logical2 ………)
logical1 and logical2 are conditions that evaluate to TRUE or FALSE. The first argument is required the second one is optional.
You can have up to 30 arguments in EXCEL 2003 and 255 in EXCEL 2007.
Examples:
A1 = 6
B1 = 10
=OR(A1>5;B1>10) : returns TRUE.
= OR(A1>10;B1>10):returns FALSE.
=OR(A1>5;B1>5): returns TRUE.
You can nest the OR function within another logical function as follows:
=IF(OR(A1>5;B1>10) ;”Valid numbers”;”Invalid numbers”)
If you put this formula in C1 for example, and A1 and B1 have the values shown above, then C1 will have the value : “Valid numbers”, because the OR function will evaluate to TRUE.
Related posts: