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

0 votes
582 views
Anonymous User asked 15-Dec-2017 in Technology by Anonymous User

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

1 Answer

0 votes
Harsh kumar srivastava answered 15-Dec-2017 by Harsh kumar srivastava
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