| Have you considered using, instead, a lookup table that would do this? That way, if I want to change the conversion rate next week, I don't have to edit a formula - I just change the conversion rate | |
|---|---|
| I'd add a ROUND function to get rid of anything past the second decimal, and add a True False switch at the end to ensure that you don't apply an incorrect Fx amount to a date which doesn't exist in your table | First, you need to know the exchange rate for the two currencies |
There are a number of sources of historical currency fx rates which you could download and input into a table.
4| If this is all a complete mystery, comment back and I'll try to explain it better | Thanks- Fairly simple math issue |
|---|---|
| Learn more , our latest services, and how we became known as the world's currency data authority | The yen has continued to underperform and is showing a 2 decline against the dollar from yesterdays opening levels |
Since that might end up with a number of decimal places, you might round it so that it ends up with just two.
28