Nested IF Functions

Sometimes you can’t resolve a logical problem using only logical operators and the AND,

OR, and NOT functions. In these cases, you can nest IF functions to create a hierarchy of

tests. For example, the formula =IF(A1=100, "Always", IF(AND(A1>=80, A1<100), "Usually",

IF(AND(A1>=60, A1<80), "Sometimes", "Who cares?"))) states, in plain language, the following:

If the value is 100, return Always; if the value is from 80 through 99, return Usually;

if the value is from 60 through 79, return Sometimes; or if none of these conditions is true,

return Who cares?. You can create formulas containing up to 64 levels of nested functions.

Other Uses for Conditional Functions

You can use all the conditional functions described in this section as stand-alone formulas.

Although you usually use functions such as AND, OR, NOT, ISERROR, ISNA, and ISREF within

an IF function, you can also use formulas, such as =AND(A1>A2, A2<A3), to perform simple

conditional tests. This formula returns the logical value TRUE if the value in A1 is greater

than the value in A2 and the value in A2 is less than the value in A3. You might use this type

of formula to assign TRUE and FALSE values to a range of numeric database cells and then

use the TRUE and FALSE conditions as selection criteria for printing a specialized report.

	Created by faulkner.j over 11 years ago

A-Levels Excel (Functions) Note on Nested IF Functions and Conditional Functions, created by faulkner.j on 20/07/2013.