How To Calculate Change Rate In Excel. Find out the current exchange rate between us dollar and euro, and enter it in a blank cell. The payment made each period, and this is a fixed amount during the loan or investment.

Then you can enter the following formula in cell d2 to calculate percentage change in your excel sheet: (increase = initial value − final value) next, divide the increase by the initial value. To calculate the average rate of change from the first time to the last, you have to use this formula.