A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing Value, not bookmark name.



 
 
Thread Tools Display Modes
  #1  
Old March 23rd, 2010, 03:48 AM posted to microsoft.public.word.docmanagement
hornetster
external usenet poster
 
Posts: 3
Default 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  
Old March 23rd, 2010, 04:53 AM posted to microsoft.public.word.docmanagement
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default 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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:52 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.