For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Logical

AND Function

Returns TRUE if all of its arguments are TRUE, otherwise returns FALSE


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

AND(logical1, logical2, ...)

  • logical1  Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.
  • logical2, ...  Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.

Applies To

Excel 2003 and above

Remarks

The arguments should be logical values, arrays, or references.

Text and empty cells are ignored.

If the specified range contains no logical or numeric values, AND returns the #VALUE! error.

Excel 2003 and above

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples for Excel's AND function

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards