Excel can be used to calculate and analyze numerical information; however, you will need to know how to write formulas to maximize Excel’s capabilities. A formula is an equation that performs a calculation using values in the worksheet. In this lesson you will learn how to create simple formulas using mathematical operators such as the addition, subtraction, multiplication, and division signs.
Or, click this link: http://www.gcflearnfree.org/excel2007/5.1
Using Operators to enter calculations. Basic Operators include:
Using Cell References In Formulas
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.
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.