Page 4 of 24PREVNEXT

Get to know Excel 2007: Enter formulas

Math operators
Add (+) =10+5
Subtract (-) =10-5
Multiply (*) =10*5
Divide (/) =10/5
Excel uses familiar signs to build formulas.

To do more than add, use other math operators as you type formulas into worksheet cells.

Use a minus sign (-) to subtract, an asterisk (*) to multiply, and a forward slash (/) to divide. Remember to always start each formula with an equal sign.

Note     You could use more than one math operator in a single formula. This course covers only single-operator formulas, but you should know that if there's more than one operator, formulas are not just calculated from left to right. The rules of operator precedence and two example formulas are on the Quick Reference Card at the end of this course.

Page 4 of 24PREVNEXT