GCFLearnFree.org

You people are utterly amazing. I use and recommend you all the time!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2003
  • Creating Simple Formulas

Excel 2003

Single page view print copy

Creating Simple Formulas

Creating simple division formulas

Creating division formulas is similar to the addition, subtraction, and multiplication formulas. To divide the contents of cell B2 by cell B3, you would need to insert a division operator, or /, between them: =B2/B3.

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

Simple Division Formula

  • 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 defined.
  • Click the first cell to be included in the formula (B2, for example).
  • Type a mathematical operator (the division symbol, or /). The operator displays in the cell and 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. This step ends the formula.
previous next
previous 1 2 3 4 5 6 7 8 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.