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




Using Formulas in a Table
I'm using one of the Invoice Templates. I need to know how to set up the
formula so that it will automatically take the quantity and multiply it by the unit price. I've tried several ways, and i can't get it to work. Can anyone PLEASE help me?? Thanks. 
#2
Posted to microsoft.public.word.tables




Using Formulas in a Table
Hi TJ
Unlike Excel, Word tables don't automatically recalculate. You can get calculations in a document to update automatically when they're in a document protected for forms and: 1) at least one of the inputs for the calculation is gained from a formfield; and 2) the formfield's properties are set to 'calculate on exit'. The calculation fields can be created by pressing CtrlF9 to create the field (denoted by a pair of field braces (ie '{ }')) and: 3) if the calculation only references cells within the table, inputting the formula along the lines of '=A1*B1' between the field braces; or 4) if the calculation references fields outside the table, inputting the formula along the lines of '=BkMrk1*BkMrk2' between the field braces, where 'BkMrk1' and 'BkMrk2' are the formfield bookmark names. You can also use '=BkMrk1*A1' if the calculation references cells within the table and fields outside the table. For more information on tables and calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgibin/w3t/show...?Number=365442 Cheers  macropod [MVP  Microsoft Word] "TJ" wrote in message ...  I'm using one of the Invoice Templates. I need to know how to set up the  formula so that it will automatically take the quantity and multiply it by  the unit price. I've tried several ways, and i can't get it to work. Can  anyone PLEASE help me??   Thanks. 
#3
Posted to microsoft.public.word.tables




Using Formulas in a Table
If you use mathematical function, you have to view Word tables similar to
Microsoft Excel speadsheet. For example, The column headings of Excel is A,B,C and so on, will have to considered the simlar way when you work in Word Table. And the way you refernce the cells in Excel will be the same in Word too. Assuming that you have three columns, and you want the product of column 1 and two in column three. you will enter the fomula this way: 1. Place the insertion point in Column three. 2. Press Ctrl+9 to create the braces{}. 3. Enter the formula inside the brace by preceding with the symbol "=" The formula you enter should like this {=A1*B1}. You can brackets to specify the order of caluclation. 4. Press F9 to recalculate the product details to display the current value. Challa Prabhu "TJ" wrote: I'm using one of the Invoice Templates. I need to know how to set up the formula so that it will automatically take the quantity and multiply it by the unit price. I've tried several ways, and i can't get it to work. Can anyone PLEASE help me?? Thanks. 
#4
Posted to microsoft.public.word.tables




Using Formulas in a Table
Macropod: something that might help new users....
Unlike Excel which can have absolute, relative and mixed cell references, Word table cells use absolute cell references, when merged, they take on the cell reference to the left. There is a very handy tool that comes as an 'addin' with Word called Table Cell Helper. Click inside any single or merged cell and it provides a popup with the cell location (A13, BB1 etc) within the table as well as the number of columns and rows in the table. Very handy when identifying cells to include in calculations. It can be added to your Normal template making it available to all Word files. Regards  Lenny "macropod" wrote: Hi TJ Unlike Excel, Word tables don't automatically recalculate. You can get calculations in a document to update automatically when they're in a document protected for forms and: 1) at least one of the inputs for the calculation is gained from a formfield; and 2) the formfield's properties are set to 'calculate on exit'. The calculation fields can be created by pressing CtrlF9 to create the field (denoted by a pair of field braces (ie '{ }')) and: 3) if the calculation only references cells within the table, inputting the formula along the lines of '=A1*B1' between the field braces; or 4) if the calculation references fields outside the table, inputting the formula along the lines of '=BkMrk1*BkMrk2' between the field braces, where 'BkMrk1' and 'BkMrk2' are the formfield bookmark names. You can also use '=BkMrk1*A1' if the calculation references cells within the table and fields outside the table. For more information on tables and calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgibin/w3t/show...?Number=365442 Cheers  macropod [MVP  Microsoft Word] "TJ" wrote in message ...  I'm using one of the Invoice Templates. I need to know how to set up the  formula so that it will automatically take the quantity and multiply it by  the unit price. I've tried several ways, and i can't get it to work. Can  anyone PLEASE help me??   Thanks. 
#5
Posted to microsoft.public.word.tables




Using Formulas in a Table
The TableCellHelper macro is available at
http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm, but see also http://gregmaxey.mvps.org/Table_Cell_Data.htm  Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all followups to the newsgroup so all may benefit. "Lenny" wrote in message ... Macropod: something that might help new users.... Unlike Excel which can have absolute, relative and mixed cell references, Word table cells use absolute cell references, when merged, they take on the cell reference to the left. There is a very handy tool that comes as an 'addin' with Word called Table Cell Helper. Click inside any single or merged cell and it provides a popup with the cell location (A13, BB1 etc) within the table as well as the number of columns and rows in the table. Very handy when identifying cells to include in calculations. It can be added to your Normal template making it available to all Word files. Regards  Lenny "macropod" wrote: Hi TJ Unlike Excel, Word tables don't automatically recalculate. You can get calculations in a document to update automatically when they're in a document protected for forms and: 1) at least one of the inputs for the calculation is gained from a formfield; and 2) the formfield's properties are set to 'calculate on exit'. The calculation fields can be created by pressing CtrlF9 to create the field (denoted by a pair of field braces (ie '{ }')) and: 3) if the calculation only references cells within the table, inputting the formula along the lines of '=A1*B1' between the field braces; or 4) if the calculation references fields outside the table, inputting the formula along the lines of '=BkMrk1*BkMrk2' between the field braces, wh ere 'BkMrk1' and 'BkMrk2' are the formfield bookmark names. You can also use '=BkMrk1*A1' if the calculation references cells within the table and fields outside the table. For more information on tables and calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgibin/w3t/show...?Number=365442 Cheers  macropod [MVP  Microsoft Word] "TJ" wrote in message ...  I'm using one of the Invoice Templates. I need to know how to set up the  formula so that it will automatically take the quantity and multiply it by  the unit price. I've tried several ways, and i can't get it to work. Can  anyone PLEASE help me??   Thanks. 
Reply 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Forum  
Headers and Footers in Main Body with Table Breaks  Page Layout  
20x20 multiplication table  Tables  
Populate Table from Access  Mailmerge  
Table formulas and references  New Users  
Row height problem with table in table  Tables 