![]() |
#1
|
|||
|
|||
![]()
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? |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
jchapman | Word | 1 | 05-05-2011 04:50 PM |
![]() |
ugurkocak1980 | Word | 4 | 05-31-2010 06:10 AM |