Microsoft® Excel® 2010 Formulas & Functions Inside Out

Operators

The operators that can be used in Excel formulas span the entire range of commonly used symbols. These operators are listed in this section, with the most frequently used described first.

Arithmetic Operators

Arithmetic operators are used for basic calculations and return numeric values. Table 3-1 lists the arithmetic operators used in Excel formulas.

Table 3-1. Arithmetic Operators in Excel Formulas

Operator	Operation	Example Formula	Result
+	Addition	=15+13	28
–	Subtraction	=104–74	30
/	Division	=42/3	14
*	Multiplication	=5*8	40
^	Exponentiation	=2^8	256
%	Division by one hundred (percent)[a]	=140%	1.4
[a] Like algebraic signs, the percent sign is also an operator.

Sample Files

Use the Arithmetic Operators worksheet in the Chapter03.xls or Chapter03.xlsx sample ...