Hello,
Please help me.
In a spreadsheet I need to assign the currency that we receive money in.
There is a column that states the currency in a 3 letter code.
The amounts are downloaded from a CSV file.
Here is the fomula that I am using.
=IF(ISTEXT($A51),IF($E51="USD",TEXT($G51,"$
#,##0.00_)"),IF($E51="EUR",TEXT($G51,"‚¬ #,##0.00_)"),"")))

The problem with this formula is that it converts the amount to text.
How can I get this or is there another formula that will give me the answer
in the relevant currency, as a value with the relevant currency, without
having to set the format using the "Cell Format" function?


Thank you for your help.

Max