Microsoft Office Tutorials and References

In Depth Information

**AND**

AND
AND
returns
TRUE
if all the arguments are true in the formula, and
FALSE
if any one argument

is false.

=AND(logical1,logical2,...)

The
AND
function can operate on text, numbers, or cell references. The
AND
function alone

ser ves as a simple logical test function. However, when it is combined with other formulas,

the
AND
function gives you the ability to combine several tests into one, then apply the results

depending on whether the test result is true or false. Notice the example in Figure 8.1. The

AND
function operates on the text applying False if the range appears with a false categor y.

However, in the range C5:D5, all tests are True, thus applying the True Result. Notice the

second and third examples in Figure 8.1. The
AND
function is combined with
IF
to perform a

logical test on multiple combinations. The example in cell F12—
=IF(AND(C12>10,C12<30),

”QUALIFY”)
—states, if the value in C12 is greater than 10 and the value in C12 is less than 30,

apply the text QUALIFY. Conditions/tests/arguments in the
AND
function must be met for the

person to QUALIFY. If the next test applies the same logic, except the result as false.

This is the value of 1 to 30 conditions you wish to test.

The test results in a logical True or False return.

LOGICAL VALUE 1, 2, ...

When using text results within formulas, it’s important to note that the text must be enclosed with

quote symbols. Also, talk through the formula as expressed in the previous sentence.

TIP

The last example applies the same logic, however, it uses cell referencing.

A

Logical True or False

B

Parameters within the formula

Figure 8.1

The
AND
logical

function can stand alone

as a logical test, or be

used in conjunction

with other functions

such as
IF
to test

multiple condtions.

C

The formula

with cell

referencing