I need a function that converts American Dollars to New Israeli Shekels in a Google Spreadsheet. Is there such a function, or a viable workaround?

  • First result on Google with following keywords google currency spreadsheet
    – Vasim
    Nov 1, 2013 at 12:22
  • I found that as well, but it doesn't seem to work for NIS.
    – Eden Landau
    Nov 1, 2013 at 13:02

2 Answers 2


The NIS (New Israeli Shekel) is not an international accepted currency, but the ILS (Israeli new shekel) is. Therefore you need to use the following formula




enter image description here
enter image description here


  • And to save space, you can do =GoogleFinance("CURRENCY:USDILS") * 792 (with 792 being the current USD value as an example)
    – A P
    Jun 14, 2021 at 16:19

to get by date

=GOOGLEFINANCE("CURRENCY:USDILS","price", date(2017,11,15))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.