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
|