The 'OR' function is one of the basic logical functions in Excel. It returns either 'TRUE' or 'FALSE' like most logical functions. The function evaluates the arguments passed to it and returns 'TRUE' if one of them evaluates to 'TRUE'. The power of 'OR' is generally harnessed by nesting it in 'IF' function. This tutorial will, however, cover only functionality of 'OR' function.
The syntax of 'OR' function is as follows
OR(condition1, [condition2], ...)
At
least one arguments should be passed to it and a maximum of 255
arguments can be passed. The arguments must results in either TRUE or
FALSE else the function may return an error.
To demonstrate the use of 'OR', consider the below example
and consider the formula in below snapshot
Three arguments were passed to 'OR' function
1>A2, which is FALSE
A2>10 which is TRUE
and A3<A2 which is also TRUE. The end result is TRUE because one or more arguments passed were TRUE. Lets consider another example
As all three arguments passed to OR are FALSE, the value returned from OR is also FALSE. On the same line the below example can be explained.
To demonstrate the use of 'OR', consider the below example
and consider the formula in below snapshot
Three arguments were passed to 'OR' function
1>A2, which is FALSE
A2>10 which is TRUE
and A3<A2 which is also TRUE. The end result is TRUE because one or more arguments passed were TRUE. Lets consider another example
As all three arguments passed to OR are FALSE, the value returned from OR is also FALSE. On the same line the below example can be explained.
0 comments:
Post a Comment