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.