Real-Time Currency Conversion in Excel: A Quick Guide Using GOOGLEFINANCE

Steps to Fetch Live Exchange Rate in Google Sheets:

1. Use the GOOGLEFINANCE Function: The formula to get the current exchange rate from GBP to USD is:

   =GOOGLEFINANCE("CURRENCY:GBPUSD")
   

   • "CURRENCY
     " refers to the exchange rate from British Pounds (GBP) to US Dollars (USD).
   • This formula will automatically fetch and display the most up-to-date exchange rate.

2. Apply the Formula in Your Sheet:

   • In any cell (e.g., A1), enter the formula =GOOGLEFINANCE("CURRENCY:GBPUSD").
   • The cell will now show the latest exchange rate for GBP to USD, and it will update automatically.

3. Perform Conversions Using the Dynamic Rate:

   • Suppose you want to convert £29 to USD dynamically.
   • If the exchange rate is in A1, and the amount in GBP (29) is in B1, use the following formula in another cell to convert:

   =B1 * A1
   

   This formula will multiply the amount in GBP (B1) by the latest exchange rate in A1 to give you the converted value in USD.

4. Automatic Updates:

   • The exchange rate will update whenever the sheet is recalculated or manually refreshed (by reopening the Google Sheet or pressing Ctrl + R to refresh the data).

Example:

If you input =GOOGLEFINANCE("CURRENCY:GBPUSD") in A1 and type 29 in B1, you can convert the amount by using =B1 * A1, which will dynamically give you the current equivalent in USD.

Would you like to set this up, or do you need further clarification?

Click to Chat