A formula is an equation which performs calculations between cells in a worksheet or table. A formula always begins with an equal sign. A simple formula may contain cell references and operators.
To enter a formula:
Clicking a cell will add it to the formula as a reference. |
|
If a formula has more than one operator, Excel will perform mathematical operations in this order:
|
|
You can also enter a formula by selecting the cell and typing the formula in the formula bar. |