Create a formula that refers to values in other cells
- Select a cell.
- Type the equal sign =.
- Select a cell or type its address in the selected cell.
- Enter an operator. For example, – for subtraction.
- Select the next cell, or type its address in the selected cell.
- Press Enter. The result of the calculation appears in the cell with the formula.