A Google Sheet For “Converting” Israeli Salaries Into International Ones (And Vice Versa)
One of the peculiarities of the Israeli job market is that salaries are typically paid monthly in local currency.
These days, lots of Israel-based talent is exploring the increasing opportunities that remote working have opened up for working with internationally-based organizations. Unfortunately, many remote jobs remain restricted to US-based candidates. But there are a growing number of international companies who are recruiting in Israel while paying in foreign currency.
This means that many people are finding it necessary to compare where local salaries stand against international ones.
Although I’ve rarely been called a maths prodigy, I did know enough to be able to put together this very basic Google Sheet to run calculations between the two.
I’ve set the sharing permissions to public (but view only). It can be accessed at the below link. To actually use the spreadsheet, you can download and/or copy it into your own Google Drive.
The operation is very simple. It uses Gsheets’ ability to integrate with the Google Finance API in order to pull in live exchange rates so that the figures you get, going either way, should be accurate up to the moment you’re running the calculation.
In case you want to build it for yourself, here are the formulae:
Salary in shekels (per month) to salary in Euro (per year):
=12*(C3*GOOGLEFINANCE(“CURRENCY:ILSEUR”))(Where C3 = the salary you wish to compare in shekels).
To convert a salary in USD (per annum) into a salary in Shekels:
=(B6*GOOGLEFINANCE("CURRENCY:USDILS")/12)(Where B6 = the salary in the US dollar that you wish to convert into shekels (per month).
