Skip to main content

AND

Evaluates, if all given values are true.

Syntax

=AND(Value1 [, Value2], ...)

Arguments

NameDescription
Value1First value to check
Value2, ...Optional. Other values to check

Return Value

TRUE, if all passed arguments are true, otherwise FALSE.

Example

FunctionResultComment
=AND(TRUE,1)TRUENumbers not equal 0 are evaluated as TRUE
=AND(TRUE,"Test")TRUENon empty strings are evaluated as TRUE
=AND(FALSE,"Test")FALSEFirst Value is "FALSE", function is evaluated as "FALSE"