Excel 2007
Creating Simple Formulas
Using cell references
As you can see, there are many ways to create a simple formula in Excel. Most likely, you will choose one of the methods that enters the cell address into the formula rather than an actual number. The cell address is basically the name of the cell and can be found in the Name Box.
The following example uses actual numbers in the formula in C5.
When a cell address is used as part of a formula, this is called a cell reference. It is called a cell reference because instead of entering specific numbers into a formula, the cell address refers to a specific cell. The following example uses cell references in the formula in C30.
