The Excel AND Function



Related Function:
OR Function

Basic Description

The Excel AND function tests a number of user-defined conditions and returns a result of:

- TRUE if ALL of the conditions evaluate to TRUE
or
- FALSE otherwise (i.e. if ANY of the conditions evaluate to FALSE)

The syntax of the function is :

AND( logical_test1, [logical_test2], ... )

where the arguments, logical_test1, [logical_test2], etc, are conditions that evaluate to either TRUE or FALSE.

In Excel 2007 or 2010, you can enter up to 255 logical_test arguments to the Excel And function. However, in Excel 2003, the function can only handle up to 30 arguments.


Note that, if the logical_tests evaluate to numbers, instead of logical values, the value zero evaluates to FALSE and all non-zero values are treated as the logical value TRUE.


Excel And Function Examples

The following spreadsheet shows three examples of the Excel And function, with different conditions.

 Formulas:
  A B C
1 5 10 =AND( A1>0, A1<B1 )
2 5 10 =AND( A2>0, A2<B2, B2>12 )
3 5 10 =AND( A3<0, A3>B3, B3>12 )
 Results:
  A B C
1 5 10 TRUE
2 5 10 FALSE
3 5 10 FALSE

Note that, in the above example spreadsheet:


Further examples of the Excel And function can be found on the Microsoft Office website.


And Function Common Error

If you get an error from the Excel And Function, this is likely to be the #VALUE! error:

Common Error
#VALUE! - Occurs if any of the supplied logical_test arguments are text values
Return to the Excel Logical Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net