Erol,

Formula cannot 'push' data, they can pull data so without a formula in A1 it
isn't possible to do what you want without resorting to code.

If you explain with more detail what you want then someone will help.

Mike

"Erol" wrote:

Hi All,

Somehow I want to enter a formula in cell A2 and I want cell A1 come up with
a number as a result of the formula entered in A2. Is there any way to do
this?

I don't want to enter a formula on A1 such as =if(A2=blah blah, correct,
incorrect). I am planning to read from A1 so, I don't want to enter a formula
there instead I want this cell be impacted by another cell. Something like a
report cell.

Please let me know if this is possible.
Thanks in advance