Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Hi,
It's not for lack of trying to find the answer but after 20 minutes of trying to figure out how to total columns in a Word 2007 table, I have failed. Can anyone point me to some documentation (or better yet just tell me) how to correctly insert a formula that will total columns in a table. Thanks in advance for your help. RS |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
This isn't any different from previous versions, is it? On the Layout tab of
the contextual Table Tools there is a Formula button. The formula defaults to SUM(ABOVE) or SUM(LEFT) if you have values in the relevant cells. You can also add the AutoSum button to the QAT. Or you can use Insert | Text | Quick Parts | Field | Formula. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Ross" wrote in message ... Hi, It's not for lack of trying to find the answer but after 20 minutes of trying to figure out how to total columns in a Word 2007 table, I have failed. Can anyone point me to some documentation (or better yet just tell me) how to correctly insert a formula that will total columns in a table. Thanks in advance for your help. RS |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Thanks Suzanne.
Is there a way update all formula fields at once or do you need to right mouse click on each formula to update the fields in a table? I guess I am looking for the ability to do the same thing with formulas that you can do with a Table of Contents where you can update the entire table at once. Hope this makes sense. RS "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? On the Layout tab of the contextual Table Tools there is a Formula button. The formula defaults to SUM(ABOVE) or SUM(LEFT) if you have values in the relevant cells. You can also add the AutoSum button to the QAT. Or you can use Insert | Text | Quick Parts | Field | Formula. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Ross" wrote in message ... Hi, It's not for lack of trying to find the answer but after 20 minutes of trying to figure out how to total columns in a Word 2007 table, I have failed. Can anyone point me to some documentation (or better yet just tell me) how to correctly insert a formula that will total columns in a table. Thanks in advance for your help. RS |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Ctrl+A, F9, or switch to Print Preview.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Ross" wrote in message ... Thanks Suzanne. Is there a way update all formula fields at once or do you need to right mouse click on each formula to update the fields in a table? I guess I am looking for the ability to do the same thing with formulas that you can do with a Table of Contents where you can update the entire table at once. Hope this makes sense. RS "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? On the Layout tab of the contextual Table Tools there is a Formula button. The formula defaults to SUM(ABOVE) or SUM(LEFT) if you have values in the relevant cells. You can also add the AutoSum button to the QAT. Or you can use Insert | Text | Quick Parts | Field | Formula. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Ross" wrote in message ... Hi, It's not for lack of trying to find the answer but after 20 minutes of trying to figure out how to total columns in a Word 2007 table, I have failed. Can anyone point me to some documentation (or better yet just tell me) how to correctly insert a formula that will total columns in a table. Thanks in advance for your help. RS |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
"Suzanne S. Barnhill" wrote:
This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Ctrl+A, F9 works in template (not protected). When the form is with a
customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Can you provide more details of what you want to do?
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#8
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
In tables in word:
A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#9
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit
property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#10
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Thanks Doug!!! Form calculations now running smooth! Need one more input from
you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. -- Wllem Nel "Doug Robbins - Word MVP" wrote: Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#11
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
In that case plan B. Replace the calculated formfield with a conditional
field. If the field bookmark names remain A1 & A2 { IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} } Set the switch \# "0.00" appropriate to your needs The field will show a syntax error if there is no value in A1 or A2, so set those field types to number and put a default 0 in each. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: Thanks Doug!!! Form calculations now running smooth! Need one more input from you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#12
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY
YOUR INPUTS BE REWARDED! -- Wllem Nel "Graham Mayor" wrote: In that case plan B. Replace the calculated formfield with a conditional field. If the field bookmark names remain A1 & A2 { IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} } Set the switch \# "0.00" appropriate to your needs The field will show a syntax error if there is no value in A1 or A2, so set those field types to number and put a default 0 in each. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: Thanks Doug!!! Form calculations now running smooth! Need one more input from you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#13
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Back again. Where do I find conditional field.
-- Wllem Nel "Willem Nel" wrote: THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY YOUR INPUTS BE REWARDED! -- Wllem Nel "Graham Mayor" wrote: In that case plan B. Replace the calculated formfield with a conditional field. If the field bookmark names remain A1 & A2 { IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} } Set the switch \# "0.00" appropriate to your needs The field will show a syntax error if there is no value in A1 or A2, so set those field types to number and put a default 0 in each. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: Thanks Doug!!! Form calculations now running smooth! Need one more input from you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#14
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
The IF field is the conditional field. Graham has provided the required
syntax. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Willem Nel" wrote in message ... Back again. Where do I find conditional field. -- Wllem Nel "Willem Nel" wrote: THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY YOUR INPUTS BE REWARDED! -- Wllem Nel "Graham Mayor" wrote: In that case plan B. Replace the calculated formfield with a conditional field. If the field bookmark names remain A1 & A2 { IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} } Set the switch \# "0.00" appropriate to your needs The field will show a syntax error if there is no value in A1 or A2, so set those field types to number and put a default 0 in each. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: Thanks Doug!!! Form calculations now running smooth! Need one more input from you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#15
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
I used text form field, calculation, =text1*text2. Can you give me the
complete expression to use (in text form field?) for calculation, =text 1 and for =text1*text2 to avoid the 0 from showing. Please, this is the last hurdle. You guys have been very helpfull. Thanks a milion -- Wllem Nel "Suzanne S. Barnhill" wrote: The IF field is the conditional field. Graham has provided the required syntax. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Willem Nel" wrote in message ... Back again. Where do I find conditional field. -- Wllem Nel "Willem Nel" wrote: THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY YOUR INPUTS BE REWARDED! -- Wllem Nel "Graham Mayor" wrote: In that case plan B. Replace the calculated formfield with a conditional field. If the field bookmark names remain A1 & A2 { IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} } Set the switch \# "0.00" appropriate to your needs The field will show a syntax error if there is no value in A1 or A2, so set those field types to number and put a default 0 in each. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: Thanks Doug!!! Form calculations now running smooth! Need one more input from you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#16
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Instead of using a text form field, you must insert the field code as Graham
gave it. Each pair of field delimiters (the things that look like braces but can't be entered from the keyboard) must be inserted using Ctrl+F9. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Willem Nel" wrote in message ... I used text form field, calculation, =text1*text2. Can you give me the complete expression to use (in text form field?) for calculation, =text 1 and for =text1*text2 to avoid the 0 from showing. Please, this is the last hurdle. You guys have been very helpfull. Thanks a milion -- Wllem Nel "Suzanne S. Barnhill" wrote: The IF field is the conditional field. Graham has provided the required syntax. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Willem Nel" wrote in message ... Back again. Where do I find conditional field. -- Wllem Nel "Willem Nel" wrote: THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY YOUR INPUTS BE REWARDED! -- Wllem Nel "Graham Mayor" wrote: In that case plan B. Replace the calculated formfield with a conditional field. If the field bookmark names remain A1 & A2 { IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} } Set the switch \# "0.00" appropriate to your needs The field will show a syntax error if there is no value in A1 or A2, so set those field types to number and put a default 0 in each. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: Thanks Doug!!! Form calculations now running smooth! Need one more input from you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#17
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
With the document unprotected, press Alt+F9 to toggle the display of the
field codes and modify the calculation field to the following { FORMTEXT { =A1 * A2 } \# 0;-0; } You can replace the 0 with whatever format you require for the result e.g. 0.00;(0.00); etc. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Thanks Doug!!! Form calculations now running smooth! Need one more input from you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. -- Wllem Nel "Doug Robbins - Word MVP" wrote: Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#19
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
Send it to the link on the home page of my web site.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: Thanks for taking the time and the effort to help me. I must be doing something wrong. I changed the field code with alt f9 and enterd the text code you gave me as it is. I still get the 0. Can I email the doc to you to save us both time and effort or can you do a table with 3 coloms with text field form, text1 and text2 is a number with format 0 and text3 is a calculation with format # ##0 (i also tried 0) and email it to me. I need to change this so that text3 do not display the result of the calculation if it is is 0. I will keep trying till I get it right or untill I here from you. I truely appreciate your inputs and realise that you might get frustrated with my inability to get it wright. Therefore the suggestion I email the doc to you or you do a sample as described above and email that to me so I can see what I am doing wrong. Is there a way to add an atttachment to this message? I need to solve this before 08h00 on 06/06/2009 (South-african time) My e-mail adress is I used text form field, calculation, =text1*text2. Can you give me the complete expression to use (in text form field?) for calculation, =text 1 and for =text1*text2 to avoid the 0 from showing. Please, this is the last hurdle. You guys have been very helpfull. Thanks a milion -- Wllem Nel "Suzanne S. Barnhill" wrote: The IF field is the conditional field. Graham has provided the required syntax. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Willem Nel" wrote in message ... Back again. Where do I find conditional field. -- Wllem Nel "Willem Nel" wrote: THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY YOUR INPUTS BE REWARDED! -- Wllem Nel "Graham Mayor" wrote: In that case plan B. Replace the calculated formfield with a conditional field. If the field bookmark names remain A1 & A2 { IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} } Set the switch \# "0.00" appropriate to your needs The field will show a syntax error if there is no value in A1 or A2, so set those field types to number and put a default 0 in each. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Willem Nel wrote: Thanks Doug!!! Form calculations now running smooth! Need one more input from you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
#20
Posted to microsoft.public.word.tables
|
|||
|
|||
Getting a table to total columns
I found the selution through trial and error.
{ FORMTEXT { =A1 * A2 } \# #;-#; } and not { FORMTEXT { =A1 * A2 } \# 0;-0; } or the IF option. Thanks for your inputs. It has helped me to get to the selution, believe it or not. -- Wllem Nel "Doug Robbins - Word MVP" wrote: With the document unprotected, press Alt+F9 to toggle the display of the field codes and modify the calculation field to the following { FORMTEXT { =A1 * A2 } \# 0;-0; } You can replace the 0 with whatever format you require for the result e.g. 0.00;(0.00); etc. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Thanks Doug!!! Form calculations now running smooth! Need one more input from you, please. How do I get the result of a calculation to not show 0. I want the field to be blank if result is 0. -- Wllem Nel "Doug Robbins - Word MVP" wrote: Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit property of each. Assuming that you name bookmarks assigned to those fields as A1 and a2, in A3, insert a calculation type formfield that contains the expression =A1 * A2 See the following; http://www.mousetrax.com/techpage.html#autoforms Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... In tables in word: A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2 All formulas work is template mode if number in A1 AND A2 is recorded when formula is set. There after ctrl+a, f9 updates field in template. If template is protected or saved as word document A3 never changes when A1 OR A2 changes. Ctrl+a, F9 or right click also does not work. Form with calculation of no use to customers or our company! Need to get A3 formula to automaticly update when A1 OR A2 changes if template is protected or saved as word document. See book-keeping slip template under forms on online templates. This is what formulas should do! Book-keeping slip is protected and cannot see formula! -- Wllem Nel "Doug Robbins - Word MVP" wrote: Can you provide more details of what you want to do? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Willem Nel" wrote in message ... Ctrl+A, F9 works in template (not protected). When the form is with a customer or user no formulas operates the way it shoud. I have studied template online tutorials etc. Could not find a solution. Can any one help? -- Wllem Nel "RichardB43" wrote: "Suzanne S. Barnhill" wrote: This isn't any different from previous versions, is it? Like everything else in the new version (I've used it maybe 1 year now, still find it abysmal for navigation), it is a hell of a lot harder to find. And even try searching for "formula" in help - nothing! Lots of fancy stuff in the new version about making your document look pretty, but as for useability, it was a huge retrograde step! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total Columns in Word | Microsoft Word Help | |||
Form Field to total a column in a table? | Microsoft Word Help | |||
how to auto refresh total amount in table | New Users | |||
How do I compute two columns to have one total? | Tables | |||
Formula in table - Creating a final total from sub-total cells | Tables |