From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Hierarchy of operations in formulas

Hierarchy of operations in formulas

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Hierarchy of operations in formulas

“

- If you're relatively new with formulas in Excel, you can easily write formulas that give you incorrect answers. Let's start with a real simple example here on this worksheet called Hierarchy. I'm about to write a formula to calculate percent of change. I'm going to write the form in cell C7. We're trying to measure the amount of change here. Now, you may or may not remember how to do the form. It's rather easy. We simply take the difference here. That's ten. We divide it by the starting number. So we've grown by, what, one-third here. We grow by ten. We divide that by 30. We get the answer 1/3 or 33%. And some people can do this in their heads pretty easily. As the numbers get bigger or a little bit more unusual, and some of them decrease maybe, not quite so easy. So we need a formula here. And starting with a simple idea, how do we create a formula like this? We subtract the two entries to get the difference. So C6-B6. If we did only that of course, we'd get the answer ten. No…

Contents