What is the order of operations for Excel?

0

What is the order of operation when using excel to evaluate formular?

Post Edited
Title: Title was not descriptive.

Discussion

Please don't forget to select the answer that worked best for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1616) Apr 25, '17 at 6:05 am

1

There are three basic rules. One is the mathematical order by which the higher function is executed before the lower ranking one, for example, multiplication and division before plus or minus. To change that order you use rule No. 2 which says that expressions surrounded by parentheses are resolved before others. So, 2 + 3 * 4 = 24 but (2 + 3) * 4 = 20. The third rule applies mostly to IF conditions which tend to be resolved from inside out. That is logical because with nested conditions it is impossible to resolve the outer IF without knowing what the inner IF represents.

Your question was very broad, and so is this answer. I hope you will not prove me wrong :-)

1

Variatus has a great and thorough answer; my annoying version is just to tell you PEMDAS, which is what most western school children are taught for math problems, which happens to be the same for Excel.

1

Please End My Day At SchoolÂ

People Expect More Drugs and Sex

Pink Elephants Make Dandy Apple Sauce

Discussion

omg gebobs hahaha. At first I thought it was a weird spammer who forgot to put their link in there :P
don (rep: 1616) Apr 26, '17 at 8:59 am
Any of those is better than Please Excuse My Dear Aunt Sally.
gebobs (rep: 30) Apr 26, '17 at 10:50 am