Microsoft Office Tutorials and References
In Depth Information
Defining the names
6. Click OK to close the dialog box.
7. Repeat Steps 2–6 to add two more Check Box controls, linked to cells G5
and G6.
Defining the names
This example uses quite a few names, which are listed in Table 7-1. Note that
SeriesA, SeriesB, and SeriesC are named formulas. The other names all refer to cells
or ranges. Also, note that range E2:E13 is empty. This is the range that will be used
if a series is not selected.
T ABLE 7-1 DEFINED NAMES
Name
Refers to
Month
=Sheet1!$A$2:$A$13
ProductA
=Sheet1!$B$2:$B$13
ProductB
=Sheet1!$C$2:$C$13
ProductC
=Sheet1!$D$2:$D$13
BlankRange
=Sheet1!$E$2:$E$13
ShowProductA
=Sheet1!$G$4
ShowProductB
=Sheet1!$G$5
ShowProductC
=Sheet1!$G$6
SeriesA
=IF(ShowProductA,ProductA,BlankRange)
SeriesB
=IF(ShowProductB,ProductB,BlankRange)
SeriesC
=IF(ShowProductC,ProductC,BlankRange)
The three named formulas are quite a bit different from the previous examples in
the chapter. These formulas use an IF function that checks the corresponding check
box value (stored in a cell in column G). If it’s TRUE, then the named formula
returns the range reference for the corresponding product’s data. If the check box is
not checked, the named formula returns a reference to the blank range (E2:E13).
Search JabSto ::




Custom Search