Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2023, 06:46 PM
Charles Kenyon Charles Kenyon is offline How to implement addition into a nested IF mergefield? Windows 11 How to implement addition into a nested IF mergefield? Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,535
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default


It can work with If fields, yes.
{ = { If { MergeField HasAttorney } = "True" "£82" "0" } + { If { MergeField Day } >= 3 "2" "0" } }
This assigns a given amount to be included in the addition given passing a test. If the condition is not met you could have nothing or have a 0.
Reply With Quote
  #2  
Old 12-21-2023, 04:12 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

Thank you Charles it works

The finished result of what I'm going to use is below, and looking at it now I feel a bit silly its so straightforward.

Code:
{ = { IF {MERGEFIELD HasAttorney} = "Yes" "82" "0" } + { IF { MERGEFIELD HasLPA } = "Yes" "82" "0" } }
The result for the most part either being 82 or 164 depending on the database client.

Thank you again!
Reply With Quote
Reply

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 01:21 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