As a website designer, I can say you have one of the best learning websites.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2007

Single page view print copy

Creating Simple Formulas

To create a simple formula that multiplies the contents of two cells:

  • Select the cell where the answer will appear (E32, for example).
  • Type the equals sign (=) to let Excel know a formula is being defined.
  • Click on the first cell to be included in the formula (C9, for example), or type a number.
  • Type the multiplication symbol (*) by pressing the Shift key and then the number 8 key. The operator displays in the cell and Formula bar.
  • Click on the next cell in the formula or type a number (12, for example).
  • Press Enter, or click the Enter button on the Formula bar to complete the formula.
Multiplication Formula

To create a simple formula that divides one cell by another:

  • Click the cell where the answer will appear.
  • Type the equals sign (=) to let Excel know a formula is being defined.
  • Click on the first cell to be included in the formula.
  • Type a division symbol. The operator displays in the cell and Formula bar.
  • Click on the next cell in the formula.
  • Press Enter, or click the Enter button on the Formula bar to complete the formula.
1 2 3 4 5