I have three separate fields all merging information from an external source.

When the balance is 0.00 on the primary source it formats the amount in the report as a blank space.

I want to create an IF mailmerge that if the balance is 0.00 that it shows 0.00 instead of the blank space which it currently does.

The fundamentals of this calculation is that I want 1 + 2 = 3. The IF formula merge will be applied to "1."

1. { MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT }

2. { MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1 }

3. { = { MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT } + { MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1 }}

Any help would be grateful Thanks.