db0company/gist:e8c34e7518709fc4adcc02166b812a74

Created June 19, 2018 14:56

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/db0company/e8c34e7518709fc4adcc02166b812a74.js"></script>
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