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 | If you have the dates in ascending order in column A and the exchange rate in column b, your vlookup formula could use the date, get the exchange rate, then apply that against your medical bill amount |
---|---|
Then I would set up A2 to contain the number of Sri Lankan rupees I want to convert, say, 1,000 | There are a number of sources of historical currency fx rates which you could download and input into a table |
Learn more , our latest services, and how we became known as the world's currency data authority.
4Thanks- Fairly simple math issue | Trying to create a spreadsheet that converts both directions - Pesos to dollars or dollars to pesos; my formulas are "at war" with one another |
---|---|
Since that might end up with a number of decimal places, you might round it so that it ends up with just two | The Original Currency Exchange Rates Calculator Since 1995, the Xe Currency Converter has provided free mid-market exchange rates for millions of users |
The yen has continued to underperform and is showing a 2 decline against the dollar from yesterdays opening levels.
19