Exceljet

Quick, clean, and to the point

Math Operators

Excel's 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.