changing value in a cell

[Marty]

If a user enters a value say 12 in cell A1 and in cell B2 a formula =A1/4
is set up and the result would be 3. How would you go about it if in
some cases the user can change the value in B2 to whatever say 6. As soom
as the 6 was typed in B2 it would wipe out the formula. We would need the
ablity to maintain the orginal formula in B2 the next time A1 is changed.
Thanks and have a fun day.

 

[Arla M]

So do when you manually enter the "6" value, were you hoping to change the
original number in Cell A1?

 

[Marty]

The orginal value in A1 would have to remain the same.