Microsoft Office Tutorials and References
In Depth Information
AND AND returns TRUE if all the arguments are true in the formula, and FALSE if any one argument
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.
The last example applies the same logic, however, it uses cell referencing.
Logical True or False
Parameters within the formula
The AND logical
function can stand alone
as a logical test, or be
used in conjunction
with other functions
such as IF to test