1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 Formulas Step by Step Tutorial

By , About.com Guide

5 of 6

Mathematical Operators in Excel Formulas

The mathematical operator keys on the number pad are used to create Excel Formulas.

The mathematical operator keys on the number pad are used to create Excel Formulas.

© Ted French

Mathematical Operators

Creating formulas in Microsoft Excel is not difficult. Just combine the cell references of your data with the correct mathematical operator.

The mathematical operators used in Excel formulas are similar to the ones used in math class.

  • Subtraction - minus sign ( - )
  • Addition - plus sign ( + )
  • Division - forward slash ( / )
  • Multiplication - asterisk ( * )
  • Exponentiation - caret ( ^ )
Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel 2003
  5. Mathematical Operators - Using Mathematical Operators in Excel Spreadsheets

©2009 About.com, a part of The New York Times Company.

All rights reserved.