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

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