A
arasan77
I need to calculate a value using a formula that uses the reference to a
previous cell (e-g. "A10", when the formula used is for computing "A11"; in
the next row "A11" needs to be used for calculating "A12" and so on...), when
the cell in which the formula to be used keeps varying. For example, I need
to compute today's gain or loss compared to the previous day's, on a daily
basis in real time. Is there any way to do this in Excel 2003? In other
words, can I use the equivalent of "contents of cell A(i)" in the formula
contained in cell "A(i+1)", as could be used in any programming language?
Thanks for all, who could provide me an answer.
previous cell (e-g. "A10", when the formula used is for computing "A11"; in
the next row "A11" needs to be used for calculating "A12" and so on...), when
the cell in which the formula to be used keeps varying. For example, I need
to compute today's gain or loss compared to the previous day's, on a daily
basis in real time. Is there any way to do this in Excel 2003? In other
words, can I use the equivalent of "contents of cell A(i)" in the formula
contained in cell "A(i+1)", as could be used in any programming language?
Thanks for all, who could provide me an answer.