Hi Scott,

Why not use another cell to enter the reading?
And then your formula would be something like

=IF(A1="",YourOriginalFormula,A1)

--
Kind regards,

Niek Otten

"scott" wrote in message
...
I have a cell that has a formula entered into it. At certain times in the
month of operations this cell with the formual needs to be replaced with a
meter reading. I have the worksheet protected expcept for this cell so
people
can enter in the reading.ow is there another formual or way to tell when
this
formula has been replaced with the reading, maybe in the form of another
formula in another cell.
Thanks in adavance
Scott