The
AND() function returns TRUE when the logical
value of all its arguments are TRUE.
- The syntax for the function
is AND (logical 1, logical 2, logical
3.....).
Where "logical
1" represents the logical value of
the first argument of the function.There
can be up to 255 arguments to this function
If one or more of these arguments has a
logical value of FALSE then the AND function
will return a logical value of FLASE to
the cell.
For example:
AND (TRUE, TRUE, TRUE, TRUE, FALSE, TRUE,
TRUE, TRUE) = FALSE as not all of the arguments
have a logical value of true.
|
