Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Cindi Cindi is offline
external usenet poster
 
Posts: 5
Default Formula for Word 2003 Table

I'm very new to this and working by trial and error. I have a table that
makes a form and three rows (two columns - one for description - one for
data) need to calculate. It's a basic qty x price = total. How do I do this
so the total will automatically generate? I'm assuming the entry spots need
to be set as numbers instead of text, right?
--
JustLearning
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Formula for Word 2003 Table

Hi Cindy,

Assuming you're using text formfields:
1. set their type to 'number' and the default value and format to whatever you want the entry to be displayed as.
2. re-assign the formfield bookmark names as Qty# and Price#, respectively, where the # is the inex number of the field. For
example, if you've got three Qty fields, they'd be named Qty1, Qty2 and Qty3, respectively.
3. set the 'calculate on exit' property for each formfield
4. where you want the result to appear, insert a formula field coded along the lines of {=Qty1*Price1 \# "$,0.00"}. Formula fields
can be created by pressing Ctrl-F9 to create the field braces (ie '{}'), then typing the equation & formatting switches between
them.
5. To aggregate the values, you could use a formula field coded as {=Qty1*Price1+Qty2*Price2+Qty3*Price3 \# "$,0.00"} or, if the
individual costings are in a table, with a formula like {=SUM(B3:B5) \# "$,0.00"}.

--
Cheers
macropod
[Microsoft MVP - Word]


"Cindi" wrote in message ...
I'm very new to this and working by trial and error. I have a table that
makes a form and three rows (two columns - one for description - one for
data) need to calculate. It's a basic qty x price = total. How do I do this
so the total will automatically generate? I'm assuming the entry spots need
to be set as numbers instead of text, right?
--
JustLearning


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
Word Table Formula Jseakin Tables 1 April 23rd 09 08:48 PM
Repeat formula down a column in a Word 2003 table Ray Tables 8 October 21st 07 03:17 AM
how do I get this formula (A2*d2)-e2 in a word table Big dogs Tables 2 April 22nd 06 12:03 PM
Word 2003 Table Formula Number format displays errors. Mark Microsoft Word Help 2 April 6th 06 06:51 AM
Word 2003 Table cell formula Terry Tables 1 June 5th 05 08:59 AM


All times are GMT +1. The time now is 09:21 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"