Dynamic calculation of last amount listed

tiverson

I have a file that calculates an amount from the last amount listed in the data.  The last amount will change each month when a new period begins.

How can I dynamically calculate the percentage amount?

Date          Amount            % calc

Jan 93       7.461               737.6904956    formula (Last amount listed \ Amount listed on current line - 1)

Feb 93       7.501               734.3520597

Mar 93       7.5229             732.211368

Last line of data (changes each period)

Mar 24       5515.8758

Thanks for the help!

Inflation sheet.xlsx

rzdodson

@tiverson here is one approach for you. Let me know if that's what you are looking for.

Solution.yxzp