Re: Is this possible

Tech-Archive recommends: Speed Up your PC by fixing your registry

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 before>0, 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" <scott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:A914022A-4FE9-439D-85D7-F46882C18C3E@xxxxxxxxxxxxxxxx
> > >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 work*** 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
> >
> >
> >
.

Quantcast