Math Operators

For writing formulas, Excel has a standard set of math operators for performing addition, subtraction, multiplication, and exponentiation (raising to the power of). In addition, Excel supports grouping with parentheses, and concatenation. Excel also provides support for cell ranges, and range intersects. The symbols used for these operations are summarized in the table below.
Symbol | Operation | Example |
---|---|---|
+ | Addition | =2+3=5 |
- | Subtraction | =9-2=7 |
* | Multiplication | =6*7=42 |
/ | Division | =9/3=3 |
^ | Exponentiation | =4^2=16 |
() | Parentheses | =(2+4)/3=2 |
& | Concatenation | ="Z"&100="Z100" |
: | Range | =SUM(F5:F7)=6 |
space |
Range Intersect | =A1:A3 A2:C2=A2 |
Excel also provides a huge number of specific functions.