Niek
I forgot to mention that b1-b2 is chemical used

"scott" wrote:

Niek

I wanted to try and make this simple, maybe you have a suggestion. I
appreciate your suggestion but this is what happens. We have two different
chemical feeders. When we switch feeders on what ever day it is we need to
eneter in the meter readings. My ss is set up for entire month. So when the
meter reading is entered in it will carry over to the next day. Now on the
days that the feeder is changed I do not want the one reading to carry over,
now that that feeder would be taken out of service. I am looking for
something easy because of the number of people that is invloved. I would like
to just enter the reading (putting the feeder in or out of service) and not
have much confusion as to delete the old reading or not. Below is how I have
it now, remeber that the north feeder gets its reading from the day before if
it is in service. The south feeder is reset every day so I do not need to
carry that reading over. They both feed the same chemical but one is newer
and is reset every night.

North Feeder
cell b1-this is is blank to put the end of the days reading in
cell b2=if(b1, the day before0, b1,0)

South Feeder
c1-just eneter in reading because it is reset everyday.
The problem occurs when say we are using south feeder and then switch to
north feeder. We put in the reading on the south and then go to cell b2 and
eneter in the start up reading. Vice versa when we switch from north to
south. Hope you can get this.

Scott

"Niek Otten" wrote:

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