By Ted French, About.com
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 ( ^ )
Beginner's Guide to ExcelBasic Calculations in Excel SpreadsheetsHow to Format Excel Spreadsheets
Step-by-step advice on how to do everything from choosing a Web host to promoting your content. More >
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.
