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

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.

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.