# Documentation/Calc Functions/AND

Jump to navigation Jump to search Under construction. For now, see the system Help files.

AND

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:

• You can also use IF with AND

## 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.

## ODF standard:

Part 6.15.2, Section 2

AND