Hi all,
I am looking for some assistance with my limited Excel knowledge to find a way to hard paste values after a cell calculates a formula.
The problem:
I have an expense sheet with expenses in various currencies. For tracking I have a formula that converts into one currency. Naturally the price changes along throughout the year and will cause accounting issues down the line.
I am looking for a way to do the calculation when the expense is inputted but paste the value in another column so it is not affect by the change in currency price.
I have attached an example to help with understanding.
Thanks in advance,
Adam
Calculation help.xlsx
Bookmarks