Kick off this New Year with 25% off on Kopyst Subscriptions! Use code NEWYEAR25
document-icon
How to convert currencies in Google Sheets ?
By Mitisha
|
Sep 03, 2024
|
document-icon Google
|
6 Steps
Learn how to effortlessly convert currencies within Google Sheets. This document will walk you through the simple steps of using the GOOGLEFINANCE function to fetch real-time exchange rates. You'll discover how to create formulas that automatically calculate conversions, saving you time and effort. Whether you're tracking international expenses, analyzing global market data, or managing financial reports, this tutorial will equip you with the knowledge to streamline your currency conversions in Google Sheets.
document-icon
How to convert currencies in Google Sheets ?
By Mitisha
|
document-icon Google
|
6 Steps

1
2
Create a column of "Prices in USD"
Merged Image
3
Add a column of "Currency" codes
Merged Image
4
Double click on the empty "Cell".
Merged Image
5
Add this formula: "=A2*GOOGLEFINANCE("CURRENCY:USD"&B2)"
Merged Image
6
Copy and paste the formula for other rows and press "Enter".
By following these steps you can convert currencies in google sheets
Merged Image

Create your own professional guides

Start creating your own How-to guides and videos today!

App page Cta