# Documentation/Calc Functions/AND

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

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

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

## Related LibreOffice functions:

## ODF standard:

Part 6.15.2, Section 2

## Equivalent Excel functions:

AND[1]