IF() Function in Word 2003 table

[gsgriffin]

I'm having difficulties changing the input of a merged document. I have a form in MS Word 2003 that is connected to an Excel DB. A field in Excel is "True" or "False". When I merge this document into the Word table, I would like for a formula to indentify this value and present either an "X" or "O" (Wingdings font, of course).

I'm looking at the formula for a cell to be

=IF(...="True","X","O")

What I can't determine is how to reference the merged value. I've tried several different combinations, but I can't seem to evaluate the field.

Thoughts?

GG

 

[Dreamboat]

Forget the commas...

{=IF {MERGEFIELD NameofField } ="True" "X" "O"}

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[gsgriffin]

Thanks. I think that was what I'm looking for. When trying to work it into a table formula, I happened across the "Insert Word Field" function of Merge in 2003. It provided a fill-in-the-blank function that did this.

Thanks,

GG