Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculations in Word 2003 Table
Tried asking this in another newsgroup but they suggested that I come to a
Word Newsgroup to find my answer faster... Been asked by a user who is looking to create a table in Word to find a way to get some of the cells to become (like Excel) calculatable (if there is such a word). I first thought that copying the cells from a worksheet (with formulae in) and do a Edit Paste Special MS Excel worksheet object... It looked like it worked ok, but that was not what the user wanted since they only wanted one cell to input a figure in, another one to input a percentage and a third (all in seperate cells in the Word table) which would display the outcome of the formula (=A1*A2%)... Also tried a Nested Table, but that is just a copy and paste of the single cell with no formula or border and so doesn't change when the other cells are altered. Are there any other methods? Or am I asking the impossible? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculations in Word 2003 Table
Put the figure in cell A1
Put the percentage in cell A2 (entered as e.g. 10%) Put a formula field in A3 { =A1*A2 } Update the field (CTRA+A then F9) or use a macro - see example at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stampie wrote: Tried asking this in another newsgroup but they suggested that I come to a Word Newsgroup to find my answer faster... Been asked by a user who is looking to create a table in Word to find a way to get some of the cells to become (like Excel) calculatable (if there is such a word). I first thought that copying the cells from a worksheet (with formulae in) and do a Edit Paste Special MS Excel worksheet object... It looked like it worked ok, but that was not what the user wanted since they only wanted one cell to input a figure in, another one to input a percentage and a third (all in seperate cells in the Word table) which would display the outcome of the formula (=A1*A2%)... Also tried a Nested Table, but that is just a copy and paste of the single cell with no formula or border and so doesn't change when the other cells are altered. Are there any other methods? Or am I asking the impossible? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculations in Word 2003 Table
Ok think I have that, but it can't seem to link with the spreadsheet with the
info on... I'm trying to have this so that after creating the document it cuts out Excel altogether... "Graham Mayor" wrote: Put the figure in cell A1 Put the percentage in cell A2 (entered as e.g. 10%) Put a formula field in A3 { =A1*A2 } Update the field (CTRA+A then F9) or use a macro - see example at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculations in Word 2003 Table
I had assumed you wanted to do all of it in Word, in which case where does
Excel still come in? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stampie wrote: Ok think I have that, but it can't seem to link with the spreadsheet with the info on... I'm trying to have this so that after creating the document it cuts out Excel altogether... "Graham Mayor" wrote: Put the figure in cell A1 Put the percentage in cell A2 (entered as e.g. 10%) Put a formula field in A3 { =A1*A2 } Update the field (CTRA+A then F9) or use a macro - see example at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculations in Word 2003 Table
I do... The bit that i'm not understanding is after updating a field it comes
up in bold lettering... 'Error! Bookmark not defined.' Which is why i'm trying to link in Excel... Or is this supposed to happen and I just need to do something else in Word? "Graham Mayor" wrote: I had assumed you wanted to do all of it in Word, in which case where does Excel still come in? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculations in Word 2003 Table
Let's start with a simple table created in Word
Type a number in cell A1 (that'sthe first cell in Word) in the cell beneath it (A2) type 10% in the cell beneath that (A3) type CTRL+F9 which will give you {} between the brackets type =A1*A2 thus {=A1*A2} Toggle the display ALT+F9 then F9 to update. A3 should show a figure 10% of the figure in A1 Where is what you are doing differing from this? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stampie wrote: I do... The bit that i'm not understanding is after updating a field it comes up in bold lettering... 'Error! Bookmark not defined.' Which is why i'm trying to link in Excel... Or is this supposed to happen and I just need to do something else in Word? "Graham Mayor" wrote: I had assumed you wanted to do all of it in Word, in which case where does Excel still come in? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations in Table | Tables | |||
Calculations in a word table | Tables | |||
Calculations in Word 2003 | Microsoft Word Help | |||
formatting table data after fix to Error in Word Calculations | Tables | |||
How can I add multiple table calculations in word? | Tables |