Tuesday, October 29, 2013

CALCULATION FORMULA IN MS WORD


Inserting Formulas

To insert a formula, determine the values or cell references required for the formula and then follow these instructions:
  1. Place your insertion point in the cell where you want to place the formula
  2. From the Layout tab, in the Data group, click FORMULAFormula button
    The Formula dialog box appears.
    HINT: Similar to Excel, based on the numbers in the table and the location of the cell in which you want to place the formula, Word will guess what type of formula you may want (e.g., to add all cells to the left of the formula, =SUM (LEFT) may be placed in the Formula text box).
    Formula dialog box
  3. In the Formula text box, type the desired formula
  4. If necessary, from the Number format pull-down list, select the desired format for the result
  5. Click OK
    The formula is inserted.

return to topRecalculating Formulas

To update values in a table, recalculate the formula(s) using one of the following methods.

Recalculate the Value of an Individual Cell: Keyboard Option

  1. Place your insertion point in the cell, before the numerals
  2. Press [F9]
    OR
    Press [Alt] + [Shift] + [U]
    The formula is recalculated.

Recalculate the Value of an Individual Cell: Mouse Option

  1. Place your insertion point in the cell, before the numerals
  2. Right click the cell » select Update Field
    The formula is recalculated.

Recalculating the Values of the Entire Table

  1. Place your insertion point within the table
  2. From the Layout tab, in the Table group, click SELECT » select Select Table
    Select button and menu
    The entire table is selected.
  3. Press [F9]
    OR
    Press [ALT] + [Shift] + [U]
    All formulas are recalculated.

No comments:

Post a Comment