Creating Simple Formulas

When using formulas in Excel you can add, subtract, multiply, and divide. Use simple Excel formulas to also make cell references in Excel.

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.

Select Cell

The following example uses actual numbers in the formula in C5.

Simple Addition Formula

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.

Point and Click