Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
DeeDeeCee DeeDeeCee is offline
external usenet poster
 
Posts: 41
Default 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   Report Post  
Posted to microsoft.public.word.tables
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default 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   Report Post  
Posted to microsoft.public.word.tables
DeeDeeCee DeeDeeCee is offline
external usenet poster
 
Posts: 41
Default 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.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Defining tables in calculations Lenny Tables 4 August 31st 07 08:53 AM
calculations in tables LM Tables 8 June 22nd 07 03:04 PM
Advanced MS Word Template Design Question: Version 2 lettermail Microsoft Word Help 4 November 14th 06 02:23 PM
Calculations in tables oe New Users 1 April 1st 06 06:22 PM
Calculations in tables oe New Users 8 February 25th 06 11:58 AM


All times are GMT +1. The time now is 06:22 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"