Is it possible to retain functions or formulas in cell in such a way that if
it returns no data one can type data into the cell but retain the function or
formula so that when data does become available in the refered to sheet it
will respond to it?
Thanks!
Ed

A cell contains a formula or it doesn't. You can't have both.

But you can use some helper cells to give that kind of effect.

Say your formula is in C2
you can put the manual entry in D2
and in E2, you could decide which to use
=if(d2<"",d2,c2)

And use E2 in all your subsequent formulas.

milkman wrote:

Is it possible to retain functions or formulas in cell in such a way that if
it returns no data one can type data into the cell but retain the function or
formula so that when data does become available in the refered to sheet it
will respond to it?
Thanks!
Ed

--

Dave Peterson

That is helpful!! Thanks Dave.
Ed

"Dave Peterson" wrote:

A cell contains a formula or it doesn't. You can't have both.

But you can use some helper cells to give that kind of effect.

Say your formula is in C2
you can put the manual entry in D2
and in E2, you could decide which to use
=if(d2<"",d2,c2)

And use E2 in all your subsequent formulas.

milkman wrote:

Is it possible to retain functions or formulas in cell in such a way that if
it returns no data one can type data into the cell but retain the function or
formula so that when data does become available in the refered to sheet it
will respond to it?
Thanks!
Ed

--

Dave Peterson