Join us at GITEX 2024! Discover our solutions at Hall 4, Booth H-30 Book your live demo today.
header icon
Sign In
Chrome-icon
document-icon
How to convert currencies in Google Sheets ?
By Mitisha
|
Sep 03, 2024
|
document-icon Google
|
6 Steps
document-icon
How to convert currencies in Google Sheets ?
By Mitisha
|
document-icon Google
|
6 Steps

1
Navigate to https://docs.google.com
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