Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
In an Invoice template...
How can I calculate Qty (column a) * Unit Price (column c) = $amount (column d) in each of several rows. Then, at the bottom insert a formula to subtotal the $amount column. Then, multiply the subtotal by .07 (sales tax) and put that in the next cell under. Then, add the sales tax and subtotal. Sure this very basic but I've spent all morning trying to no avail. -- Thanks, Frank |
#2
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
Have you looked at these Help topics?
Field codes: = (Formula) field Perform calculations in a table Referencing cells in a table -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Frank" wrote in message ... In an Invoice template... How can I calculate Qty (column a) * Unit Price (column c) = $amount (column d) in each of several rows. Then, at the bottom insert a formula to subtotal the $amount column. Then, multiply the subtotal by .07 (sales tax) and put that in the next cell under. Then, add the sales tax and subtotal. Sure this very basic but I've spent all morning trying to no avail. -- Thanks, Frank |
#3
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
Yes.
Also, how does one delete a formula that is incorrect? -- Thanks, Frank "Suzanne S. Barnhill" wrote: Have you looked at these Help topics? Field codes: = (Formula) field Perform calculations in a table Referencing cells in a table -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Frank" wrote in message ... In an Invoice template... How can I calculate Qty (column a) * Unit Price (column c) = $amount (column d) in each of several rows. Then, at the bottom insert a formula to subtotal the $amount column. Then, multiply the subtotal by .07 (sales tax) and put that in the next cell under. Then, add the sales tax and subtotal. Sure this very basic but I've spent all morning trying to no avail. -- Thanks, Frank |
#4
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
Hi Frank,
To see how to do this and a wide range of other calculations in Word, 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] ------------------------- "Frank" wrote in message ... In an Invoice template... How can I calculate Qty (column a) * Unit Price (column c) = $amount (column d) in each of several rows. Then, at the bottom insert a formula to subtotal the $amount column. Then, multiply the subtotal by .07 (sales tax) and put that in the next cell under. Then, add the sales tax and subtotal. Sure this very basic but I've spent all morning trying to no avail. -- Thanks, Frank |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can word do this formula =EXP(B2) in a table? | Tables | |||
how do I get this formula (A2*d2)-e2 in a word table | Tables | |||
How do I set up a formula in a table in Word? | Tables | |||
Table Formula Help | Tables | |||
formula in a table | Microsoft Word Help |