M
Mark Mulik
Howdy.
I'm trying to write a formula that would allow me to add a value to
the row number of a cell name. These attempts have been unsuccessful:
=Sheet1!D(4+B4)
So, if the contents of cell B4 were 1, then the formula would add 4+1
and thus reference the contents of cell D5 in Sheet1.
I've also tried it more simply as:
=D(4+1)
and that doesn't work either.
I've also done the math in another cell -- let's call it E7 -- such
that the contents of E7 are =4+1 and then tried this:
=D(E7)
but that didn't work either.
Can this be done?
Thanks.
Mark
I'm trying to write a formula that would allow me to add a value to
the row number of a cell name. These attempts have been unsuccessful:
=Sheet1!D(4+B4)
So, if the contents of cell B4 were 1, then the formula would add 4+1
and thus reference the contents of cell D5 in Sheet1.
I've also tried it more simply as:
=D(4+1)
and that doesn't work either.
I've also done the math in another cell -- let's call it E7 -- such
that the contents of E7 are =4+1 and then tried this:
=D(E7)
but that didn't work either.
Can this be done?
Thanks.
Mark