Skip to content

Instantly share code, notes, and snippets.

@db0company

db0company/gist:e8c34e7518709fc4adcc02166b812a74

Created June 19, 2018 14:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save db0company/e8c34e7518709fc4adcc02166b812a74 to your computer and use it in GitHub Desktop.
Save db0company/e8c34e7518709fc4adcc02166b812a74 to your computer and use it in GitHub Desktop.
Download ZIP
Google sheets convert yens to us dollars
Raw
gistfile1.txt
=GOOGLEFINANCE("CURRENCY:JPYUSD")*REGEXEXTRACT(C182,"\d+")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment