I have a table with 7 different currencies. I need to have a number and the
corresponding currency in a single field. I know it is possible in Excel but
cannot find the right syntax. My table shows quantities multiplied by rates
using different currencies. Like 10 * 5 Euros = 50 Euros, 7 * 10 Renminbi =
70 Renminbi and so on.

The currency should not be in a different field but should actually define
the amount itself.