• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel Formulas Order of Operations

## The Order followed by Excel for Formulas with Multiple Mathematical Operations

Excel's Order of Operations for Formulas

Excel Order of Operations

If more than one operator is used in a formula, there is a specific order that Excel will follow to perform these mathematical operations.

This order of operations can be changed by adding brackets to the equation. An easy way to remember the order of operations is to use the acronym:

BEDMAS

The Order of Operations is:

Brackets
Exponents
Division
Multiplication
Subtraction

How the Order of Operations Works

Any operation(s) contained in brackets will be carried out first followed by any exponents.

After that, Excel considers division or multiplication operations to be of equal importance, and carries out these operations in the order they occur left to right in the equation.

The same goes for the next two operations – addition and subtraction. They are considered equal in the order of operations. Which ever one appears first in an equation, either addition or subtraction, is the operation carried out first.

Ted French