Creating Simple Formulas

When using formulas in Excel XP you can add, subtract, multiply, and divide. Use simple Excel formulas to also make cell references in Excel.

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.

Simple Multiplication Formula

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.