Advanced calculations in tables--Question 1

[DeeDeeCee]

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

 

[Jay Freedman]

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}.

 

[DeeDeeCee]

Jay, you are OKAY! That worked pretty well. Thanks.
ddc