Converting Currency Values in Numbers

You can use one of four functions in numbers to convert monetary values from one currency to another. You can use the price from the previous day, or a historical value. If you need to know the special currency symbol, you can look that up online.

Video Transcript
There are a lot of different ways to convert currency values in Numbers. Let's take a look at some of the functions. I'm going to start a Formula here by hitting the Equals key. On the right I'm going to search in functions for things that have to do with currency. So let me search for currency. You can see that there are four different functions here.

So let's jump ahead and take a look at Currencyconvert which is a really simple one. So we look at the function here and it's currencyconvert value into currency-code. We can start with that. We'll convert say if I want to convert ten dollars. Since I'm set to be US English for the language it's going to assume dollars. So ten but I'm going to convert to Euros. I'm going to use the currency code for euro, EUR, as a string inside quotes. I'm going to get a result there.

Now another thing I could have done is I could have provided a string here with a currency value in it. So 10 with the dollar sign, $, and it would work. That's one way to deal with making sure that you're in the right currency. Use a string instead of a number.

If I was actually going to use something like $100.00 in here and it's formatted as dollars then it would pick it up and make sure it uses the right currency. So I'll do currencyconvert. I'll select this cell as the value and I'll use the euro as the code. So that's a pretty simple way to do it. It's going to take the number from the previous days' close. So it's not a live currency update but it's close enough. It's just what it was at the end of yesterday. So for exact calculations you may want to have some more sophisticated financial software. But for just general things with what today's price is, this will work.

Now let's take a look at some of the other functions. So we'll delete this formula here and we'll look at Currency. So Currency what it will do is it will convert from one currency to another and give you the price. So, for instance, I can do Currency and I can say US dollars to euro and what it will give me is basically how much one dollar is in euros. I can put another parameter here and you can see there's a list of them. There's change, percent change, open, high, low, 52 week high, etc., etc. So I could basically go with say the open price from yesterday and it will give me that. So you have some more functionality there.

Now there are also some other ones here. CurrencyH which is historical. So not only can you get a lot of that same data for the current day but you can also set a date. So you can go, say, what was it the end of last week or a year ago. That kind of thing.

There's also a currencycode function which will tell you the code for value. So if I were to do, let's say, currencycode select this which is know is a dollar amount I'm going to see that it is in US dollars. If this was in euros then it would put EUR.

Now how about these codes. How do you figure out what they are. So you can see here in the description for all these functions that it says that the currency codes are defined by ISO 4217. So if we simply search for ISO 4217 we can find that in Wikipedia and quickly get to the table here where it tells you codes for different countries and currencies.

Comments: 6 Responses to “Converting Currency Values in Numbers”

    Smoldt
    11/29/17 @ 8:15 pm

    You started in the middle. Where is the template? You might want to start with find the template ….

    11/29/17 @ 8:23 pm

    Smoldt: Template? I’m not using a template. I just using a “Blank” spreadsheet.

    Jordan
    12/8/17 @ 3:24 am

    Hi Gary, great video! It’s exactly what I need! However, I don’t have Currencyconvert as an option?! Are you aware of this being removed or do I need to enable advanced settings or download some sort of plugin? Thanks in advance, – Jordan

    12/8/17 @ 7:37 am

    Jordan: Do you have the latest version of Numbers?

    Remco
    1/13/18 @ 11:38 am

    Is it possible to convert Cryptocurrency Values in Numbers?
    Thanks

    1/13/18 @ 11:46 am

    Remco: There is no function for that.

Comments Closed.