Creating simple multiplication formulas
Creating multiplication formulas is similar to creating addition and subtraction formulas. To multiply two cells such as B2 and B3, you would need to insert a multiplication operator * between them: =B2*B3.
To create a simple formula that multiplies the contents of two cells:
- Type the numbers you want to calculate in separate cells (for example, type 128 in cell B2 and 345 in cell B3).
- Click the cell where the answer will appear (B4, for example).
- Type the equals sign (=) to let Excel know a formula is being entered.
- Click the first cell to be included in the formula (B2, for example).
- Type a mathematical operator (in this case, the the multiplication symbol *). The operator displays in the cell and in formula bar.
- Click the next cell in the formula (B3, for example).
- If you include multiple cells in the formula, repeat steps 4 and 5 until the entire formula is entered.
- Press Enter or click the Enter button on the formula bar to complete the formula.