Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Table Formula
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
|
|||
|
|||
Table Formula
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
|
|||
|
|||
Table Formula
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
|
|||
|
|||
Table Formula
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 | |
|
|
Similar Threads | ||||
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 |