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
Nesting IIF 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
Search JabSto ::

Custom Search