AND

The AND function returns TRUE only if all specified conditions are TRUE. If any condition evaluates to FALSE, the function returns FALSE. It is commonly used with IF and other conditional functions to evaluate multiple criteria.

Syntax

AND(logical_test1, [logical_test2], ...)

Arguments

  • logical_test1: The first condition to evaluate.

  • logical_test2, ... (Optional): Additional conditions to evaluate.

Return value

Returns TRUE if all conditions are met; otherwise, returns FALSE.

Example

IF(AND(Sub Region == "APAC", Sub Category== "Juices"), 50000000, 0)

In this example, the AND function is used within an IF statement to assign values to the 2027 Actuals Plan. The AND function evaluates whether both conditions are met: Sub Region is APAC and Sub Category is Juices. If both conditions are TRUE, the formula returns 50 million; otherwise, it returns 0.

Excel equivalent

ANDarrow-up-right

Last updated

Was this helpful?