Hi Dudes!
Microsoft Office Word allows you to do various types of calculations in Tables by the means of using different formulas.
You can perform calculations and logical comparisons in a table by using formulas. The Formula command is found on the Table Tools, Layout tab, in the Data group.
What is Formula:
A formula in Word automatically updates when you open the document that contains the formula. You can also update a formula result manually.
How to Insert a Formula:
Select the table cell where you want your result. If the cell is not empty, delete its contents.
On the Table Tools, Layout tab, in the Data group, click Formula.
Use the Formula dialog box to create your formula. You can type in the Formula box, select a number format from theNumber Format list, and paste in functions and bookmarks using the Paste Function and Paste Bookmark lists
*More will be discussed in Excel Episodes.
Microsoft Office Word allows you to do various types of calculations in Tables by the means of using different formulas.
You can perform calculations and logical comparisons in a table by using formulas. The Formula command is found on the Table Tools, Layout tab, in the Data group.
What is Formula:
A formula in Word automatically updates when you open the document that contains the formula. You can also update a formula result manually.
How to Insert a Formula:
Select the table cell where you want your result. If the cell is not empty, delete its contents.
On the Table Tools, Layout tab, in the Data group, click Formula.
Use the Formula dialog box to create your formula. You can type in the Formula box, select a number format from theNumber Format list, and paste in functions and bookmarks using the Paste Function and Paste Bookmark lists
Examples:.
DESCRIPTION FORMULA TO WRITE
Above the cell =SUM(ABOVE)
Below the cell =SUM(BELOW)
Above and below the cell =SUM(ABOVE,BELOW)
Left of the cell =SUM(LEFT)
Right of the cell =SUM(RIGHT)
Left and right of the cell =SUM(LEFT,RIGHT)
Left of and above the cell =SUM(LEFT,ABOVE)
Right of and above the cell =SUM(RIGHT,ABOVE)
Left of and below the cell =SUM(LEFT,BELOW)
Right of and below the cell =SUM(RIGHT,BELOW)
FORMULAS:
ConversionConversion EmoticonEmoticon