Microsoft Office Tutorials and References

In Depth Information

**Nesting IF Functions**

Figure 12.5.

Figure 12.5.
XOR(TRUE,TRUE,TRUE)

XOR(TRUE,TRUE,TRUE) surprisingly returns

surprisingly returns TRUE

TRUE..

Nesting

Nesting
IIF
Functions

Functions

The IF function offers only two possible formulas. Either the logical test

is TRUE and the first formula is used, or the logical test is FALSE and the

second formula is used.

Many situations have a series of choices. For example, in a human resources

department, annual merit raises might be given based on the employee
’
s nu-

meric rating in an annual review, in which employees are ranked on a 5-point

scale. The rules for setting the raise are as follows:

•
4.5 or higher: 5% raise

•
4 or higher: 4.5% raise