(!Syntax Error, *)

[Suse]

Hi,
I'm trying to merge data from an excel file version 2002, to microsoft word
2002.

A bit of background - I am generating stats of individuals for a supervisor
that merges to a table. He needs to be able to compare individuals stats and
the team info on the same table. I had to force word to use percentage
information, (thank you g.mayor.com!!)

The table merges fine if he is merging stats for 11 people (the exact # of
rows in the table) -- when trying to merge less than 11 people, each cell in
the remaining rows (with no data from excel) are filled in with:
(!Syntax Error, *)

My merge percentage formula is:
{={MERGEFIELD "Pct_Ework_Issues"}*100\#"0%"}


I need to force word to return blank info for blank cells in Excel. I've
searched & searched and can't find any info regarding an error like this.
Any and all suggestions greating appreciated as tomorrow is my last day in
this postion & I'd love to have this completed for the manager )))))))

THANKS!!!!

 

[Doug Robbins]

Use

{ IF {MERGEFIELD "Pct_Ework_Issues"}="" "" {={MERGEFIELD
"Pct_Ework_Issues"}*100\#"0%"}}


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Graham Mayor]

Or coversely

{ IF {MERGEFIELD "Pct_Ework_Issues"} <> "" "{={MERGEFIELD
"Pct_Ework_Issues"}*100\#"0%"}"}



--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Suse]

Many thanks to both of you!!!!!

)))))))))

Or coversely

{ IF {MERGEFIELD "Pct_Ework_Issues"} <> "" "{={MERGEFIELD
"Pct_Ework_Issues"}*100\#"0%"}"}



--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[macropod]

Or even:

{={MERGEFIELD "Pct_Ework_Issues"}*100 \# 0%;-0%;}

Cheers