Exceljet

Quick, clean, and to the point

Excel AND Function

Excel AND function
Summary 

The AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0,A1<10). The AND function can be used as the logical test inside the IF function to avoid extra nested IFs, and can be combined with the OR function.

Purpose 
Test multiple conditions with AND
Return value 
TRUE if all arguments evaluate TRUE; FALSE if not
Syntax 
=AND (logical1, [logical2], ...)
Arguments 
  • logical1 - The first condition or logical value to evaluate.
  • logical2 - [optional] The second condition or logical value to evaluate.
Usage notes 

Use the AND function to test multiple conditions at the same time, up to 255 conditions. Each logical condition (logical1, logical2, etc.) must evaluate to TRUE or FALSE, or be arrays or references that contain logical values.

For example, to test if the value in A1 is greater than 0 and less than 5, use the following formula:

=AND(A1>0,A1<5)

It can be useful to extend the functionality of functions like IF with AND. Using the above example, you can supply AND as the logical_test for the IF function like so:

=IF(AND(A1>0,A1<5), "Approved", "Denied")

This formula will return "Approved" only if the value in A1 is greater than 0 and less than 5.

Notes:

  • Text values or empty cells supplied as arguments are ignored.
  • The AND function will return #VALUE if no logical values are found or created during evaluation.

Excel Formula Training

Learn Excel formulas and functions with concise, clear videos. Master absolute/relative addresses, dates, text, named ranges, and tools for troubleshooting. Each video comes with a practice worksheet and audio transcript. Instant access and complete 100% guarantee. Start today!

See details.

Just wanted to thank you for this website. I've got it saved in my favorites and cannot express how beneficial it has been. - AZ
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course