Put this formula in C9:

=IF(U20="","",U20)

Why do you not want a formula in C9 ?

Hope this helps.

Pete

On Sep 15, 10:40*am, Lance1961
wrote:
Ill try to make this clear and in Excell-ese as much as possible! But I am
new. Thanks for your time.

I need to have a value from a formula in a cell, say u20, placed into
another cell, say c9. *

said another way... I want a value to be placed in a cell without that cell
containing a formula or being directly inputted to.

Sounds like an easy task, however Im told this is not do-able. *Im not
buying that.

Lance