Hi Peterkins,
You can safely delete the \* MERGEFORMAT switch.
For the formula, use any of:
{IF{Cell2B}= X {=EntryFee*2} \# ,0.00}
{IF{Cell2B}= X {=EntryFee*2} \# £,0.00}
{IF{Cell2B}= X {=PRODUCT(EntryFee,2)} \# ,0.00}
{IF{Cell2B}= X {=PRODUCT(EntryFee,2)} \# £,0.00}
Note that you mast have a '=' sign in the second field, and the false output
(ie "") isn't necessary.
Cheers
NB: You must have the spaces shown above, though additional spaces in *some*
places won't hurt, and you can put the numeric picture switch inside the
second field.
"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