Returns the OR value of the values passed to the function.
= OR1(value)
args |
An array who’s OR value is to be determined. The array can contain expressions (e.g., 1+1=2), boolean values (e.g., true), strings (“true”, “false”), or numbers(-15) |
Boolean
In the case of an error, the function displays an error message: “OR1(value): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= OR1(True, False) |
True |
= OR1(2+1=2, 2+2=5) |
False |
= OR1(“True”, “False”) |
True |
= OR1(AND1(Quantity > 10, Quantity < 15), Discount > 5) |
True if either the Quantity is between the numbers 10 and 15 or if Discount is greater than 5. |
= NOT(OR1(Quantity > 10, Quantity < 15)) |
True if either the Quantity is not greater than 10 and is not lesser than 15. |