Skip to main content
Version: Streamsheets 2.5

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

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

Examples

FormulaResultComment
=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"