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  

Word Table: how do you set up formula Sub-Total + 5% GST



 
 
Thread Tools Display Modes
  #1  
Old July 15th, 2009, 03:34 AM posted to microsoft.public.word.tables
amelie
external usenet poster
 
Posts: 2
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  
Old July 15th, 2009, 04:05 AM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
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


 




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 11:23 AM.


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