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 |
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 |