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

Mechanicaleng blog

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
    • powerpoint
    • excel tips
  • 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.

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

Related posts:

Center text in cell word table by edit paragraph3 ways to center text in word table Select text in word 2016 by selection barHow to select text in word 2016 how to delete text in word 2016how to delete text in word 2016 Lower case to upper case in word 3How to auto capitalization in word 2016

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

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

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