AND

Returns true if all arguments evaluate to true

Syntax

AND(logical1, [logical_n])

Arguments

Argument	Description	Required
logical1	The first logical value or expression to evaluate	Required
logical_n	Additional logical values or expressions to evaluate	Optional

Examples

All conditions true

One condition false

Multiple cell conditions

Related Functions

Other Logical functions:

• CONTAINS - Returns true if a range contains a specified value
• IF - Returns the first value if logical_expression is TRUE; otherwise returns the second value.
• IFERROR - Returns a custom result when a formula generates an error, and a normal result when no error is detected.
• IFS - Returns the value corresponding to the first TRUE result when evaluating multiple tests.
• ISBETWEEN - Returns true if a provided number is between two other numbers either inclusively or exclusively; otherwise returns false.
• ISBLANK - Returns true if the value is blank, empty, or null; otherwise returns false.
• ISERROR - Returns TRUE if the value is any error value
• ISEVEN - Returns TRUE if the number is even, FALSE if odd
• ISNA - Returns TRUE if the value is the #N/A error value
• ISNUMBER - Returns TRUE if the value is a number
• ISODD - Returns TRUE if the number is odd, FALSE if even
• ISTEXT - Returns TRUE if the value is text
• NOT - Returns FALSE if logical expression is TRUE and TRUE if logical expression is FALSE.
• OR - Returns true if any argument evaluates to true

---

← Back to Formula Reference