Select the cell that contains the formula you want to copy, and click the Copy button on the Standard toolbar.
Select the cell (or multiple cells) into which you want to paste the formula, and click the Paste button.
The formula automatically performs the calculation on similarly located data, placing the results into the selected cell(s).
INTRODUCTION
When you build your worksheet, you might want to use the same data and formulas in more than one cell. With Excel's Copy command, you can create the initial data or formula once and then place copies of this information in the appropriate cells.
TIP
Order of Operation
Excel first performs any calculations within parentheses. Then, it performs multiplication or division calculations, from left to right. Finally, it performs any addition or subtraction, from left to right.