![]() |
#8
|
||||
|
||||
![]()
I've tracked the problem down to the presence of the year # in the IF test. You can overcome that by replacing 2017 with ????, as in:
{IF{MERGEFIELD Fund_description_1} = "???? Fund_Arts" "ARTS"}{IF{MERGEFIELD Fund_description_1} = "???? Fund _Athletics" "ATHLETICS"}{IF{MERGEFIELD Fund_description_1} = "???? FUND_Financial Aid" "FINANCIAL AID"} or: {IF{MERGEFIELD Fund_description_1} = "???? Fund_Arts" "ARTS" {IF{MERGEFIELD Fund_description_1} = "???? Fund _Athletics" "ATHLETICS" {IF{MERGEFIELD Fund_description_1} = "???? FUND_Financial Aid" "FINANCIAL AID"}}}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
marym | Mail Merge | 3 | 04-09-2016 05:17 AM |
![]() |
sfkHooper | Mail Merge | 6 | 01-19-2016 04:24 PM |
Nesting and IF & AND statement | lynchbro | Excel | 4 | 04-16-2015 11:39 AM |
![]() |
mdod | Word | 1 | 07-19-2013 06:33 PM |
![]() |
Wyskers | Word | 1 | 11-13-2011 05:43 AM |