| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to "previous cell" in a formula in a "varying current ce
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| keyboard shortcut to return to previous cell after "find" or "got. | New Users to Excel | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
