Using Cell References in Formulas
Every cell has its own cell reference. So the first
cell in the spreadsheet would be referenced as A1, because it is in
column "A" and in the first row. A reference could be used in a formula
instead of entering the value. That way whenever the reference changes
so will
the value of the formula. This could be used effectively when a person
has constantly changing values.
Steps:
You could use any mathematical operation with cell references.
1) If cell A1 had a value of 5 and A2 had a value of 4.
2) If you wanted to multiply the two together you could insert =A1*A2 in
any cell you want

3) The value will now be 20.

4) The value is 20 because 4 multiplied by 5 is 20.
Note: When a cell reference is entered, you cannot enter the cell
reference of the cell you are entering it into. For example: =A3*A2
cannot be inserted into cells A2 and A3. |