Converting Currency Values in Numbers (#1532)

Converting Currency Values in Numbers (#1532)


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.

Leave a Reply