Reply to thread

Message

[QUOTE="cpeiner, post: 5604601"]
Peter,

thanks for the advice. I went back and rearranged the lay-out to a table, so
now the "From | To | Percentage | Total" is on top and I don't have to worry
about it anymore. So now all I need is to tell Word that if it receives a 0,
the field should stay empty.

The total field code in the four cells is this:

Cell 1: {Mergefield "Start_Range_3" \# ###,0}
Cell 2: {Mergefield "End_Range_3" \# ###,0}
Cell3:  {={Mergefield Percentage_3}*100 \# "0.00%"}
Cell4: {Mergefield "Possible_Bonus_Amount_Range_3" \# Â£###,0}

Of course I have the same fields for Ranges 1 and 2.

Looking at your function, I was thinking to use somthing along the lines of:
{ IF { ={ MERGEFIELD Start_Range_2 \#0} } =  0 "" (and this is where I don't
know any further:) ELSE { MERGEFIELD Start_Range_2 \#0 }.

I would then just repeat this process in all merge-cells. So how can I write
it so that word understands IF MERGE_CELL=0, DISPLAY "", DISPLAY "MERGEFIELD
Start_Range_2"?

Many thanks!
[/QUOTE]

Verification