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.

 

Related terminology 
Logical operators
Excel's logical operators are used in formulas to perform comparisons, and to build formula criteria . Logical operators can be used in formulas on their own, or combined with each other and/or other functions. The table below lists the logical...
Excel's Order of operations
Order of operations
When evaluating a formula, Excel follows a standard math protocol called "order of operations". First any expressions in parentheses are evaluated. Next Excel will solve for any exponents. After exponents, Excel will perform multiplication and...