MS Word table - problem with conditional formula

Hi Charles,

I had thought of an ASK field, but it only sets a bookmark - the results are
hidden unless you use yet another field (REF) to display them. Hence the
bookmarked FILLIN field.

Cheers


"Charles Kenyon" wrote in message
...
You might try an ASK field rather than a fill-in. That will let you set
the
bookmark directly. This makes up for the bookmark's fragility. You can
find
an ASK and FILL-IN field tutorial at
http://addbalance.com/word/download.htm.

I would suggest adding spaces around the equals sign and quotation marks
around the comparison items and around your True result as well. I also
added a REF field.
{*IF*"{*REF*CellB2*}"*=*"X"*"{*PRODUCT({*EntryFee* },2)\#*#0.00*}"*""*}

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"Peterkins via OfficeKB.com" u20492@uwe wrote in message
news:5e6d9e84e6a5d@uwe...
Hi macropod

Thanks for your help, but I am still a bit stuck. I have not had
experience
with bookmarking before but have tried to follow your instructions.
Although
I don't quite understand how/why maintaining a book mark can be a pain,
I
opted for your suggestion to create a FILLIN field and this is what I
have
entered (again * = space): -

{*FILLIN*"Enter*X*if*entering*Men's*Singles"\d**\* *MERGEFORMAT*}

(I don't understand the Mergeformat bit but presume it has been put
there
by
Word because this is a main document for a mail merge.) I selected all
of
the Fillin and using Insert Bookmark named it CellB2.

The formula in C2 is now: -
{*IF*{*CellB2*}=X*{*PRODUCT({*EntryFee*},2)\#*#0.
00*}""*}

I ran a mail merge and after answering the ASK prompts I had an error
message
"A field calculation error occurred in record " for each record in the
source document, and all the sections of the resulting Form Letter had
"=X"
(without quotes) in C2. I didn't get any prompt to "Enter X if entering
Men's Singles" even thought the FILLIN switch was set to \d.

Any further ideas please?

Regards

Peter



macropod wrote:
Hi Peterkins,

Table cell referencing doesn't work with text strings. To refer to a
character string in a cell, the character string (not the cell itself)
must
be individually bookmarked and the bookmark referred to in the
reference.
So
my previous post on this was wrong (Should have read my own tutorial)!

So, if you bookmark the text range in cell B2 with something like
'Cell2B'
you could use a field coded like:
{IF{Cell2B}= X {=EntryFee*2} \# £,0.00}
Since maintaining the bookmark in such a field can be a PITA, you might
find
it easiest to add a FILLIN field to cell B2 and bookmark that. Code the
FILLIN field something like:
{FILLIN "Enter 'X' if accepted"}

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ables/200604/1