 Hi guys, welcome back to my YouTube channel. This is Daniel Rosel here. I want to do a quick video today. Something I'm doing at the moment a lot is converting between Israeli salaries and world salaries. So I just want to show quickly what you can do to save yourself a bit of time. Build out a Google sheet commonly called a G sheet for doing this conversion. So I'm going to call this Israel to World Salaries. And I've done a blog post about this before, but I I always like to just think it's easier to sometimes narrate something as a video or screen share explanation. So what I'm going to do is I'm going to pick an Israeli salary. So we're going to say salary in sorry, ILS. You'll commonly see people abbreviate the shackle as NIS. I think ILS is technically more official and I'm going to plug in 17,000 as my amount. Now people are going to point out, well, you know, you can't just do an equivalence like this. Yes, there's going to be complications for social security. There's going to be other factors. This is just part of the research process. I'm going to call these exchange rates. So what I'm going to do is that's my salary in shackles. I've gone for 17,000 is kind of a, you know, basic. Well, salaries, you'll find salaries lower. You'll find salaries higher than that, but something normal, let's say. And then I'm going to run a few conversions to Equiv equals USD. Whoops, I can't do that. Equiv USD equivalent in Euro. And I'm going to do equivalent in pounds sterling, Great British Pounds GBP. And now I'm going to just bake in a few formulas. So this is, this is what you do. So Google Sheets works with Google Finance and you can use Google. Call Google Finance in a formula, which is really useful because you'll be able to pull in the live exchange rates. So that means that when you open up your, this document, you'll know that you're using the actual current exchange rate. So particularly when you have currency pairs like the Israel, the shackles, a dollar pair that's moving quite quickly at the moment, it's important to be using updated info. So here's just what I got from the internet and just demonstrate the usage. So here's your starting cell, asterisks for multiplying by Google Finance. Then in brackets, you have your currency pair. So the, the syntax is currency, currency semi colon origin currency and target currency. So that's how you denote the currency pair and then close off quotation and close bracket. Now there's a complication in that salaries in Israel are quoted in monthly and in most of the world, it's per annum or per year. Therefore we're going to need to multiply the origin figure by 12 and then do the exchange. So that's not so hard. Our starting field is B2 equals our Israeli salary on this example. So what we're going to need to do here is equals for the US dollar. Let's start with that B2 multiplied by 12, then run this through whoops, the currency exchange API from Google Finance, then close off. I'm just going to save myself time, copy and paste. Now you might be wondering, well, how do I know what currency codes to use? So you can look up an online reference for just remember it's coming from Google Finance. So there's a website called spreadsheetpoint.com and they have the US dollar, Japanese yen. Canadian dollar is C-A-D, Euro is E-U-R. The Great British Pound is GBP and the Hong Kong dollar is HKD and the Singaporean dollar is SGD. So let's go now and change these round a little bit. So the second one is going to be to Euro and the third one is going to be to Great British Pounds. So just to reiterate what we're doing here equals our Israeli salary in field B2, multiply that by 12 to convert to per annum, then multiply that by this Google Finance formula, which is Google Finance, open brackets, quotation mark currency, colon, ILS, then the target currency and quotation mark and brackets. So let's just plug that one in firstly and we're good. So 17,000 shackles is equivalent to 65,606 dollars per year. So I'm going to show you how to round those down in a second in case you don't know. Now into the Euro field, you can tidy this up and put in the currency symbols as well. This is just kind of doing it a bit rough, but it should work. And finally, Great British Pounds. Now those are kind of awkward numbers to work with. 65,606, 57,332 euros and it's 48,904. And those exchange rates are all current FX. So what you can do is just displace the decimal a little bit so you can just round off this number here. And I'm just trying to figure out where that rounding utilities actually gone. But it's definitely somewhere, here we go. So if you see decreased decimal places, so you probably just need it to the nearest integer. So there we go. So now we're just rounding to the nearest integer. So 65,000 and you can add quotation marks if you will. And that's it. So 17,000. So what if I change the number? So what's 15,000 in dollars? 15,000 at today's exchange rate would be an annual USD salary of 57,888. And in Euro it would be 50,857 euros. I'm just going to zoom up a bit here. Let's do, whoops, yeah. Well if you're earning 19 shackles it would not be very good. 20,000 is 77,000 dollars. 25,000 is 96. Now if you wanted to work the other way you could of course also do that. So let's build out again salary in USD. So how much, what, if you wanted to make a salary of 100,000 dollars, well what would you need to earn in shackles? So I'm going to just do this time equivalent in ILS. And this is field E2. So we're going to just reference field E2. So E2 is our American salary. So therefore what we're going to do is going to be equals E2 divided by 12. So we're working the other way around this time. Multiplied, Google, Finance. And we're going to also be reversing the currency pair. It's USD to ILS rather than the other way around. And that should be good. So now I'm going to just go and patch that into my formula field. And a salary, a six figure salary of 100,000 USD exactly is at the time of recording this video equivalent to 25,912 shackles per month. So basically let's call that 26,000. So if you're earning 26,000 shackles, if you're earning that brutal or more than you're earning actually a gross salary of more than six figures in the US, and that usually that number in shackles is higher, but obviously right now it's a, because the currency exchange pair is in such a crazy place, that number is lower than you might expect. So, and then just Google, Finance puts up this disclaimer automatically at the bottom of your sheets saying quotes are not sourced from all markets and maybe delay by up to 20 minutes. Basically it's good enough for this purpose. So that is it guys. Hope that video was useful. Thank you for watching and feel free to subscribe for more videos from me.