Reply
 
Thread Tools Display Modes
  #1   Report Post  
Bergie
 
Posts: n/a
Default in table in Word: calculate 3 things @ $20 = $60?

I do not have Excel, only MS Word. I downloaded an invoice template and I
would like to be able to do a sum total of: 3 cans of paint @ @20.00 each =
$60.00.

And, I would like to be able to do a sum total of all the products used at
the end of the invoice. Can anyone help me do this in SIMPLE terms, please?
Thanks so much.

  #2   Report Post  
Greg
 
Posts: n/a
Default

Bergie,

I am assuming that you are using a simple table. Lets say that you have a
4x10 table. Column headings are Item, Qty, Price, Sub Total.

The first item in row 2 is "Paint, 3, 20.00" and you want the subtotal in
column 4.

You need a forumula field
{ =(b2*c2) \#$,#.00 } in cell b4. Note the field code braces are inserted
with CTRL+F9.

To sum the total of column 4 subtotals you would use the formula {
=Sum(Above) }


Calculations in a simple Word formula will not update "calculate"
automatically. After creating the field, right click and select toggle field
codes. Change the qty or price and right click and select update field. The
new result will display. You can update all fields by pressing CTRL+a and
then F9. You can also instruct Word to update fields before printing
(FilePrintOptionsUpdate Fields).

"Bergie" wrote:

I do not have Excel, only MS Word. I downloaded an invoice template and I
would like to be able to do a sum total of: 3 cans of paint @ @20.00 each =
$60.00.

And, I would like to be able to do a sum total of all the products used at
the end of the invoice. Can anyone help me do this in SIMPLE terms, please?
Thanks so much.

  #3   Report Post  
Bergie
 
Posts: n/a
Default

Dear Greg:
Thanks so much for your quick reply. I will try this. Thanks....Bergie


"Greg" wrote:

Bergie,

I am assuming that you are using a simple table. Lets say that you have a
4x10 table. Column headings are Item, Qty, Price, Sub Total.

The first item in row 2 is "Paint, 3, 20.00" and you want the subtotal in
column 4.

You need a forumula field
{ =(b2*c2) \#$,#.00 } in cell b4. Note the field code braces are inserted
with CTRL+F9.

To sum the total of column 4 subtotals you would use the formula {
=Sum(Above) }


Calculations in a simple Word formula will not update "calculate"
automatically. After creating the field, right click and select toggle field
codes. Change the qty or price and right click and select update field. The
new result will display. You can update all fields by pressing CTRL+a and
then F9. You can also instruct Word to update fields before printing
(FilePrintOptionsUpdate Fields).

"Bergie" wrote:

I do not have Excel, only MS Word. I downloaded an invoice template and I
would like to be able to do a sum total of: 3 cans of paint @ @20.00 each =
$60.00.

And, I would like to be able to do a sum total of all the products used at
the end of the invoice. Can anyone help me do this in SIMPLE terms, please?
Thanks so much.

  #4   Report Post  
macropod
 
Posts: n/a
Default

Hi Bergie,

For a 'tutorial' with examples of how you can do this and much more,
download the Word document at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
(url all one line)

Cheers


"Bergie" wrote in message
...
I do not have Excel, only MS Word. I downloaded an invoice template and I
would like to be able to do a sum total of: 3 cans of paint @ @20.00 each

=
$60.00.

And, I would like to be able to do a sum total of all the products used at
the end of the invoice. Can anyone help me do this in SIMPLE terms,

please?
Thanks so much.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.778 / Virus Database: 525 - Release Date: 15/10/2004


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
How can I divide a page into three sections? Bonnie Microsoft Word Help 3 May 8th 23 02:47 AM
WordPerfect - copying formatting Morgan Page Layout 1 January 10th 05 05:00 PM
Continuous breaks convert to next page breaks Jennifer Hunt Microsoft Word Help 2 December 30th 04 05:45 PM
macro in word js Microsoft Word Help 1 December 28th 04 03:01 AM
saving the workspace Mike Microsoft Word Help 3 December 8th 04 11:32 PM


All times are GMT +1. The time now is 04:11 PM.

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

About Us

"It's about Microsoft Word"