Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-19-2023, 08:41 AM
mxdelene's Avatar
mxdelene mxdelene is offline How to implement addition into a nested IF mergefield? Windows 10 How to implement addition into a nested IF mergefield? Office 2021
Novice
How to implement addition into a nested IF mergefield?
 
Join Date: Dec 2023
Location: Somerset, UK
Posts: 4
mxdelene is on a distinguished road
Default How to implement addition into a nested IF mergefield?

Hi all!
I've recently been teaching myself how to use basic merge fields in a professional template, and I've hit a bit of a wall when it comes to nested IF statements. I haven't seen anyone talk about this so I thought id put it out there.

Code:
{IF {MERGEFIELD MFC_testlookup1} = "Yes" "82" +
   {IF {MERGEFIELD MFC_testlookup2} = "Yes" "82" +
      {IF {MERGEFIELD MFC_testBusinessType} = "Couple" "164" ""}}}
Each mergefield has a variable that needs to be added together at the end, so assuming they are all 'true', the total output should be 328. Obviously it doesn't work, but this is the only method of doing this I can think of; then again I'm pretty new to this so any help is highly appreciated!
Reply With Quote
 

Tags
if statements, merge fields, nested merge



Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for a way to implement building blocks lodi123 PowerPoint 3 08-03-2017 04:33 AM
How to implement addition into a nested IF mergefield? “nested” IF/Then with Mergefield, utilizing Conga and Salesforce links. aronfromct Mail Merge 7 05-16-2017 05:39 AM
How to implement addition into a nested IF mergefield? Addition James__S Word 1 08-18-2016 06:20 PM
How to implement addition into a nested IF mergefield? Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
How to implement addition into a nested IF mergefield? How do I implement Outlook? Saturn1 Office 7 05-27-2005 09:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:19 PM.


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