Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.word.tables




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
Posted to microsoft.public.word.tables




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. reassign 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 CtrlF9 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  


Similar Threads  
Thread  Forum  
Word Table Formula  Tables  
Repeat formula down a column in a Word 2003 table  Tables  
how do I get this formula (A2*d2)e2 in a word table  Tables  
Word 2003 Table Formula Number format displays errors.  Microsoft Word Help  
Word 2003 Table cell formula  Tables 