L
lsu-i-like
on worksheet 1, i want to have a column of cells that do the following:
2D = 2A + 1A
3D = 3A + 1A
4D = 4A + 1A
i want one reference to change and one reference to stay the same. i
that possible, and if so, how?
i just figure it out, by using the indirect function again...
2d=2a+indirect("1a")
then just copy that cell.
wow, i love indirect
2D = 2A + 1A
3D = 3A + 1A
4D = 4A + 1A
i want one reference to change and one reference to stay the same. i
that possible, and if so, how?
i just figure it out, by using the indirect function again...
2d=2a+indirect("1a")
then just copy that cell.
wow, i love indirect