IF Statement in Word merge using AND

Jenny Norton

I have an If..then..else statement in my receipt letter that formats how the funds print, if there is more than one. For example: If fund 2, is blank, it just prints fund 1's description, else it prints fund 1 and fund 2. If fund 3 is blank, it prints fund 1 and fund 2, else fund 1, fund 2 and fund 3. Etc. up to 5 funds. We are now implementing an admin fee and they do not want that fund to print on the receipt letter. So my new If...then...else statement was { IF {MERGEFIELD Fund_description_2 }= "" "{ MERGEFIELD Fund_description_1 }" { IF {MERGEFIELD Fund_ID_2 } = "UNIV3513184702" "{ MERGEFIELD Fund_description_1 }" "{ MERGEFIELD Fund_description_1 } and { MERGEFIELD Fund_description_2}" and so on. Is there a better way to do this? Is there a way to do and IF...AND so that I can say if Fund2 is not blank and not equal to UNIV, print fund 1 and fund 2; if fund 3 is not blank and not equal to UNIV, print fund 1, fund 2 and fund 3. I've spent hours googling and trying but I can't find the right syntax if that is possible to have IFs ANDs together so that is why I tried the above. My above sample seems to work fine for the first two funds but it won't print fund 1, fund 2 and fund 3 when fund 3 is not the UNIV#. Thank you for any guidance. Jenny