Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Exchange rates
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Exchange rates
Resolved · Low Priority · Version 2003
Reply
Exchange rates
How do I calculate different exchange rates for various cells?For upcoming training course dates see: Pricing & availability
RE: Exchange rates
Hi RebeccaThank you for your question
Calculating exchange rates usually involves multiplying an amount by a fixed decimal to calculate the conversion.
In Excel the most efficient technique would be to place your conversion rate in a cell within your workbook, and then multiply the cells containing the unconverted currency by the conversion rate to get the new figure
I sense from your question however that you have a range of different currencies and you wish to choose which one to convert to. This would involve having a column in your table which specifies the currency to be used, and then to create a lookup table listing the currencies and there conversion rates. You would then use a Vlookup function to calculate the conversion.
Vlookups are covered on the advanced Excel course
Regards
Stephen
Tue 8 Dec 2009: Automatically marked as resolved.
|
 |
|
» Forum post: MS Project |
How do I charge for my time?
