Datasheet

125
CHAPTER 4
■
WORKING DATA MAGIC WITH CALCULATIONS
Figure 4.19. The Define Name dialog box
Why would you want to define a tax rate in a named constant value
instead of a named cell? Because it doesn’t appear in the worksheet, yet
it is available to formulas throughout the workbook and all formulas can
be updated by editing the named constant value.
To define a name for a formula (for example, a long, complex for-
mula with multiple nested segments), choose Insert

Name

Define
(shown in Figure 4.20). Type the name (for example, InvoiceNumber) in
the Names in workbook box; then select and delete everything in the
Refers to box (including =). Type =your formula (for example,
=LEFT(A3,3)&”-”&RIGHT(H5,4) ). Click OK (not Close).
Figure 4.20. Defining a formula name
T
yp
e the formula here
09_763217 ch04.qxp 1/18/06 11:23 PM Page 125