Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the sequence of operating mathematical operation in Excel?

user-image
Question ajoutée par Laura Popescu
Date de publication: 2014/05/26
Akram Massoud
par 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