![]() ![]() This could be for a single day, a week, a month, or longer. It will list the rate at the end of each day, for a period specified by you. The GOOGLEFINANCE function can also be used to provide historical exchange rates. RELATED: How to Multiply Numbers in Google Sheets Finding Historical Currency Conversion Rates The GOOGLEFINANCE function is used in cells A3 to A5, returning the then-current USD to GBP rate.īy multiplying the USD figure in column B against the USD to GBP exchange rate in column A, the converted GBP amount is returned in column C. The example above shows three different USD figures in column B converted to GBP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |