• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Naming Formulas

In Chapter 1, you learned how to set up names for often-used constants. You can apply a similar naming concept for frequently used formulas. As with the constants, the formula doesn't physically have to appear in a cell. This not only saves memory, but it often makes your worksheets easier to read as well. Follow these steps to name a formula:

1.
Choose Insert, Name, Define to display the Define Name dialog box.

2.
Enter the name you want to use for the formula in the Names in Workbook edit box.

3.
In the Refers To box, enter the formula exactly as you would if you were entering it in a worksheet.

4.
Click OK.

Now you can enter the formula name in your worksheet cells (instead of the formula itself). For example, the following is the formula for the volume of a sphere (r is the radius of the sphere):

4πr3/3

So, assuming that you have a cell named Radius somewhere in the workbook, you could create a formula named, say, SphereVolume, and make the following entry in the Refers To box of the Define Name dialog box (where PI() is the Excel worksheet function that returns the value of Pi):

=(4 * PI() * Radius ^ 3) / 3

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint