Hi,
I want to have a variable as the cell number.
I have C82, which shows a number, varying from 1-31, depending on the day of the month.
I am calculating percent change from day to day. So on day 2, I want (Day 2 value minus Day 1 value, all divided by day 1 value)
and on day 3, I want the calculation to be (day 3 value minues day 2 value divided by day 2 value) and so on for every day.
I want the formula to be Dx-D(x-1)/D(x-1) with x equalling whatever value i put in for cell C82.
so in C82, on November 2nd the value is 2 (for D2)
the formula i want would compute:
(Dx-D(x-1))/D(x-1) with x=2
the next day i want it to input a 3 into C82, and have the formula give me:
(Dx-D(x-1))/D(x-1) with x=3 which is (D3-D2)/D2
Anyone understand what I am trying to do who can help???
Bookmarks