I currently have my template to bring in figures from another software via mail merge and I am having trouble with a formula.

I posted previously about getting a mail merge of a blank figure to come through as 0.00.

Now I am having a problem with interlinking it into a different position in a table.. (see below, to my knowledge these fields I have attempted to code do work, please correct if you think otherwise)

What I am asking for help on is for the 'Balancing Payment due:' is to combine the two bolded merge fields, to have it into one merge formula? Which if one isn't correct, then to do the other, I am unsure how to do an OR formula on word? (hopefully it is possible)

Then I am sure it is as simple as just putting the new formula for Balancing payment due + Add: New Payment Due .. to get what I want?

If you need anymore details please ask, any help is appreciated!


_________________

Balancing Payment due:

{ IF "{ MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT }" <> "" "{ MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT }" "0.00" }
OR
{ IF { MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT } = "" "0.00" \* MERGEFORMAT \* MERGEFORMAT }

Add: New Payment due:

{ MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1 }

Total due: = two above added together

_____________

Try:

{={MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT} \# "$,0.00"}
{={MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1} \# "$,0.00"}
and
{={={MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT} \# 0.00"}+{={MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1} \# "0.00"} \# "$,0.00"}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Cross-posted at: http://www.excelforum.com/word-forma...ilmerging.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]