Microsoft Excel Training | Online Excel Training

Equations

Evaluating a formula in Excel

Equations admin

BODMAS.

It’s been a while, but I still remember the shiver of apprehension that would run up my spine at the very mention of the term. If you don’t know what I’m talking about, you might want to wander over to this link.

Brings back all those algebraic memories, eh?

And the reason I bring this up is because today’s Excel tutorial talks about how Excel spares you the trouble of evaluating if you have got a complicated formula just right. Here’s how:

Imagine if you had to write a formula that would double 14, divide the result by 3, add 12 to this result and finally subtract 2 from whatever answer you got. I know, I know – this is stretching your imagination a bit, but humor me.

You’d write something like this, then, wouldn’t you (correct me if I’m wrong!)

12+(14*2)/3-2

Still, wouldn’t it be nice if Excel could walk you through this formula, step by step?

Yes it would, and yes Excel can. Here’s how:

Simply write out the formula in a cell, and go over to the Formula tab. Choose Evaluate Formula:

It goes without saying that you should click on this button making sure that you have selected the cell in which the formula has been entered, of course.

A new window should pop-up now:

Excel underlines the term it shall evaluate first (14*2). Once you click on evaluate, the result shall appear in italics in the next round of evaluation:

And so on and so forth. It’s a pretty useful trick to make sure you have got increasingly complicated formulas down just right – isn’t it?

Excel Equations: Inserting Equations in Excel

Uncategorized admin

Dealing with Excel equations is probably more useful for the academicians out there more than anybody else, but it still is a neat trick to have up your sleeve. If you’ve ever had cause to put fancy-schmancy equations in your Excel project, you know how much trouble it is to show the equations in Excel just so – subscripts, superscripts, indices, and god-alone-know-what-else – these things never work they’re supposed to.

But if you are working in Microsoft Excel (or any MS Office application, for that matter), you have help at hand. Microsoft includes a little-known, but surprisingly powerful equation editor with almost all of its Office suite.

Hidden over on the Insert tab, towards the right, the equation editor can handle almost anything you throw at it. Simply click on the button (not on the drop-down arrow!) and a new ribbon pops open.

It consists of three primary segments: Tools, Symbols and Structures.

The first section allows you to insert equation and change their look and feel. It also allows you to include normal text as a part of your equations.

Symbols is where things get interesting:

Cool, eh? The much needed +/- sign, infinity symbol(s), the Greek alphabet and much else besides. I can’t tell you how much time I’ve managed to save due to these symbols alone, let alone the full fledged equations. Which brings us to…

Structures! This section allows you to create equations just the way you want them! Fractions, fractions in parentheses, integrals, brackets and a positively bewildering array of options to turn your otherwise esoteric spreadsheet into a rocket-science document, if you so wish.

I’ll probably do a follow-up post about the equation editor, since it deserves an in-depth exploration – but really, the best way to get a feel for the editor is to simply play around with it.

If you would like to play further with these and other such features, and get more comfortable with them, check out our