Converting Currency Values in Numbers (#1532)


There are a lot of different ways to convertcurrency values in Numbers.

Let's take a look at some of the functions.

I'm going to start a Formula here by hittingthe Equals key.

On the right I'm going to search in functionsfor things that have to do with currency.

So let me search for currency.

You can see that there are four differentfunctions here.

So let's jump ahead and take a look at Currencyconvertwhich is a really simple one.

So we look at the function here and it's currencyconvertvalue into currency-code.

We can start with that.

We'll convert say if I want to convert tendollars.

Since I'm set to be US English for the languageit'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 couldhave provided a string here with a currency value in it.

So 10 with the dollar sign, $, and it wouldwork.

That's one way to deal with making sure thatyou'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 ituses the right currency.

So I'll do currencyconvert.

I'll select this cell as the value and I'lluse the euro as the code.

So that's a pretty simple way to do it.

It's going to take the number from the previousdays' close.

So it's not a live currency update but it'sclose enough.

It's just what it was at the end of yesterday.

So for exact calculations you may want tohave some more sophisticated financial software.

But for just general things with what today'sprice is, this will work.

Now let's take a look at some of the otherfunctions.

So we'll delete this formula here and we'lllook at Currency.

So Currency what it will do is it will convertfrom one currency to another and give you the price.

So, for instance, I can do Currency and Ican say US dollars to euro and what it will give me is basically how much one dollar isin euros.

I can put another parameter here and you cansee 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 openprice 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 samedata for the current day but you can also set a date.

So you can go, say, what was it the end oflast week or a year ago.

That kind of thing.

There's also a currencycode function whichwill tell you the code for value.

So if I were to do, let's say, currencycodeselect 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 forall these functions that it says that the currency codes are defined by ISO 4217.

So if we simply search for ISO 4217 we canfind that in Wikipedia and quickly get to the table here where it tells you codes fordifferent countries and currencies.

Source: Youtube

Converting Currency Values in Numbers (#1532) 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.