A formula is an equation that performs operations on worksheet data. Excel formula can perform mathematical operations, such as addition and multiplication, or they can compare worksheet values or join text.
To enter a formula
· Place the cursor in the cell where the formula will appear.
· Enter an = sign.
· Enter the expression that will produce the result you want, e.g. A5+E5. This will add the value in A5 with the value in E5.
· When the formula is complete, press Enter. The result of the formula will be calculated and displayed in the cell.
· If there is an error in an Excel formula, an error message which begin with a # sign will display.
To enter a cell or range reference by pointing
· Place the cursor in the cell where the formula will appear.
· Enter the formula up to the point of the cell or range reference, e.g. to enter the formula =E2+E5, only enter the = sign.
· Using the arrow keys, move the cell pointer to the first cell reference, in this case E2. The formula will track your progress and enter the current address into the formula.
· Enter the operand, + sign.
· Using the arrow keys, move the cell pointer to the second cell reference, in this case E5. If you are calculating a range of cells, hold down the Shift key while using the arrow keys to move to the intended cells.
· Press Enter to complete the formula when you have reached the cell you require.
0 comments:
Post a Comment