Microsoft Office Forums IF mail merge formula

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-05-2013, 06:30 AM
aaiden aaiden is offline IF mail merge formula Windows XP IF mail merge formula Office 2010 32bit
Novice
IF mail merge formula
 
Join Date: Jun 2013
Posts: 3
aaiden is on a distinguished road
Default IF mail merge formula

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.
Reply With Quote
  #2  
Old 06-05-2013, 07:39 AM
macropod's Avatar
macropod macropod is offline IF mail merge formula Windows 7 32bit IF mail merge formula Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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}
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 06-05-2013, 07:59 AM
aaiden aaiden is offline IF mail merge formula Windows XP IF mail merge formula Office 2010 32bit
Novice
IF mail merge formula
 
Join Date: Jun 2013
Posts: 3
aaiden is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Reply With Quote
  #4  
Old 06-05-2013, 03:36 PM
macropod's Avatar
macropod macropod is offline IF mail merge formula Windows 7 32bit IF mail merge formula Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

In that case, use:
{={MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT \# 0.00}+{MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1 \# 0.00} \# 0.00}
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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
IF mail merge formula 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


All times are GMT -7. The time now is 10:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft