Overwrite a protected Formula

[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

 

[Frank Kabel]

Hi
you can't have both

 

[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).