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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Advanced calculations in tables--Question 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
|
|||
|
|||
Advanced calculations in tables--Question 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 follow-ups to the newsgroup so all may benefit. |
#3
|
|||
|
|||
Advanced calculations in tables--Question 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 follow-ups to the newsgroup so all may benefit. |
Thread Tools | |
Display Modes | |
|
|