Overwrite a protected Formula

U

utaheel

I need to be able to protect the formula in a cell and at the same tim
overwrite that cell. I am an estimator and for instance my materia
price may be unit price x quanity or I may need to put in a lump su
value.

Thanks for the hel
 
D

Dave Peterson

I'd use 3 cells.

#1. The formula cell (recommended value?)
#2. The typing cell (Manual override)
#3. A formula that figures out which one to use.

Say you use A1, A2, and A3

then in A3, you could have:
=if(a2<>"",a2,a1)

(if a2 had something in it, use that. If not, use A1.)

And make all your subsequent formulas look at A3 (not A1 or A2).
 
Top