Cells with Formulas

  • Thread starter Thread starter jr
  • Start date Start date
J

jr

I think data validation is your solution but I'm having
trouble understanding what you DO want in A3.
One convention that I use is to use specific cell
backgrounds. One for formulas not to be overwritten and
another for cells that are meant for data entry.
If you can provide more info on your problem it would be
easier to suggest criteria for data validation.
 
A1= sub-total 1
A2= sub-total 2
A3=total; that is, sum(A1,A2)
....but in case I want to manually enter A3 (i.e. because
there is another additional cost for some reason), I want
the user to have that option.
However, if the user presses delete on A3, or starts
typing something but then backspaces and presses return
but then does not enter any new data (perhaps because they
realize that they just want to use the formula), rather
than have the formula deleted and being left with a
completely blank cell, i woud like the formula to
recaculate and have that calculated value appear in A3.

I hope that makes things clearer...any suggestions?
 
Back
Top