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#

AND