Forum Discussion
mergefield Word must choose between three options in Excel
I need a formula for a mergefield in word that chooses between 3 options in the database. In that database I have 3 columns: 1 for clients in Europe, one for clients in US and one for UK. So when I m...
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