Microsoft Word on the iPad & Mac: Using Math Formulas in Tables - dummies

Microsoft Word on the iPad & Mac: Using Math Formulas in Tables

By Peter Weverka

You can do lots of cool things with tables on your iPad or Mac with Word. No, you don’t have to add the figures in columns and rows yourself; Word 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 Layout tab, click the AutoSum button.

    The Formula dialog box appears,. In its wisdom, Word makes an educated guess about what you want the formula to do and places a formula in the Formula box.

  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 the figures that you want it to compute are.

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

  5. Click OK.

    A math formula in a table.
    A math formula in a table.

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.