Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
amelie amelie is offline
external usenet poster
 
Posts: 1
Default Word Table: how do you set up formula Sub-Total + 5% GST

I am using Word 2003 and have two tables in one sheet.

Table One: How do you set the formula Sub-Total + 5% GST = GST Amount.

Table Two: How do you set the formula subtracting right column to left
column = Amount
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word Table: how do you set up formula Sub-Total + 5% GST

For the GST Amount in the cell where you want it to be displayed, type

=SUM(ABOVE) * .05

and then select that and press Ctrl+F9, which will enclose it in Field
Delimiters { } as shown below.

{ =SUM(ABOVE) * .05 }

Then press Alt+F9 to toggle off the display of the field codes and press F9
to update the field so that it shows the result.

For Table Two, to subtract the entry in one cell from that in another cell,
say a cell in the second column of the second row of a table and display the
result in the third cell in that row, you would use

{ = A2 - B2 }

in the third cell. You must use Ctrl + F9 to insert the { }. You cannot
type them from the keyboard.

You cannot in Word just copy such a formula down a column however as you can
in Excel.

You might consider as an alternative, using and Excel Spreadsheet into your
document, which will allow you to make use of Excel's capabilities such as
that.

Alternatively, see fellow MVP Macropods tutorial on tutorial on formula
field coding at:

http://www.wopr.com/cgi-bin/w3t/show...?Number=365442




--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"amelie" wrote in message
...
I am using Word 2003 and have two tables in one sheet.

Table One: How do you set the formula Sub-Total + 5% GST = GST Amount.

Table Two: How do you set the formula subtracting right column to left
column = Amount


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting a table to total columns Ross Tables 19 June 6th 09 12:10 AM
Multipule Tables - Grand Total Formula Stuart Mattinson[_2_] Tables 1 May 28th 09 08:07 AM
In a Word table, how can you total up a column of figures (money)? Mikelis Tables 3 June 5th 07 05:27 AM
Total checked option buttons in a word table? scott Microsoft Word Help 3 December 4th 05 12:36 PM
Formula in table - Creating a final total from sub-total cells Anne Gilmour Tables 1 November 7th 04 05:14 AM


All times are GMT +1. The time now is 09:13 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"