# Excel AND Function | Formula Examples + FREE Video

## Excel AND Function (Example + Video)

### When to use Excel AND Function

Excel AND function can be used when you want to check multiple conditions.

### What it Returns

It returns TRUE if all the conditions evaluate to TRUE, else it returns a FALSE (Note: it would return FALSE even if one condition is FALSE).

### Syntax

=AND(logical1, [logical2],…)

### Input Arguments

• logical1 – the first condition that you want to evaluate for TRUE or FALSE.
• [logical2] – (Optional) This is the second condition that you want to evaluate for TRUE or FALSE.

• AND function can be used with other formulas to be more efficient.
• For example, in an IF Function, you can test a condition and then specify a value when it’s TRUE and a value when it is FALSE. Using AND function within IF enables users to test multiple conditions at one go.
• For example, if you have to test whether if A1 is greater than 0 and less than 100, here is how you can do it in an IF function:
=IF(AND(A1>0,A1<100),”Approve”,”Reject”)
• The arguments must either evaluate to logical values (TRUE/FALSE), or the arguments must be arrays/references of logical values.
• Text and empty cells are ignored.
• If the specified range contains no logical values, the AND function returns #VALUE! error.
• You can test a maximum of 255 conditions in a single AND function.

## Excel AND Function – Video Tutorial

Related Excel Functions:

FREE EXCEL BOOK

## Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

### 2 thoughts on “Excel AND Function | Formula Examples + FREE Video”

1. It’s really helped in understanding lookup functions. Thanks!