Transcript Mathmetical Operators and Order

Operators and Order

To perform basic mathematical operations such as addition,
subtraction, or multiplication; combine numbers; and produce
numeric results
Arithmetic operator
Meaning (Example)
+ (plus sign)
Addition (3+3)
– (minus sign)
Subtraction (3–1)
Negation ( –1 )
* (asterisk)
Multiplication (3*3)
/ (forward slash)
Division (3/3)
% (percent sign)
Percent (20%)
^ (caret)
Exponentiation (3^2)

Excel formula follows the same order of operations as mathetics.
Operation Order
- Negation ( -1 )
% Percent
^ Exponentiation
* and / Multiplication and Division
+ and – Addition and Subtraction
• Use parentheses to change the order.
2+3*28
 (2 + 3) * 2  10
1
+ 3 * 3 / 4.5 * ( 3 – 1 )
a)
b)
c)
d)
e)
1 + 3 * 3 / 4.5 * 2
1 + 9 / 4.5 * 2
1+2*2
1+4
5