AND()
Syntax. AND(logical1,logical2, ...)
Definition. This function returns the logical value TRUE only if all arguments are true. If the value of at least one argument is FALSE, the function returns FALSE.
Arguments
logical1,logical2,... Up to 30 values (in Excel 2003) or up to 255 (in Excel 2007 or 2010), entered directly or resulting from conditions that can be evaluated to TRUE or FALSE
The arguments should be logical values (TRUE or FALSE), numbers, or values from arrays or references containing logical values or evaluated to logical values.
If an argument specified as an array or reference contains text or empty cells, these values are ignored if at least one of the arguments can be evaluated.
At least one of the arguments must be a logical value, ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
