Returns the AND value of the values passed to the function.
= AND1(value)
args |
An array whose AND 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: “AND1(value): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= AND1(True, False) |
False |
= AND1(1+1=2, 2+2=5) |
False |
= AND1(“True”, “False”) |
False |
= 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(AND1(Quantity > 10, Quantity < 15)) |
True if the Quantity does not lie between 10 and 15. |