Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save db0company/e8c34e7518709fc4adcc02166b812a74 to your computer and use it in GitHub Desktop.
Save db0company/e8c34e7518709fc4adcc02166b812a74 to your computer and use it in GitHub Desktop.
Google sheets convert yens to us dollars
=GOOGLEFINANCE("CURRENCY:JPYUSD")*REGEXEXTRACT(C182,"\d+")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment