mergefield Word must choose between three options in Excel

Question

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 merge the excel database with the word invoice, I would like the mergefield to choose the excel field from the right column, in which I filled in the amount.

p.e.: client x is from Europe, so I filled in an amount in column €

client y is from US, so I filled in an amount in column $

client z is from UK, so I filled in an amount in column £

I want to merge these 3 items in 1 standard invoice, so the mergefield must know which cell in excel it has to use. Can anyone help me with that?

abiola1 · Answer

Hello,Can you upload a sample file for better understanding

sergeibaklan · Answer

kroest71&nbsp;
That could be like

Insert fields will be used one by one, after that from Rules any IF statement, Alt+F9, copy/paste into final IF .. ELSE field your fields, Alt+F9 back. Remove temporary fields.

chrismendoza · Answer

kroest71&nbsp;-Using 3 columns [client], [country], [amount]:&nbsp;

kroest71 · Answer

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

kroest71 · Answer

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!&nbsp;{ MERGEFIELD&nbsp; Euro \b "€ " }{ MERGEFIELD "Dollar"\b "$ " }{ MERGEFIELD Pound"\b "£ " }&nbsp;I almost feel ashamed to have bothered you all. Thanks for all the advices, though.

Forum Discussion

mergefield Word must choose between three options in Excel

6 Replies

Resources