I concur with jzw95, much easier to add a column which you can autofill in the spreadsheet.
I worked in Foreign Exchange, golden rule was Currency 1, Currency 2 & exchange rate are the three components. You only ever pass two of the three downstream through systems OR you get errors.
Reason being currency rates are usually to 4 decimal places, calculations will end up with the calculated currency being a potentially large number of decimal places which is rounded to two to get a meaningful answer.
i.e. if you get Currency 1, Currency 2 and exchange rate you will end up with numbers that don’t work because of the rounding. much better to have Currency 1, Currency 2 and derive the rate, that is what you will have actually have done the “real” exchange at. Make sense?