| Our latest currency calculator is a direct descendent of the fast and reliable original "Universal Currency Calculator" and of course it's still free! And you could use the currency formatting for cells A2 and A3 to properly reflect that they are Sri Lankan and Australian currencies | Learn more , our latest services, and how we became known as the world's currency data authority |
|---|---|
| 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 | First, you need to know the exchange rate for the two currencies |
But rather than "hard wire" the conversion rate into the formula, I would reference the conversion rate I just put in Cell A1.
24| Scenario is that we purchase materials in both MX and US for projects and will be entering both currencies into the sheet | |
|---|---|
| Since that might end up with a number of decimal places, you might round it so that it ends up with just two | Then I would set up A2 to contain the number of Sri Lankan rupees I want to convert, say, 1,000 |
Usd jpy printed a 10 month high at 11219 and eur jpy posted a two week high at 12109.
30| Trying to create a spreadsheet that converts both directions - Pesos to dollars or dollars to pesos; my formulas are "at war" with one another | Thanks- Fairly simple math issue |
|---|---|
| Have you considered using, instead, a lookup table that would do this? If you want to convert Sri Lankan Rupees into Australian Dollars, you would divide the number of rupees you have by | The Original Currency Exchange Rates Calculator Since 1995, the Xe Currency Converter has provided free mid-market exchange rates for millions of users |
I would set up a worksheet that shows, in cell A1, the conversion rate - so A1 would equal.
5