PDA

View Full Version : Formula Evaluation In Excel



abhinay
08-30-2018, 11:36 PM
What is the order of operations used for evaluating formulas in Microsoft Excel?

YasserKhalil
08-31-2018, 12:22 AM
Have a look at this link
http://www.brainbell.com/tutorials/Excel-2007/operator-precedence.html

mikerickson
08-31-2018, 11:28 AM
When in doubt about the default, use parenthesis. I really helps editing the formula 6 months later (perhaps by a person who isn't you) to make things clear.

There is a tendency for some programmers/coders to write sheets that depend heavily on defaults and orders of operation and unwritten rules. IMO, this is a bad practice. Code/formulas should be written so it is quickly and easily understood. Use of parenthesis and specifying defaults (e.g. Split(aString, " ") rather than Split(aString)) is better programming, even if it takes up a few more bytes of memory.

Paul_Hossler
08-31-2018, 11:43 AM
When in doubt about the default, use parenthesis. I really helps editing the formula 6 months later (perhaps by a person who isn't you) to make things clear.

There is a tendency for some programmers/coders to write sheets that depend heavily on defaults and orders of operation and unwritten rules. IMO, this is a bad practice. Code/formulas should be written so it is quickly and easily understood. Use of parenthesis and specifying defaults (e.g. Split(aString, " ") rather than Split(aString)) is better programming, even if it takes up a few more bytes of memory.


Roger that -- the linked article mentioned parentheses 17 times