IF mail merge formula

aaiden · #1 06-05-2013, 07:59 AM

Quote:

Originally Posted by macropod

Simply add a numeric picture switch to your field code:

{={MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT}+{MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1} \# 0.00}

Thanks for the reply but my problem seems to lie with the merge field I labelled as "1." .. as this is the field that appears blank if no balance is due?

So it would be something to change the 'blank' outcome currently to output "0.00" ... of what I come to believe would be done via an IF statement?

noob to word and mail merging.

thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula that can merge multiple rows with the same ID into one row	Hilwey	Excel	3	07-08-2015 08:50 PM
Mail Merge Duplication of address on merge	RICKY	Mail Merge	1	09-26-2012 03:14 PM
Formula needed to merge 2 name lists into one	lcolson	Excel	1	06-11-2012 12:03 AM
Stumped With Mail Merge Formula	JennEx	Mail Merge	0	05-28-2010 07:44 AM
Word mail merge and formula	mridley	Mail Merge	0	04-30-2006 11:26 AM