**Rational**

Return TRUE if all its arguments are correct.

**Description**

The Excel AND function is a logical operator that join two or more criteria and return TRUE that satisfy all given criteria.

For example, If A2 is 75 and we enter formula **=AND(A2>1,A2<50)**, result display “FALSE” as the value A2 does not meet both criteria.

**Syntax**

=AND(logical1, [logical2], …)

**Parameters**

**logical1** -The first criteria to evaluate**logical2 **[optional] – Additional criteria to test.

**Return Value**

TRUE if satisfy all criteria. Otherwise, it returns FALSE

**Key Notes**

- The AND function return TRUE only if all the given logic fulfills its condition; the function can accept a maximum of 255 logic.
- Use OR Function returns TRUE when
**at least one**of the logic is true - AND function is a logical operator which comprehend a logical test in term of TRUE or FALSE.
- Values like text or empty cells are ignored in the argument.

To join both criteria and show text like here in cells B8 and C8 we have digit 1 and 100 and we put formula =IF(AND(75>B8 ,75<C8),”In Range”,”Out of Range”) it return In Range. As both criteria is True so, it show text In Range other than it show Out of Range.

## Keep Reading Similar Functions:

### OR

The OR function is a logical operator that returns TRUE if the condition matches i.e. =OR(A1=10, A1=100) check cell A1 contains either 10 or 100.

### SWITCH

The SWITCH function lookup a value in a list of multiple data points and return the corresponding first match otherwise default value or #N/A return.

### XOR

The XOR function returns TRUE when only one of the logic or condition is true. It returns TRUE if only one is right, not ‘at least one’ like OR function.