Exceljet

Quick, clean, and to the point

Math Operators

Math and Formula Operators in Excel

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 also provides operators for cell ranges, range intersects, and implicit intersection. 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:F14)=55
space Range Intersect =F1:F14 A10:G10 = 6
@ Implicit intersection @F5:F14 = 10

Logical operators are summarized here. Excel also provides a very large number of built-in functions.