Home

How to Use Math Formulas in Tables in Word 2016

|
Updated:  
2016-06-05 20:41:00
|
Microsoft Copilot For Dummies
Explore Book
Buy On Amazon

No, you don't have to add the figures in columns and rows yourself; Word 2016 gladly does that for you. Word can perform other mathematical calculations as well. Follow these steps to perform mathematical calculations and tell Word how to format sums and products:

  1. Put the cursor in the cell that will hold the sum or product of the cells above, below, to the right, or to the left.

  2. On the (Table Tools) Layout tab, click the Formula button.

    Depending on the size of your screen, you may have to click the Data button first. The Formula dialog box appears, as shown. In its wisdom, Word makes an educated guess about what you want the formula to do and places a formula in the Formula box.

    A math formula in a table.
    A math formula in a table.
  3. If this isn't the formula you want, delete everything except the equal sign in the Formula box, open the Paste Function drop-down list, and choose another function for the formula.

    For example, choose PRODUCT to multiply figures. You may have to type left, right, above, or below in the parentheses within the formula to tell Word where it can find the figures you want to compute.

  4. In the Number Format drop-down list, choose a format for your number.

  5. Click OK.

Word doesn't calculate blank cells in formulas. Enter 0 in blank cells if you want them to be included in calculations. You can copy functions from one cell to another to save yourself the trouble of opening the Formula dialog box.

About This Article

This article is from the book: 

About the book author:

Peter Weverka is a veteran For Dummies author who has written about a wide variety of applications. Along with two bestselling editions of Office All-in-One For Dummies, Peter has written PowerPoint All-in-One For Dummies and Microsoft Money For Dummies.