Forum Discussion
mergefield Word must choose between three options in Excel
Can you upload a sample file for better understanding
Abiola1Thanks for your reaction. Here are examples of the 2 files I use. I would like the mergefield to contain something like: if cell 1 and cell 2 are empty, than show cell 3
If I were you, I'd change your Excel sheet and use one column for a currency code and one for the amount. You can then combine the currency code and the amount to indicate that you are billing e.g. EUR 33.57 or GBP 90.70
Oh my God, I found out such an extreme simple solution! The formula is simply putting all three mergefields in a row, since an empty merge doesn't show! So if there's no amount in dollar or pound, the euro-amount is the only one that shows in the merge!
{ MERGEFIELD Euro \b "€ " }{ MERGEFIELD "Dollar"\b "$ " }{ MERGEFIELD Pound"\b "£ " }
I almost feel ashamed to have bothered you all. Thanks for all the advices, though.
