Table of Contents### Naming Formulas

Entire Site

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. | |

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πr^{3}/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