Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
If formula
Hi
I hope someone out there can help me? I am using the TextForm field button within my doc. Under the "Properties" of each field, the "Bookmark" is Text32, Text37, Text42 and Text47 I am trying (and failing) to add a new field that will perform a calculation based on the fields named above. What I want the calculation to do is as follows: If (Text32 + Text37) = (Text42 + Text47) then "Ok" else ((Text32 + Text37)-(Text42 + Text 47)) Can anyone please point me in the right direction? Thanks in advance. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
If formula
In the field properties, choose the "Calculate on exit" option. Then create
fields as follows: { SET test1 { = { Text32 } + { Text37 } } } { SET test2 { = { Text 42 } + { Text 47 } } } { IF { test1 } = { test2 } "Ok" "{ = { test1 } - { test2 } }" } To insert each pair of field delimiters, { }, press Ctrl+F9. When you are done, press F9 to update. Finally, protect the document again and try the code. In an unprotected document, you can show/hide field codes by pressing Alt+F9. -- Stefan Blom Microsoft Word MVP "Duncan" wrote in message ... Hi I hope someone out there can help me? I am using the TextForm field button within my doc. Under the "Properties" of each field, the "Bookmark" is Text32, Text37, Text42 and Text47 I am trying (and failing) to add a new field that will perform a calculation based on the fields named above. What I want the calculation to do is as follows: If (Text32 + Text37) = (Text42 + Text47) then "Ok" else ((Text32 + Text37)-(Text42 + Text 47)) Can anyone please point me in the right direction? Thanks in advance. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
If formula
You are a legend.
Thank you for this. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
If formula
You are welcome.
-- Stefan Blom Microsoft Word MVP "Duncan" wrote in message ... You are a legend. Thank you for this. |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
If formula
Hi Duncan,
One tool that works great for creating formulas in Word is "Formula Builder for MS Word". You can find it at most major download sites. "Duncan" wrote: You are a legend. Thank you for this. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hlp! Seq within Formula | Tables | |||
Formula | Tables | |||
how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
Formula help? | Microsoft Word Help | |||
Need a formula | Microsoft Word Help |