|
| | | Junior Member
 
Group: Forum Members
Last Login: 7/3/2008 10:17:03 AM
Posts: 17, Visits: 49 |
| | Here is the formula from the table that works perfectly. I want to put it directly into the word doc because i don't like the way the table mixes with the formatting. i have a two cell table, I named cell A1 "THE CELL" and inserted <<pnt_386>>. THen in cell B1, i used the following formula: {if{styleref "THE CELL"}= "01863" "MC3067" {if{styleref "THE CELL"}="01516" "MC3065" "MC3064"}} This works great, like i said, but i want to convert it to a formula without use of table so i substituted {styleref "THE CELL"} for <<PNT_386>> and it doesn't work. Any thoughts? |
| |
| | | 
Supreme Being
Group: Forum Members
Last Login: 9/12/2008 11:24:50 AM
Posts: 289, Visits: 242 |
| | The biggest problem I get with Word formulae is the order in which they run. I don't know why, but I have the same problem. I now intercept the load event in Word and read the merge variables, do the calculations, then fill in the blanks. I have found that sometimes the formula runs after the merge data has been put in place and other times they run after. To see if this is your problem, after the merge, click on your formula field and recalculate it. If it's still not behaving correctly, there is a problem with the reference to "THE CELL".
- Mike
mike@mtig.biz |
| |
| | | Forum Member
Group: Forum Members
Last Login: 11/2/2006 7:35:07 AM
Posts: 39, Visits: 136 |
| | Not sure if this will help. It works for one of my merge forms in order to update the formula. In Word top menu
tools
options
print tab- make sure update fields and update links boxes are checked When I print the document the field is updated for the (in this cae) new total in a table. Otherwise you could press F9 and formulas get recalculated. |
| |
| | | Junior Member
Group: Forum Members
Last Login: 7/3/2008 10:17:03 AM
Posts: 17, Visits: 49 |
| | the formula works great with "The Cell". But in order to use that , i must use a table which i don't want to do. HOw can i integrate the formula that works in my table to a formula withoug using a table. |
| |
|
|