| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Hlp! Seq within Formula
Hi,
I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
To see how to do this, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
Hi there,
Yes, I had read you information today. I'm sorry, but I just don't grasp how to incorporate a Seq field within my formula to reference the correct relative address. (I'm blonde! :-) ) My thought was to reference the row number, somehow having something like: =a(seq field)-b(seq field) I have a feeling I'm totally off base. Any help (baby step-by-step) would be greatly appreciated. -- Thanks! Dee "macropod" wrote: To see how to do this, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
Hi Dee,
Did you examine the field coding? To do so, select one of the fields and press Shift-F9. You might find it easier if you copy the field out of the table and paste it somewhere where the cell boundaries won't constrain the layout. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi there, Yes, I had read you information today. I'm sorry, but I just don't grasp how to incorporate a Seq field within my formula to reference the correct relative address. (I'm blonde! :-) ) My thought was to reference the row number, somehow having something like: =a(seq field)-b(seq field) I have a feeling I'm totally off base. Any help (baby step-by-step) would be greatly appreciated. -- Thanks! Dee "macropod" wrote: To see how to do this, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
Yes, I did examine the code. I then copied and pasted it into my table and
modified the * for - and it worked fine for the first table. When it got to the 2nd table, it stopped working. I realize that I need to add an r switch to get it to restart the numbering with 1, but when I try to do this, I get a syntax error. I then tried to start from scratch, but, again, syntax error. This is what I did: Insert menu, Field, Quote (which I am honestly not sure why using) Ctrl F9 Type =b Insert field - seq rownum type -c Insert field - seq rownum \c I then hit F9 and get Syntax Error. I'm obviously missing something and any help would be greatly appreciated. Thanks so much. -- Thanks! Dee "macropod" wrote: Hi Dee, Did you examine the field coding? To do so, select one of the fields and press Shift-F9. You might find it easier if you copy the field out of the table and paste it somewhere where the cell boundaries won't constrain the layout. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi there, Yes, I had read you information today. I'm sorry, but I just don't grasp how to incorporate a Seq field within my formula to reference the correct relative address. (I'm blonde! :-) ) My thought was to reference the row number, somehow having something like: =a(seq field)-b(seq field) I have a feeling I'm totally off base. Any help (baby step-by-step) would be greatly appreciated. -- Thanks! Dee "macropod" wrote: To see how to do this, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
Hi Dee,
I take it you're using coding based on the example from Column E. For your second and subsequent tables, you'd be better off changing the SEQ field names and 'CellA' etc bookmarks. Otherwise, you'll have to delete the '/2' divisors for the second table, at which point you could run into problems with Word trying to use two copies of the same 'CellA' etc bookmarks. It gets even more complicated if you go to three or more tables and try to reuse the SEQ fields and 'CellA' etc bookmarks. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Yes, I did examine the code. I then copied and pasted it into my table and modified the * for - and it worked fine for the first table. When it got to the 2nd table, it stopped working. I realize that I need to add an r switch to get it to restart the numbering with 1, but when I try to do this, I get a syntax error. I then tried to start from scratch, but, again, syntax error. This is what I did: Insert menu, Field, Quote (which I am honestly not sure why using) Ctrl F9 Type =b Insert field - seq rownum type -c Insert field - seq rownum \c I then hit F9 and get Syntax Error. I'm obviously missing something and any help would be greatly appreciated. Thanks so much. -- Thanks! Dee "macropod" wrote: Hi Dee, Did you examine the field coding? To do so, select one of the fields and press Shift-F9. You might find it easier if you copy the field out of the table and paste it somewhere where the cell boundaries won't constrain the layout. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi there, Yes, I had read you information today. I'm sorry, but I just don't grasp how to incorporate a Seq field within my formula to reference the correct relative address. (I'm blonde! :-) ) My thought was to reference the row number, somehow having something like: =a(seq field)-b(seq field) I have a feeling I'm totally off base. Any help (baby step-by-step) would be greatly appreciated. -- Thanks! Dee "macropod" wrote: To see how to do this, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
Thanks for your reply.
I guess I'm still not getting this. To which selection do I apply bookmarks? Do I do this before inserting the fields, or is it something done via fields. Thank you so much. -- Thanks! Dee "macropod" wrote: Hi Dee, I take it you're using coding based on the example from Column E. For your second and subsequent tables, you'd be better off changing the SEQ field names and 'CellA' etc bookmarks. Otherwise, you'll have to delete the '/2' divisors for the second table, at which point you could run into problems with Word trying to use two copies of the same 'CellA' etc bookmarks. It gets even more complicated if you go to three or more tables and try to reuse the SEQ fields and 'CellA' etc bookmarks. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Yes, I did examine the code. I then copied and pasted it into my table and modified the * for - and it worked fine for the first table. When it got to the 2nd table, it stopped working. I realize that I need to add an r switch to get it to restart the numbering with 1, but when I try to do this, I get a syntax error. I then tried to start from scratch, but, again, syntax error. This is what I did: Insert menu, Field, Quote (which I am honestly not sure why using) Ctrl F9 Type =b Insert field - seq rownum type -c Insert field - seq rownum \c I then hit F9 and get Syntax Error. I'm obviously missing something and any help would be greatly appreciated. Thanks so much. -- Thanks! Dee "macropod" wrote: Hi Dee, Did you examine the field coding? To do so, select one of the fields and press Shift-F9. You might find it easier if you copy the field out of the table and paste it somewhere where the cell boundaries won't constrain the layout. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi there, Yes, I had read you information today. I'm sorry, but I just don't grasp how to incorporate a Seq field within my formula to reference the correct relative address. (I'm blonde! :-) ) My thought was to reference the row number, somehow having something like: =a(seq field)-b(seq field) I have a feeling I'm totally off base. Any help (baby step-by-step) would be greatly appreciated. -- Thanks! Dee "macropod" wrote: To see how to do this, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#8
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
Hi Dee,
The SEQ and SET fields create their own bookmarks. For the second and subsequent tables, you need to give these different names from the names used in the first table. The field from Column E is presently coded as: {QUOTE {Set CellA "a{={SEQ RowNr}/2}"} {Set CellB "b{={SEQ RowNr \c}/2}"} {Set CellC "c{={SEQ RowNr \c}/2}"} {={CellA}*{CellB}+{CellC} \# $,0.00;-$,0.00}} You need to change the 'CellA' , 'CellB', 'CellC' and 'RowNr' strings to something else for the 2nd table. For example: {QUOTE {Set Tbl2CellA "a{={SEQ Tbl2RowNr}/2}"} {Set Tbl2CellB "b{={SEQ Tbl2RowNr \c}/2}"} {Set Tbl2CellC "c{={SEQ Tbl2RowNr \c}/2}"} {={Tbl2CellA}*{Tbl2CellB}+{Tbl2CellC} \# $,0.00;-$,0.00}} Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Thanks for your reply. I guess I'm still not getting this. To which selection do I apply bookmarks? Do I do this before inserting the fields, or is it something done via fields. Thank you so much. -- Thanks! Dee "macropod" wrote: Hi Dee, I take it you're using coding based on the example from Column E. For your second and subsequent tables, you'd be better off changing the SEQ field names and 'CellA' etc bookmarks. Otherwise, you'll have to delete the '/2' divisors for the second table, at which point you could run into problems with Word trying to use two copies of the same 'CellA' etc bookmarks. It gets even more complicated if you go to three or more tables and try to reuse the SEQ fields and 'CellA' etc bookmarks. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Yes, I did examine the code. I then copied and pasted it into my table and modified the * for - and it worked fine for the first table. When it got to the 2nd table, it stopped working. I realize that I need to add an r switch to get it to restart the numbering with 1, but when I try to do this, I get a syntax error. I then tried to start from scratch, but, again, syntax error. This is what I did: Insert menu, Field, Quote (which I am honestly not sure why using) Ctrl F9 Type =b Insert field - seq rownum type -c Insert field - seq rownum \c I then hit F9 and get Syntax Error. I'm obviously missing something and any help would be greatly appreciated. Thanks so much. -- Thanks! Dee "macropod" wrote: Hi Dee, Did you examine the field coding? To do so, select one of the fields and press Shift-F9. You might find it easier if you copy the field out of the table and paste it somewhere where the cell boundaries won't constrain the layout. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi there, Yes, I had read you information today. I'm sorry, but I just don't grasp how to incorporate a Seq field within my formula to reference the correct relative address. (I'm blonde! :-) ) My thought was to reference the row number, somehow having something like: =a(seq field)-b(seq field) I have a feeling I'm totally off base. Any help (baby step-by-step) would be greatly appreciated. -- Thanks! Dee "macropod" wrote: To see how to do this, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#9
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
I am wondering how I could have seen this? I was able to toggle the code,
but just saw part of this. Is there a trick to seeing all of the fields, etc. that you so very kindly wrote out for me? Also, what is the Quote field used for? Thanks so very much for all of your help and patience! -- Thanks! Dee "macropod" wrote: Hi Dee, The SEQ and SET fields create their own bookmarks. For the second and subsequent tables, you need to give these different names from the names used in the first table. The field from Column E is presently coded as: {QUOTE {Set CellA "a{={SEQ RowNr}/2}"} {Set CellB "b{={SEQ RowNr \c}/2}"} {Set CellC "c{={SEQ RowNr \c}/2}"} {={CellA}*{CellB}+{CellC} \# $,0.00;-$,0.00}} You need to change the 'CellA' , 'CellB', 'CellC' and 'RowNr' strings to something else for the 2nd table. For example: {QUOTE {Set Tbl2CellA "a{={SEQ Tbl2RowNr}/2}"} {Set Tbl2CellB "b{={SEQ Tbl2RowNr \c}/2}"} {Set Tbl2CellC "c{={SEQ Tbl2RowNr \c}/2}"} {={Tbl2CellA}*{Tbl2CellB}+{Tbl2CellC} \# $,0.00;-$,0.00}} Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Thanks for your reply. I guess I'm still not getting this. To which selection do I apply bookmarks? Do I do this before inserting the fields, or is it something done via fields. Thank you so much. -- Thanks! Dee "macropod" wrote: Hi Dee, I take it you're using coding based on the example from Column E. For your second and subsequent tables, you'd be better off changing the SEQ field names and 'CellA' etc bookmarks. Otherwise, you'll have to delete the '/2' divisors for the second table, at which point you could run into problems with Word trying to use two copies of the same 'CellA' etc bookmarks. It gets even more complicated if you go to three or more tables and try to reuse the SEQ fields and 'CellA' etc bookmarks. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Yes, I did examine the code. I then copied and pasted it into my table and modified the * for - and it worked fine for the first table. When it got to the 2nd table, it stopped working. I realize that I need to add an r switch to get it to restart the numbering with 1, but when I try to do this, I get a syntax error. I then tried to start from scratch, but, again, syntax error. This is what I did: Insert menu, Field, Quote (which I am honestly not sure why using) Ctrl F9 Type =b Insert field - seq rownum type -c Insert field - seq rownum \c I then hit F9 and get Syntax Error. I'm obviously missing something and any help would be greatly appreciated. Thanks so much. -- Thanks! Dee "macropod" wrote: Hi Dee, Did you examine the field coding? To do so, select one of the fields and press Shift-F9. You might find it easier if you copy the field out of the table and paste it somewhere where the cell boundaries won't constrain the layout. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi there, Yes, I had read you information today. I'm sorry, but I just don't grasp how to incorporate a Seq field within my formula to reference the correct relative address. (I'm blonde! :-) ) My thought was to reference the row number, somehow having something like: =a(seq field)-b(seq field) I have a feeling I'm totally off base. Any help (baby step-by-step) would be greatly appreciated. -- Thanks! Dee "macropod" wrote: To see how to do this, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#10
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
Hi Dee,
It's easiest to see the whole field construction if you copy it out of the table and paste it into the body of the document. I suggested this in an earlier post. The QUOTE field simply ties the others together. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... I am wondering how I could have seen this? I was able to toggle the code, but just saw part of this. Is there a trick to seeing all of the fields, etc. that you so very kindly wrote out for me? Also, what is the Quote field used for? Thanks so very much for all of your help and patience! -- Thanks! Dee "macropod" wrote: Hi Dee, The SEQ and SET fields create their own bookmarks. For the second and subsequent tables, you need to give these different names from the names used in the first table. The field from Column E is presently coded as: {QUOTE {Set CellA "a{={SEQ RowNr}/2}"} {Set CellB "b{={SEQ RowNr \c}/2}"} {Set CellC "c{={SEQ RowNr \c}/2}"} {={CellA}*{CellB}+{CellC} \# $,0.00;-$,0.00}} You need to change the 'CellA' , 'CellB', 'CellC' and 'RowNr' strings to something else for the 2nd table. For example: {QUOTE {Set Tbl2CellA "a{={SEQ Tbl2RowNr}/2}"} {Set Tbl2CellB "b{={SEQ Tbl2RowNr \c}/2}"} {Set Tbl2CellC "c{={SEQ Tbl2RowNr \c}/2}"} {={Tbl2CellA}*{Tbl2CellB}+{Tbl2CellC} \# $,0.00;-$,0.00}} Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Thanks for your reply. I guess I'm still not getting this. To which selection do I apply bookmarks? Do I do this before inserting the fields, or is it something done via fields. Thank you so much. -- Thanks! Dee "macropod" wrote: Hi Dee, I take it you're using coding based on the example from Column E. For your second and subsequent tables, you'd be better off changing the SEQ field names and 'CellA' etc bookmarks. Otherwise, you'll have to delete the '/2' divisors for the second table, at which point you could run into problems with Word trying to use two copies of the same 'CellA' etc bookmarks. It gets even more complicated if you go to three or more tables and try to reuse the SEQ fields and 'CellA' etc bookmarks. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Yes, I did examine the code. I then copied and pasted it into my table and modified the * for - and it worked fine for the first table. When it got to the 2nd table, it stopped working. I realize that I need to add an r switch to get it to restart the numbering with 1, but when I try to do this, I get a syntax error. I then tried to start from scratch, but, again, syntax error. This is what I did: Insert menu, Field, Quote (which I am honestly not sure why using) Ctrl F9 Type =b Insert field - seq rownum type -c Insert field - seq rownum \c I then hit F9 and get Syntax Error. I'm obviously missing something and any help would be greatly appreciated. Thanks so much. -- Thanks! Dee "macropod" wrote: Hi Dee, Did you examine the field coding? To do so, select one of the fields and press Shift-F9. You might find it easier if you copy the field out of the table and paste it somewhere where the cell boundaries won't constrain the layout. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi there, Yes, I had read you information today. I'm sorry, but I just don't grasp how to incorporate a Seq field within my formula to reference the correct relative address. (I'm blonde! :-) ) My thought was to reference the row number, somehow having something like: =a(seq field)-b(seq field) I have a feeling I'm totally off base. Any help (baby step-by-step) would be greatly appreciated. -- Thanks! Dee "macropod" wrote: To see how to do this, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
|
#11
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Hlp! Seq within Formula
Thank you!!! I had a few problems, but realized a couple of typos were made
and had to revise the formula a bit and the formatting, but it's working! You just saved my skin! Thanks so much! -- Thanks! Dee "macropod" wrote: Hi Dee, It's easiest to see the whole field construction if you copy it out of the table and paste it into the body of the document. I suggested this in an earlier post. The QUOTE field simply ties the others together. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... I am wondering how I could have seen this? I was able to toggle the code, but just saw part of this. Is there a trick to seeing all of the fields, etc. that you so very kindly wrote out for me? Also, what is the Quote field used for? Thanks so very much for all of your help and patience! -- Thanks! Dee "macropod" wrote: Hi Dee, The SEQ and SET fields create their own bookmarks. For the second and subsequent tables, you need to give these different names from the names used in the first table. The field from Column E is presently coded as: {QUOTE {Set CellA "a{={SEQ RowNr}/2}"} {Set CellB "b{={SEQ RowNr \c}/2}"} {Set CellC "c{={SEQ RowNr \c}/2}"} {={CellA}*{CellB}+{CellC} \# $,0.00;-$,0.00}} You need to change the 'CellA' , 'CellB', 'CellC' and 'RowNr' strings to something else for the 2nd table. For example: {QUOTE {Set Tbl2CellA "a{={SEQ Tbl2RowNr}/2}"} {Set Tbl2CellB "b{={SEQ Tbl2RowNr \c}/2}"} {Set Tbl2CellC "c{={SEQ Tbl2RowNr \c}/2}"} {={Tbl2CellA}*{Tbl2CellB}+{Tbl2CellC} \# $,0.00;-$,0.00}} Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Thanks for your reply. I guess I'm still not getting this. To which selection do I apply bookmarks? Do I do this before inserting the fields, or is it something done via fields. Thank you so much. -- Thanks! Dee "macropod" wrote: Hi Dee, I take it you're using coding based on the example from Column E. For your second and subsequent tables, you'd be better off changing the SEQ field names and 'CellA' etc bookmarks. Otherwise, you'll have to delete the '/2' divisors for the second table, at which point you could run into problems with Word trying to use two copies of the same 'CellA' etc bookmarks. It gets even more complicated if you go to three or more tables and try to reuse the SEQ fields and 'CellA' etc bookmarks. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Yes, I did examine the code. I then copied and pasted it into my table and modified the * for - and it worked fine for the first table. When it got to the 2nd table, it stopped working. I realize that I need to add an r switch to get it to restart the numbering with 1, but when I try to do this, I get a syntax error. I then tried to start from scratch, but, again, syntax error. This is what I did: Insert menu, Field, Quote (which I am honestly not sure why using) Ctrl F9 Type =b Insert field - seq rownum type -c Insert field - seq rownum \c I then hit F9 and get Syntax Error. I'm obviously missing something and any help would be greatly appreciated. Thanks so much. -- Thanks! Dee "macropod" wrote: Hi Dee, Did you examine the field coding? To do so, select one of the fields and press Shift-F9. You might find it easier if you copy the field out of the table and paste it somewhere where the cell boundaries won't constrain the layout. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi there, Yes, I had read you information today. I'm sorry, but I just don't grasp how to incorporate a Seq field within my formula to reference the correct relative address. (I'm blonde! :-) ) My thought was to reference the row number, somehow having something like: =a(seq field)-b(seq field) I have a feeling I'm totally off base. Any help (baby step-by-step) would be greatly appreciated. -- Thanks! Dee "macropod" wrote: To see how to do this, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Relative Referencing In Tables' Cheers -- macropod [MVP - Microsoft Word] ------------------------- "dee" wrote in message ... Hi, I've found some guidance through the posts regarding "relative" cell addresses within a table, but can't seem to figure out exactly how to input the formula using the Seq field. For example, say I have a table with 3 columns and 3 rows. I want to be able to input a formula in cell C1 that will subtract A1-B1. Using an absolute formula won't work, as I will be revising the table every month. I had thought of embedding an Excel file, but for what I'm doing, it isn't feasible. Can anyone help with the exact syntax of how to achieve this? Every time I try, I get a syntax error. Thanks! -- Thanks! Dee |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
| Formula Help | Microsoft Word Help | |||
| Formula help? | Microsoft Word Help | |||
| Need a formula | Microsoft Word Help | |||
| Formula | Microsoft Word Help | |||
Linear Mode
