Documentation/Calc Functions/AND

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

AND

Category:

Logical

Summary:

Returns TRUE if all arguments are TRUE. If one of the elements is FALSE, this function returns the FALSE value.

Syntax:

AND(LogicalValue1; LogicalValue2 ...LogicalValue30)

Returns:

Returns TRUE if all Logical values are true otherwise return FALSE.

Arguments:

The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values.

LogicalValue1; LogicalValue2 ...LogicalValue30 are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range. The result is TRUE if the logical value in all cells within the cell range is TRUE.

Additional details:

AND function with different case and explanation.png
  • You can also use IF with AND
AND with IF.png

Examples:

The logical values of entries 12<13; 14>12, and 7<6 are to be checked:

=AND(12<13;14>12;7<6) returns FALSE.

=AND (FALSE;TRUE) returns FALSE.

AND

Related LibreOffice functions:

IF

OR

ODF standard:

Part 6.15.2, Section 2

Equivalent Excel functions:

AND[1]