AND

Evaluates, if all given values are true.

Syntax

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

Arguments

Name	Type	Description
Value1	Value	First value to check
Value2, ... (optional)	Value	Other values to check

Return

Type	Description
Boolean	TRUE, if all passed arguments are true, otherwise FALSE.

Examples

Formula	Result	Comment
=AND(TRUE,1)	TRUE	Numbers not equal 0 are evaluated as TRUE
=AND(TRUE,"Test")	TRUE	Non empty strings are evaluated as TRUE
=AND(FALSE,"Test")	FALSE	First Value is "FALSE", function is evaluated as "FALSE"