The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Currency Conversion in Excel

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Currency Conversion in Excel

Resolved · Urgent Priority · Version 2003

ReplyTue 25 May 2010, 20:16Delegate Karmen said...

Currency Conversion in Excel

Hi

I was wondering if there is a formula or other way to be able to convert currencies from NOK to GBP in excel?

Thanks

For upcoming training course dates see: Pricing & availability

ReplyWed 26 May 2010, 08:11Trainer Stephen said...

RE: Currency Conversion in Excel

Hi Karmen

Thanks for your question

In principle converting one currency into another involves a simple formula, multiplying the currency by the appropriate conversion rate.
The most sophisticated example I have seen was the use of a live data link to provide a lookup table with up to date currency conversion rates.
A Vlookup function was then combined with a simple formula to provide up to date conversions.
If you could give me more information about the background of your problem, I could perhaps be a bit more specific.
Regards
Stephen

Tue 1 Jun 2010: Automatically marked as resolved.

Excel articles

· How To Make Excel Open A Particular File When It Launches
· What Are Sparklines In Excel 2010?
· Discover The PMT, IPMT And PPMT Functions In Excel
· Learn The Secrets Of COUNT Functions In Excel
· How To Create A Data Table In Excel 2010

Please browse our web site to find out more about
microsoft excel course and other Microsoft training courses.

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

I'm trying to create a church directory. I want to create a template to use to make it easier for anyone to use. I want a space at the top to insert a picture in and under that all the info like name, address ect. The space where the pictures goes need..

» Forum post: Creating a Church Directory

How SharePoint Can Lift Your Business Into The Cloud

From saving power to cutting down on the cost of emptying rubbish bins, the cloud has proven to be an invaluable move for organisations across the globe. We take a look at how Microsoft SharePoint can be the perfect platform to help you move to the cloud.

» Article: Sharepoint 2010 end user training + uk

Rate this page: