What is AND Function in MS Excel?

This is a logical type of function in MS Excel that returns the value as ‘TRUE’ or ‘FALSE’. It is tested on different conditions to check whether these conditions met the criteria of TRUE or FALSE.

Purposes of AND Function in MS Excel

The purpose of AND function in Excel is to return a value after testing multiple conditions. This function requires more than one condition at a time to test it whether it is TRUE or FALSE. It can check up to 255 conditions. The arguments provided in the AND function can be cell references, logical expressions, or arrays. 0 is evaluated as FALSE. Every other value except 0 is evaluated as TRUE.

Syntax of AND Function

The syntax of the AND function is written as follows.

=AND (logical1, [logical2], …)

Arguments

The arguments used in the syntax of AND function in Excel are described below.

Logical 1: this is the first condition used in the AND function.

Logical 2: this is the second condition used in the AND function. However, this is an optional condition.

Examples

=AND (A1>0, A1<5)

This example shows that the value of A1 is greater than 0 and less than 5.