Help with a Currency Conversion
Hi there, wondering if anyone can assist....
I am looking for a way to take various native currency amounts in say 2 separate columns (i.e. USD and EUR) - when I enter a respective amount a formula automatically takes that value, changes it to GBP in a separate destination column cell. The exchange rate can be a fixed rate - say USD to GBP being 0.72 for example.