Re: Is this possible

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Relevant Pages

  • Re: Is this possible
    ... meter reading is entered in it will carry over to the next day. ... now that that feeder would be taken out of service. ... The south feeder is reset every day so I do not need to ... We put in the reading on the south and then go to cell b2 and ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Compound IF statement
    ... Thank you so much for reading my plea and I apologize for being vague. ... If Col 1 has BA and if the same cell in Col 2 has DC, ... Then you say you want to "sum those entries". ... You would simply put the UDF name and whatever ...
    (microsoft.public.excel.programming)
  • Monitoring cells that have data changed
    ... I am creating a group of spreadsheets that will contain meter reading ... the first cell has been changed. ... user changes but I can monitor subsequent cells. ...
    (microsoft.public.excel.programming)
  • Re: Create "model" cell to make a table from
    ... If you scan to RTF, you have used some form of OCR (Optical Character ... Reading) software to convert the image to editable text. ... Word MVP web site http://word.mvps.org ... gridless table from a selected cell. ...
    (microsoft.public.word.tables)
  • Re: Create "model" cell to make a table from
    ... the type of media file you use when scanning in a B+W graphic is critical. ... This produced a great quality image that ... Reading) software to convert the image to editable text. ... gridless table from a selected cell. ...
    (microsoft.public.word.tables)