Select the cell where you want to enter the formula. Type an equal sign (=) to begin the formula. Enter the cell references and operators for the formula.

Press Enter and Excel calculates the result.

.

A formula can be entered by selecting cell addresses. Click the cell where you want to place the formula. Type an equal sign (=) to begin the formula. Click on the cell whose address you want to first appear in the formula. Type an operator after the value to indicate the next operation to perform. Click on the next cell to add to the formula. Press Enter to accept the formula.