[kimhr]

I'm mail merging from excel to word and my percentages are sometimes turning
out correct...if there was a value in the excel spreadsheet. For those
fields that did not have a value in it, I'm receiving a syntax error.

I'm using this formula to get this far:
{ ={ MERGEFIELD percent }*100 \#0% }

Help???

[Doug Robbins - Word MVP]

Try

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

That would return nothing if there is no value in the field. If you wanted
0% to appear in the case of an empty percent field, then insert a 0% in
place of the "" before the final field delimiter.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"kimhr" wrote in message
...
I'm mail merging from excel to word and my percentages are sometimes
turning
out correct...if there was a value in the excel spreadsheet. For those
fields that did not have a value in it, I'm receiving a syntax error.

I'm using this formula to get this far:
{ ={ MERGEFIELD percent }*100 \#0% }

Help???