Microsoft Office Tutorials and References
In Depth Information
Nested Forms of the IF Function
Assume that you have two
dates: one in cell F3 and
the other in cell F4. The
date in cell F3 is your
starting date and the
date in cell F4 is the
ending date. To calculate
the work days between
the two dates (excludes
weekends), use the
For this function to work,
make sure the Analysis
ToolPak add-in is installed.
You can install it on the
Add-Ins page of the Excel
Options dialog box.
4 Click the Home tab on the Ribbon and then click the Save button on the Quick Access
Why does pressing CTRL + HOME select cell B4?
When the titles are frozen and you press CTRL + HOME , Excel selects the upper-left cell of
the unfrozen section of the worksheet. For example, in Step 1 of the previous steps, Excel
selected cell B4. When the titles are unfrozen, then pressing CTRL + HOME selects cell A1.
A nested IF function is one in which the action to be taken for the true or false
case includes yet another IF function. The second IF function is considered to be nested,
or layered, within the ﬁ rst. Study the nested IF function below, which determines the
eligibility of a person to vote. Assume the following in this example: (1) the nested IF
function is assigned to cell K12, which instructs Excel to display one of three messages in
the cell; (2) cell H12 contains a person’s age; and (3) cell I12 contains a Y or N, based on
whether the person is registered to vote.
=IF(H12>=18, IF(I12="Y","Registered","Eligible and Not Registered"),"Not Eligible to Register")
The nested IF function instructs Excel to display one, and only one, of the following
three messages in cell K12: (1) Registered; or (2) Eligible and Not Registered; or (3) Not
Eligible to Register.
You can nest IF functions as deep as you want, but after you get beyond a nest of
three IF functions, the logic becomes difﬁ cult to follow and alternative solutions, such as
the use of multiple cells and simple IF functions, should be considered.
The worksheet created thus far shows the ﬁ nancial projections for the six-month
period, from January to June. Its appearance is uninteresting, however, even though
some minimal formatting (formatting assumptions numbers, changing the column
widths, and formatting the date) was performed earlier. This section will complete the
formatting of the worksheet to make the numbers easier to read and to emphasize the
titles, assumptions, categories, and totals.