Search

# 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

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

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

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

2. Nice Article, thanks for sharing, Keep up the good work!