View Single Post
  #14  
Old April 12th, 2006, 04:28 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default MS Word table - problem with conditional formula

Hi macropod

Sorry for the delay in coming back to this forum, but have been rather busy
for the last few days. I am sorry to say I am still having great difficulty
in resolving this problem.

The formula in C2 is now: - {*IF{*CellB2*}=X*{=PRODUCT(EntryFee,1)*}*\#*#0.00}
and in C3 a similar formula but with a 2 instead of a 1 after the EntryFee.

The contents of B2 are [{*FILLIN*"Enter*X*for*Men's*Singles"\d*}] with a
bookmark title of CellB2. A similar Filllin in C2 with Pairs in place of
Singles has been bookmarked as CellB3.

Running a mail merge first prompts for each of the ASK fields, and then
immediately issues 'A field calculation error occurred for record ' for each
of the selected records in the source document. The resultant Form Letter
has the correct calculation in C2 and C3 (i.e. EntryFee x 1 or x2), but these
appear in those cells in EACH of the sections. Since no prompts were issued
for the Fillins this is probably not surprising, except that I would have
thought that since there is no X in B2 or B3 the formula result would have
been 'False' and therefore C2 and C3 should have remained blank.

It seems that the Fillin function is not working correctly. At first I
thought this might be the cause of the error message, but since I only get
one error message per record, and not one for each Fillin for each record I
now have my doubts.

I would be grateful if you, or anyone else, can identify why this feature is
not working.

Regards
Peter

macropod wrote:
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.


--
Message posted via http://www.officekb.com