Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the sequence of operating mathematical operation in Excel?

user-image
Question added by Laura Popescu
Date Posted: 2014/05/26
Akram Massoud
by Akram Massoud , FINANCE MANAGER , Autoexcellence LTD

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

Addition

Subtraction

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.