Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Showing Value, not bookmark name.
Am using fields to do calculations in Word. Have a bookmark to a value (ie
"74" is bookmarked as "Rate", both without quotes.) I am then referring to this in a field {if EngineCapacity= "1600" Rate ""} called "kms", then using this in a calculation {=kms*Rate/100} The calculation works, but the "kms" field displays as Rate, not as the actual value. Is it possible to show this as the actual value?? Thanks, John. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Showing Value, not bookmark name.
Hi John,
Your formula field construction for the Rate is wrong. It should be something along the lines of: {IF{EngineCapacity}= 1600 Rate 0} or: {=({EngineCapacity}=1600)*Rate \# 0;;} Where is 'EngineCapacity' coming from? If it's from a mailmerge data source, its field code should be expressed as: {MERGEFIELD EngineCapacity} or: «EngineCapacity» If it's from a dropdown formfield and the Engine Capacity option is '=1600', then the field code should be expressed along the lines of: {IF{EngineCapacity}= "= 1600" Rate 0} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. -- Cheers macropod [Microsoft MVP - Word] "hornetster" wrote in message ... Am using fields to do calculations in Word. Have a bookmark to a value (ie "74" is bookmarked as "Rate", both without quotes.) I am then referring to this in a field {if EngineCapacity= "1600" Rate ""} called "kms", then using this in a calculation {=kms*Rate/100} The calculation works, but the "kms" field displays as Rate, not as the actual value. Is it possible to show this as the actual value?? Thanks, John. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Showing Value, not bookmark name.
Hi John, Your formula field construction for the Rate is wrong. It should be something along the lines of: {IF{EngineCapacity}= 1600 Rate 0} or: {=({EngineCapacity}=1600)*Rate \# 0;;} Where is 'EngineCapacity' coming from? If it's from a mailmerge data source, its field code should be expressed as: {MERGEFIELD EngineCapacity} or: «EngineCapacity» If it's from a dropdown formfield and the Engine Capacity option is '=1600', then the field code should be expressed along the lines of: {IF{EngineCapacity}= "= 1600" Rate 0} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. -- Cheers macropod [Microsoft MVP - Word] "hornetster" wrote in message ... Am using fields to do calculations in Word. Have a bookmark to a value (ie "74" is bookmarked as "Rate", both without quotes.) I am then referring to this in a field {if EngineCapacity= "1600" Rate ""} called "kms", then using this in a calculation {=kms*Rate/100} The calculation works, but the "kms" field displays as Rate, not as the actual value. Is it possible to show this as the actual value?? Thanks, John. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bookmark and REF | Microsoft Word Help | |||
Go to next bookmark | Microsoft Word Help | |||
My noteref to valid bookmark says "Error! Bookmark not defined."? | Microsoft Word Help | |||
The Insert Bookmark box shouldnt vanish after adding a bookmark. | Microsoft Word Help | |||
The Go To box shouldnt open with only one bookmark item showing. | Microsoft Word Help |