AND

The AND function evaluates two conditions and returns the logical value True if both are true, and the logical value False otherwise.

Syntax

AND(
    <condition1>,
    <condition2>
)

Parameters
  • condition1: First condition to evaluate.
  • condition2: Second condition to evaluate.
Returned value

The AND function returns a Boolean (True or False).

Additional Information

This function only accepts two arguments (two conditions to evaluate). If you want to evaluate more than two conditions, you can resort to nesting some AND functions within others or, preferably, use the AND operator (&&) -see example below-.

Examples

In this example we want to check if the product sold is "A" and its price is greater than € 1000:

AND function. Example of use

In this second example we want to evaluate three conditions: that the product sold is "A", that the price is greater than € 1000 and that the month in which the sale took place was November, for which we resort to nesting two AND functions:

AND function. Example of use

The alternative is to use the AND operand, which makes the expression simpler:

AND operator. Example of use

Related functions
Category
Logical
Submitted by admin on Mon, 12/03/2018 - 23:18