How can I store calculations using a currency exchange rate (stored in A1 for example) but not have the result change when the exchange rate is update?
I do not want to store each exchange rate variation in a new location every time it changes.