Hi,
I have a table in excel with a column that contains prices in $ and in local currency.
I need a formula that can check if the amount is in $ or local currency.
Now the formula must be : If the value is in $ it will be multiply for a rate and exchange to local currency and write the result in another column .If it is in local currency , it must be wrote in the same column that the amount that we exchange.
Bookmarks