Specify the order of operations used for evaluating formulas in MS Excel ?

Asked 15-Dec-2017
Viewed 1413 times
Ask Question

0

Specify the order of operations used for evaluating formulas in Excel ?

Anonymous User
asked by Anonymous User in technology
Answer Add comment

1 Answer

0

The order of operations used for evaluating formulas in Excel is same as in standard mathematics. Its defined by the term “BEDMAS” OR “PEDMAS”
The order of operations for Excel is as follows:
Parentheses "( ) "
Exponents
Division
Multiplication
Addition
Subtraction

Add comment
Hemant Patel
answered 15-Dec-2017 by Hemant Patel
MindStick Training