Thanks for the replies. I don't know how to create a event macro. Could you
walk me through it. Where do I find the button for event macro? In which tool
bar is it in?

Thanks

"Gary''s Student" wrote:

Yes it is possible.

You would create a event macro that would monitor the formula in A2 and,
depending upon the result, change the contents of A1.
--
Gary''s Student - gsnu200851


"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