Formulas are equations that perform calculations on values in your Excel Work Book.
A formula starts with an equal sign (=).
1 / create a simple formula
2 / create a formula that refers to other cells
Example formula | Effect |
= C2 | Uses the value in cell C2 |
= Sheet2! B2 | Uses the value of cell B2 on Sheet2 |
- Click the cell in which you want to enter the formula.
- in the formula bar,

- type = (equal sign).
- then select a cell (or a range of cells, a location on another worksheet ..)

- press enter
- add a "logical operator"
eg +, -, / ...
- and repeat as often as necessary with other cells
Post a Comment