You haven’t heard about it? Don’t worry, even Microsoft has no information about this feature, unless you dig way back into its archives where you’ll find that the calculator – which formerly held a prominent position on the Tools Menu – was driven underground in Word 6.0 to make way for the far more cumbersome, albeit more powerful, formula field.
You’ve probably heard the stats: 80% of Microsoft Word users make use of only 20% of its features. My guess is that only about 0.1% of Word users use the handy calculator built right into Word.
I’m not talking about the SUM() and AVERAGE() fields or any of the other useful but not particularly elegant mathematical tools. I’m talking about a simple, straightforward calculator which lets you perform any basic arithmetical operation anywhere within Word.
You haven’t heard about it? Don’t worry, even Microsoft has no information about this feature, unless you dig way back into its archives where you’ll find that the calculator – which formerly held a prominent position on the Tools Menu – was driven underground in Word 6.0 to make way for the far more cumbersome, albeit more powerful, formula field.
It’s true Windows comes with a more advanced calculator built in, but if you spend your days working in Word, nothing beats having a calculator right there in front of your nose at all times.
UNEARTHING THE CALCULATOR
Because Microsoft has buried the calculator so thoroughly, you’ll need to resurrect it before putting it to use. That means sticking it on a toolbar. In Word 2007, you’ll have to put it on the Quick Access toolbar:
- Right-click the Quick Access toolbar and select Customize Quick Access Toolbar from the pop-up menu.
- Make sure For All Documents is selected in the Customize Quick Access Toolbar drop-down box.
- In the Choose Commands From drop-down box, select Commands Not In The Ribbon. (Side note: Perusing this list is highly educational for old-time Word users pining for lost commands.)
- Locate Calculate in the list and double-click it to add it to the list of Quick Access commands, then click OK.
In Word XP/2003, do this:
- Right-click any of your toolbars and choose Customize from the pop-up menu.
- Click the Commands tab in the Customize dialog.
- In the Categories list click Tools and in the Commands list scroll to Tools Calculate.
- Click and drag the Tools Calculate command onto any of your toolbars.
- To display a more compact icon, right-click the Tools Calculate button on the toolbar, select Change Button Image and pick the calculator icon. Right-click the Tools Calculate button once more and select Default Style. Then click Close.
USING THE CALCULATOR
With the Calculator now ensconced on a toolbar, you’re ready to give it a whirl.
Just enter a simple formula, select the entire text and click your new Calculator button. Word will work out the result, display it on the status bar and copy the number into the clipboard for you to paste.
The formulas can be similar to those you learnt at school but the feature also works in blocks of text you don’t normally think of as formulas.
WHAT THE CALCULATOR DOES
The calculator handles addition, subtraction, multiplication, division, percentages, exponentiation and roots. It takes six operators:
Addition: +
Subtraction: – or place the number to be subtracted in parentheses, ( )
Multiplication: *
Division: /
Percentages: %
Exponentiation and roots: ^
If you omit the operator, the calculator assumes you want to add the numbers. So you can write:
235 79 9412 17.95 432.82
then select the numbers and click the Calculator button. The result (10176.77) is displayed, briefly, in Word’s status bar. The result is also stored on the clipboard, so you can press Ctrl+V to paste it into your Word document, or copy it to another program.
Things that don’t look like formulas
Unlike formula fields, the calculator works anywhere, including in paragraphs containing intervening text. This turns the in-line calculator from a nerdy trick into something you really can use.
Thus if you use the calculator on the following sentence:
At the dinner there were 13 doctors, 25 cosmologists, 53 seismologists and 219 assorted hangers on.
the total number at the dinner will be calculated.
Only digits are recognised, which is something to watch if you use words for small numbers and digits for larger ones. A sentence like “Regrets were received from four maids a milking and 12 drummers drumming.” will add up to 12 – not 16.
You can also use the Calculator in tables to tot up numbers in columns, in rows or in the whole table. As in ordinary text, use parentheses around a number or a minus sign before it to denote a negative number in the table.
Take care: although it’s possible to select numbers in non-adjacent cells in a table by holding down the Ctrl key while you select each cell, the calculator will not give you a correct total if you try to add these numbers. Your selection must contain contiguous cells, rows or columns.
TRY IT OUT
Try out a few simple examples to get an idea of what you can do with the calculator:
Simple addition and subtraction: 12+9-17.5
Simple multiplication: 123*52
Simple division: 9.3/7
Calculating a percentage: 3422*17%
Exponentiation: 7^4
Calculating a cube root: 1728^(1/3)
Note that you don’t need to use an equals sign; in fact, Word will give you an “!Unexpected end of formula” error if you do.
ORDERING
The calculator uses operator precedence and parentheses to determine the order of calculations in more complex expressions. For example:
12+9*2^3
gives you the answer 84, while:
12+(9*2)^3
produces the result 5844.
If you don’t include parentheses in an expression, Word performs operations in this order:
1. percentage
2. power and root
3. multiplication and division
4. addition and subtraction.
MIND YOUR PARENTHESES!
When using parentheses, you need to keep your wits about you. Take these four expressions:
17(8)
17(2^3)
17*(8)
17*(2^3)
The results are, respectively, 9, 25, (136) and 136. In the first example, the calculator subtracts 8 from 17; in the second, it adds 8 (2 raised to the 3rd power) to 17; in the third, it multiplies 17 and -8; and in the last it multiplies 17 by 8. The second expression, in particular, is worth noting: the calculator performs the expression within the parentheses and then discards the parentheses, resulting in a final expression of:
17 8
The two figures are then added to produce 25.
Uninstall / Remove
You can’t uninstall the Word calculator; it’s one of the embedded albeit hidden parts of the program.
But toolbar buttons can be removed from a toolbar, just like any other toolbar icon. In essence you reverse the instructions above for adding a button to the toolbar.
In Word 2007 just return to the Customize Quick Access Toolbar. On the right is a list of buttons on the QAT, click on the one you want to remove and click the Remove button (just below the Add button).
For earlier versions of Word – open up the Customize dialog again then go to the toolbar and drag the icon off the toolbar. In other words, to add a icon you drag from the Customize dialog to the toolbar – to remove drag an icon away from the toolbar while the Customize dialog is open.
