Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.word.tables




Advanced calculations in tablesQuestion 1
Advanced for me, anyway.
Question 1: I've got an invoice template. In column C appear the hours worked, and in column D I'd like the table to automatically multiply the hours worked times the hourly rate, and fill in the result. I think there's a "product" formula that does this, but I haven't been able to figure out the syntax. Would anyone have some suggestions? Thanks. ddc 
#2
Posted to microsoft.public.word.tables




Advanced calculations in tablesQuestion 1
On Wed, 30 Sep 2009 09:49:01 0700, DeeDeeCee
wrote: Advanced for me, anyway. Question 1: I've got an invoice template. In column C appear the hours worked, and in column D I'd like the table to automatically multiply the hours worked times the hourly rate, and fill in the result. I think there's a "product" formula that does this, but I haven't been able to figure out the syntax. Would anyone have some suggestions? Thanks. ddc The syntax for the Product() function in a field to multiply two numbers together is like {=Product(3,5)}. You can replace either or both of the numbers with a cell reference. For example, to multiply the contents of the cell in row 3 and column C by the number 15, you could write {=Product(C3,15)}. And you can multiply the cell in row 3 of column C by the cell in row 1 of column A with the field {=Product(C3,A1)}. As an alternative, you can use the asterisk (*) as the multiplication operator, like {=3*5} or {=C3*15} or {=C3*A1}.  Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all followups to the newsgroup so all may benefit. 
#3
Posted to microsoft.public.word.tables




Advanced calculations in tablesQuestion 1
Jay, you are OKAY! That worked pretty well. Thanks.
ddc "Jay Freedman" wrote: On Wed, 30 Sep 2009 09:49:01 0700, DeeDeeCee wrote: Advanced for me, anyway. Question 1: I've got an invoice template. In column C appear the hours worked, and in column D I'd like the table to automatically multiply the hours worked times the hourly rate, and fill in the result. I think there's a "product" formula that does this, but I haven't been able to figure out the syntax. Would anyone have some suggestions? Thanks. ddc The syntax for the Product() function in a field to multiply two numbers together is like {=Product(3,5)}. You can replace either or both of the numbers with a cell reference. For example, to multiply the contents of the cell in row 3 and column C by the number 15, you could write {=Product(C3,15)}. And you can multiply the cell in row 3 of column C by the cell in row 1 of column A with the field {=Product(C3,A1)}. As an alternative, you can use the asterisk (*) as the multiplication operator, like {=3*5} or {=C3*15} or {=C3*A1}.  Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all followups to the newsgroup so all may benefit. 
Reply 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Forum  
Defining tables in calculations  Tables  
calculations in tables  Tables  
Advanced MS Word Template Design Question: Version 2  Microsoft Word Help  
Calculations in tables  New Users  
Calculations in tables  New Users 