All Tutorials

Creating multiplication formulas is very similar to addition and subtraction formulas. To multiply two cells the formula, 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 =
• Click on the first cell to be included in the formula (B2, for example).
• Type a mathematical operator (Ex: the multiplication symbol *). The operator displays in the cell and Formula bar.
• Click on 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.