A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I create a formula in a table in a word doc?



 
 
Thread Tools Display Modes
  #1  
Old October 26th, 2007, 04:08 PM posted to microsoft.public.word.tables
Melissa
external usenet poster
 
Posts: 409
Default How do I create a formula in a table in a word doc?

I ahve this projrct that I am working on for work and it is easier done in
word. I just do not know how to do the formulas like they are in excel?
  #2  
Old October 26th, 2007, 04:34 PM posted to microsoft.public.word.tables
Stefan Blom
external usenet poster
 
Posts: 8,433
Default How do I create a formula in a table in a word doc?

Actually, the easiest approach is to create the formulas in Excel and then
embed the Excel worksheet in Word.

If you want to do the calculations in Word, you will have to use fields,
which can be inserted via the Formula dialog box.

To display the dialog box, click Formula on the Table Tools: Layout ribbon
tab (Word 2007) or use Table | Formula (Word 2003).

For more, see this (from Word Help):

*************
Perform calculations in a table
Applies to: Microsoft Office Word 2003

Do any of the following:

Total the numbers in a row or column

1.. Click the cell (cell: A box formed by the intersection of a row and
column in a worksheet or a table, in which you enter information.) in which
you want the sum to appear.
2.. On the Table menu, click Formula.
3.. If the cell you selected is at the bottom of a column of numbers,
Microsoft Word proposes the formula =SUM(ABOVE). Click OK if this is
correct.
If the cell you selected is at the right end of a row of numbers, Word
proposes the formula =SUM(LEFT). Click OK if this is correct.

Notes

a.. If you see codes between braces— for example, {=SUM(LEFT)}— instead of
the actual sum, Word is displaying field codes (field code: Placeholder text
that shows where specified information from your data source will appear;
the elements in a field that generate a field's result. The field code
includes the field characters, field type, and instructions.). To display
field code results, press SHIFT+F9.
b.. If your column or row contains blank cells, Word will not total the
entire column or row. To total the entire row or column, type a zero in each
blank cell.
c.. To quickly total a row or column of numbers, click the cell where you
want the sum, and then click AutoSum on the Tables and Borders toolbar
(toolbar: A bar with buttons and options that you use to carry out commands.
To display a toolbar, click Customize on the Tools menu, and then click the
Toolbars tab.).
Perform other calculations in a table

1.. Click the cell (cell: A box formed by the intersection of a row and
column in a worksheet or a table, in which you enter information.) in which
you want the result to appear.
2.. On the Table menu, click Formula.
3.. If Microsoft Word proposes a formula that you do not want to use,
delete it from the Formula box.
Do not delete the equal sign. If you deleted the equal sign, reinsert it.

4.. In the Paste function box, click a function. For instance, to add
numbers, click SUM.
To reference the contents of a table cell, type the cell references in the
parentheses in the formula. For instance, to add the numbers in cells A1 and
B4, the formula would read =SUM(a1,b4)

5.. In the Number format box, enter a format for the numbers. For example,
to display the numbers as a decimal percentage, click 0.00%.
Note Word inserts the result of the calculation as a field in the cell you
selected. If you change the values in the referenced cells, you can update
the calculation by selecting the field and then pressing F9.

Note Microsoft Word table (table: One or more rows of cells commonly used
to display numbers and other items for quick reference and analysis. Items
in a table are organized into rows and columns.) calculations must be
manually recalculated. Consider using Microsoft Excel to perform complex
calculations.
*************

--
Stefan Blom
Microsoft Word MVP


"Melissa" wrote in message
...
I ahve this projrct that I am working on for work and it is easier done in
word. I just do not know how to do the formulas like they are in excel?







  #3  
Old October 26th, 2007, 09:32 PM posted to microsoft.public.word.tables
macropod
external usenet poster
 
Posts: 1,231
Default How do I create a formula in a table in a word doc?

Hi Melissa,

Word's formula functions are much more limited than Excel's but, to see the kind of thing you can do, check
out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Melissa" wrote in message ...
I ahve this projrct that I am working on for work and it is easier done in
word. I just do not know how to do the formulas like they are in excel?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.