Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-01-2018, 07:49 AM
Louiseaf Louiseaf is offline How can I write a complex if_then_else statement in Word Windows 10 How can I write a complex if_then_else statement in Word Office 2016
Novice
How can I write a complex if_then_else statement in Word
 
Join Date: Oct 2018
Posts: 3
Louiseaf is on a distinguished road
Exclamation How can I write a complex if_then_else statement in Word

Hello

I am having a bit of difficulty figuring out a way to get this statement to work. I am pulling data from an online recruitment portal so my data source isn't particularly flexible.

This is the text:

(this line always appears)Please note that this offer is subject to the following conditions:


{IF{ MERGEFIELD pvgdisclosure}="PVG Children"
• PVG: You successfully gain and maintain membership of the Protecting Vulnerable Groups scheme in relation to children " ""}{IF{ MERGEFIELD pvgdisclosure}="PVG Adults"
• PVG: You successfully gain and maintain membership of the Protecting Vulnerable Groups scheme in relation to Adults" ""}{IF{ MERGEFIELD pvgdisclosure}="PVG Both"
• PVG: You successfully gain and maintain membership of the Protecting Vulnerable Groups scheme in relation to Adults and Children" ""}{IF{ MERGEFIELD gtcs_apply}="Yes"
• GTCS: You successfully gain and maintain registration with the GTCS. " ""}{IF{ MERGEFIELD sssc_apply}="Yes"
• SSSC: You successfully gain and maintain registration with the Scottish Social Service Council. " ""}

The above currently works. However what I want to set is if none of the above applies, I want the merge to input this line:
•There are no applicable conditions to this offer.

Hopefully that makes sense?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex IF(AND statement to manipulate weighted grades - better way? ddeaton Excel 11 07-11-2016 02:03 PM
How can I write a complex if_then_else statement in Word I'm not able to write any thing in my MS WORD 2007. Arfan Word 1 09-10-2014 11:25 AM
write need help and copy write need help on another page auto wykoems Word 2 07-25-2013 07:56 AM
How can I write a complex if_then_else statement in Word Searching for Word Reformatter for Complex Docs jchapman Word 1 05-05-2011 04:50 PM
How can I write a complex if_then_else statement in Word How to write a table of contents in word ugurkocak1980 Word 4 05-31-2010 06:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:06 AM.


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