Excel TutorialLesson 15Free preview

Excel Arithmetic Operators

This lesson is part of Excel · All levels

Summary

Excel supports the standard arithmetic operators: + for addition, - for subtraction, * for multiplication, / for division, and ^ for rank. The percent symbol works directly as a denominator of 100, so 50% is 0.5. The operator & is used to combine text, not numbers, and the entire operator follows the sequence of mathematical operations.

Key points

Major operators: +, -, *, /, and ^ for rank
Percentage is written as %, for example 100*10% = 10
The order of operations: rank first, then * and /, new + and -
Operator & combines text from two cells

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.