AND1

Returns the AND value of the values passed to the function.

Syntax

= AND1(value)

Parameters

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)

Return Type

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.

Examples

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.