• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicalengblog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
  • About me
  • CONTACT ME
Home » microsoft office » microsoft word » Add and use word formula in table word 2016

Add and use word formula in table word 2016

July 18, 2019 by mechanicaleng blog Leave a Comment

In this tutorial, I will show how to add a word formula in a table in word 2016. You can use same for word 2007, 2010, 2013, 2019… I don’t use office word for calculation because I always use excel for my calculation. With office word you can add numbers, to find the average of numbers, or find the largest or the smallest number in table cells you specify.

Post contents

  • A. How to add a word formula?
  • B. The cell formula.
    • Share this
    • Related

A. How to add a word formula?

You can add a word formula by following these step below.

1. Open your word file that you want to add a formula.

2. For this tutorial, I will use sum formula in the table, click the cell that you want to sum of the row.

word formula button

3. Click the Layout tab and then click the Formula button. The formula box will appear. Typing the formula that you want to use in the formula box. The default, you can see the formula is sum(left). You can select a number format using Number Format List Box to display the result or you can change the formula using the Formula List Box.

word formula box

4. Click OK to create a formula in the table in word. After click OK button, you can see the result in the cell.

formula result

 

B. The cell formula.

In the formula box, you can see some formula, it can use same excel. I will view some formula below.

NO Formula Description
1 ABS() The number to get the absolute value of.
2 AND() Returns TRUE if all of the arguments evaluate to TRUE.
3 AVERAGE() The average of a list of cells
4 COUNT() The number of items on a list of cells
5 IF() Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false.
6 INT() Rounds a number down to the nearest integer.
7 MAX() The largest value on a list of cells
8 MIN() The smallest value on a list of cells
9 PRODUCT() The multiplication of a list of cells
10 ROUND()
11 SUM() The sum of a list of cells

Following is useful points help you to construct a word cell formula.

No Cell References and Description
1 A single cell reference, such as B3 or F7
2 A range of cells, such as A4:A9 or C5:C13
3 A series of individual cells, such as A3, B4, C5
4 ABOVE, referring to all cells in the column above the current cell.
5 BELOW, referring to all cells in the column below the current cell.
6 LEFT, referring to all cells in the row to the left of the current cell
7 RIGHT, referring to all cells in the row to the right of the current cell

Share this

  • Twitter
  • Pinterest
  • LinkedIn
  • Facebook
  • Email

Related

Filed Under: microsoft word Tagged With: word tips

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • How to set password for a Word document
  • How to insert header and footer in excel?
  • split columns and inserting word art in Word
  • 2 ways to create border in excel
  • Add a caption for a picture in word
  • insert math formulas and copyright logo in Word
  • How to automatically create backup in Word
  • How to hide and show a paragraph in word
  • 6 ways to remove background color in word
  • How to add leading zeros in excel

Copyright © 2021 · Magazine Pro on Genesis Framework · WordPress · Log in

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.