Mergefields and if statments

[Wired_Inside_90]

Hi all,

 

This is an odd one and I'm not even sure it's possible.

 

Currently, and for some reason beyond my payscale, we use mail merges to import grades and make reports in word. This is just used for EYFS and not other depts.

 

is it possible for me to check whether the mergefield is true or false and if true add an X, instead of the value in excel.

 

My table looks like this. I have made bookmarks to reference Attainment(1-3) in each column in Word.

 

 

and this is the mergefield from excel.

 

I guess i want to say "if mergefield = Attainment1 display X, if false dont show anything.

 

I would then use this for each column of attainments 1-3.

 

Ideally I would just add the data but they don't want it changed.

 

If anyone has any ideas on how to tackle it I'd love to hear.

 

Many thanks

[SpreadsheetJockey]

Not exactly sure what you're after, but just an if statement in your mergefield e.g. {IF {mergefield} = "1" "X" ""} etc. might accomplish it? You'd need to CTRL+A & F9 (refresh) the page to see the results of an edited mergefield.

[Wired_Inside_90]

Cheers! I knew I was getting the syntax wrong somewhere.

 

All sorted, thanks for your help.