Page 20 - iprime_V2.2_class8
P. 20
DIFFERENT WAYS TO ENTER FORMULAS
There are mainly two ways to enter a formula in a worksheet:
Typing the Formula Directly in the Cell: To do this, type the formula directly into the cell
after typing an equal sign (=). For example:
Formula in Cell
After entering the formula in the cell, press the
Enter key. When you press Enter, the result of
the formula will appear in the cell:
Typing the Formula in the Formula Bar: In this
method, you type the formula in the Formula
Output
Bar after selecting the cell. For example:
Formula in Formula Bar
After entering the formula, press the Enter key. The result will then appear in the selected
cell.
CELL REFERENCING IN FORMULAS AND ITS TYPES
A cell reference is an address used in a formula to denote a specific cell. A formula may contain
references to other cells, meaning the result of the formula depends on the values in these
referenced cells. If you change any of the values in the referenced cells, the result of the formula
will update automatically.
18 iPRIME (Ver. 2.2)–VIII

