Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to calculate exchange rate?
Please I need a formulea to calculate Country exchange rate?
Many thanks |
#2
|
|||
|
|||
Question is a bit vague... If you just want a formula to say convert $10
(In A1) to £GBP (In B1) at a rate of 1.8 £/$ then in Cell B1 enter =A1/1.8 You can put the exchange rate in say C1 and always refer to that, so it's easy to change =A1/$C$1 or is you have a series of currencies with say currency codes in a table with their exchange rates then you should consider looking at VLOOKUP in help If you need more help. post back with more info -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "papa404" wrote in message ... Please I need a formulea to calculate Country exchange rate? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate sales run rate | Excel Discussion (Misc queries) | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
What formula do I use to calculate compound annual growth rate (C. | Excel Discussion (Misc queries) | |||
calculate interest on an increasing balance with variable rate | Excel Discussion (Misc queries) | |||
How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions |