Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incrementing cell references in a formula in steps
Hello MS,
Is there a way of incrementing cell references in a formula in steps: eg =sheet1!a1 + sheet2!a3 is there a way to say somehting like =sheet1!a(1+x) + sheet2!a(3+y) ??? where x & y are steps that we need to increment by. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incrementing a formula within an excel cell | Excel Worksheet Functions | |||
Incrementing cell references slower than by 1 | Excel Worksheet Functions | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Incrementing cell reference in Lookup formula | Excel Worksheet Functions | |||
How can I get the value of a cell to increase in steps? | Excel Worksheet Functions |