How to Perform Calculations in Microsoft Word

Microsoft Word can calculate totals and simple formulas in tables, so you can check figures without leaving your document. You’ll enter a formula in a table cell, then update it whenever the figures change; this is useful for invoices, budgets, schedules, and other documents with small calculations.

What You’ll Need

• A desktop version of Microsoft Word for Windows or Mac. Word for the web may not offer the same formula tools, so use the desktop app if you cannot find them.
• A document containing a table, or permission to insert one.
• The numbers you want to calculate, entered as plain numbers in table cells.

Step-by-Step

1. Put your numbers in a table. Choose Insert > Table and select enough rows and columns. Put each number in its own cell. For a column of prices, for example, place each price in a separate row and leave a final row for the total. Avoid typing currency symbols or explanatory words in the cells you want Word to calculate.
2. Select the result cell. Click in the blank cell where you want the answer to appear. For a column total, this is usually the cell beneath the last number. Word needs the cursor inside the table cell; clicking just beside the table will not work.
3. Open the formula command. On Windows, click the contextual Table Layout tab that appears when the table is selected, then choose Formula in the Data group. In some versions the tab is labeled Layout under Table Tools. On Mac, look for Table Layout and Formula after clicking in a table. Tab names and placement can vary slightly by version.
4. Choose or enter a formula. In the Formula dialog, Word may suggest a formula based on the cell’s position, such as =SUM(ABOVE). Check that it describes the cells you intend to use. You can type a formula directly, such as =SUM(LEFT) to add numeric cells to the left, or =AVERAGE(ABOVE) to average numeric cells above.
5. Set the number format if needed. Use the Number format menu in the dialog to choose how the result appears, such as 0.00 for two decimal places or a percentage format when appropriate. Formatting changes the displayed result, not the underlying calculation. Click OK to insert the result.
6. Use supported operators for other calculations. Word formulas can use arithmetic operators: + for addition, - for subtraction, * for multiplication, and / for division. For example, if two values are in the cells immediately to the left, a formula such as =PRODUCT(LEFT) multiplies them. Word also supports functions including SUM, AVERAGE, COUNT, MAX, and MIN. Formula support is limited compared with Excel; test a less familiar function in a copy of your document.
7. Update the answer after changing inputs. Word’s formula results are fields, not live spreadsheet cells. If you change a number, right-click the result and choose Update Field. To refresh multiple formula results, press Ctrl+A on Windows or Command+A on Mac to select the document, then press F9 on Windows. On a Mac, the function-key behavior may depend on keyboard settings; use the context menu’s Update Field if needed.
8. Check the result and save. Recheck the input cells, formula direction, and displayed precision. For important totals, verify the arithmetic independently or in a spreadsheet before sharing the document.

Common Mistakes

• Expecting automatic recalculation: Word does not reliably refresh a formula as soon as you edit a value. Update the field after changing its inputs.
• Using the wrong direction: ABOVE includes applicable numeric cells above the formula cell; LEFT uses cells to its left. Make sure the layout matches the formula.
• Putting labels among the numbers: Words such as “Total” are generally ignored, but text or symbols mixed into numeric entries can make results confusing. Keep labels in separate cells and enter values as numbers.
• Assuming the result is a live link to Excel: A Word formula does not provide a spreadsheet’s full recalculation, charting, or data-management features.
• Rounding too early: A number format can hide decimal places without changing the stored calculation. Do not copy a rounded display value into another calculation if precision matters.

Tips

• Use =SUM(ABOVE) or =SUM(LEFT) for straightforward row and column totals. These directional formulas are easiest to maintain when the table stays organized.
• Use consistent units and number formats in a column. Do not add amounts in different currencies or measurements without converting them first.
• Leave a clear header row and label the result, such as “Total” or “Average,” so readers can tell what the figure means.
• If you will change figures frequently, need formulas that refer to specific cells, or need complex calculations, do the work in Excel and insert or link the result in Word. A linked object may require access to its source file to update.
• Before printing or sending a final copy, update fields and inspect the document in print preview so stale results are less likely to go unnoticed.

Troubleshooting

• There is no Formula button: Click inside a table cell first. The table-specific layout tab only appears when the cursor is in a table. If you are using Word in a browser, open the document in the desktop app and check again.
• The formula is missing or appears as text: Make sure you inserted it using the Formula command and that it begins with an equals sign. If you see a field code instead of a result, select it and update the field; field-code display can also be toggled with Alt+F9 on Windows.
• The answer is zero or incorrect: Check that the referenced values are in the expected cells, are numeric, and are in the direction named by ABOVE or LEFT. Reinsert the formula if the table was rearranged.
• Changes do not appear: Right-click the result and select Update Field. If you selected the whole document and pressed F9, confirm that the result is a formula field and not ordinary typed text.
• The displayed number looks wrong: Open the Formula dialog again to inspect the number format. A percentage or decimal format can make a correct underlying value look unexpected.

Frequently Asked Questions

Can Word add numbers in a table?
Yes. Put the numbers in table cells, select the result cell, and use =SUM(ABOVE) or =SUM(LEFT) as appropriate.

Does Word recalculate formulas automatically?
Not consistently when you edit table values. Update a formula field manually, or refresh fields before finalizing the document.

Can I use a formula such as A1+B1?
Word table formulas can refer to cells by position in some formula expressions, but the interface is less flexible than Excel. For reliable cell-based calculations or complex work, use Excel.

Can Word calculate percentages?
It can perform arithmetic that includes division and multiplication. For example, a percentage can be calculated as a part divided by a total and multiplied by 100; check the result format so it is not displayed as a fraction or scaled unexpectedly.

Can I do calculations in Word for the web?
Availability of table formula features can differ from the desktop app. If you cannot find the Formula command, open the file in desktop Word or calculate the values in a spreadsheet.

Can I use Word for complex calculations?
Word is suited to simple calculations inside tables. Use Excel for larger datasets, complex formulas, frequent updates, or calculations that must recalculate automatically.

Related

• How to Save Your Laptop From Spills
• How to Use Microsoft Designer to Make AI Images
• Fix iOS 10’s Biggest Annoyances: Practical Settings