19:53:00
AND function and ways to use
This article describes the formula syntax and usage of the
AND function (function: A prewritten formula that takes a value or values,
performs an operation, and returns a value or values. Use functions to simplify
and shorten formulas on a worksheet, especially those that perform lengthy or
complex calculations.) in Microsoft Excel.
Description
Objective: Returns TRUE if all its arguments evaluate to
TRUE; returns FALSE if one or more arguments evaluate to FALSE.
One common use for the AND function is to expand the
usefulness of other functions that perform logical tests. For example, the IF
function performs a logical test and then returns one value if the test
evaluates to TRUE and another value if the test evaluates to FALSE. By using
the AND function as the logical_test argument of the IF function, you can test
many different conditions instead of just one.
Syntax
AND(logical1, [logical2], ...)The AND function syntax has
the following arguments (argument: A value that provides information to an
action, an event, a method, a property, a function, or a procedure.):
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.
Remarks
The arguments must evaluate to logical values, such as TRUE
or FALSE, or the arguments must be arrays (array: Used to build single formulas
that produce multiple results or that operate on a group of arguments that are
arranged in rows and columns. An array range shares a common formula; an array
constant is a group of constants used as an argument.) or references that
contain logical values.
If an array or reference argument contains text or empty
cells, those values are ignored.
If the specified range contains no logical values, the AND
function returns the #VALUE! error value.
Examples 1
.png)
Examples 2
.png)
