Hi.

I really hope i can explain myself. Sorry if i can´t.

In 1 column (A) i have the total of hours a tractor has worked. The results
are daily and may vary. How can i insert a "OIL CHANGE" (column B) saying
that a oil change is always needed after 250 hours?

I managed to do it for the first oil change with, per example:
B#=IF(A#-A$1>250;"OIL CHANGE";0)

This only works for the first oil change because of A$1. I could easily
change the formula manually after 250 hours, however this worksheet is for
someone who only knows how to insert values.

Thanks for everything

In B1 enter:
=IF(SUM(A$1:A1)>=250,"Oil Change","")
and copy down

HTH
Jim May


"Vincent" wrote:

> Hi.
>
> I really hope i can explain myself. Sorry if i can´t.
>
> In 1 column (A) i have the total of hours a tractor has worked. The results
> are daily and may vary. How can i insert a "OIL CHANGE" (column B) saying
> that a oil change is always needed after 250 hours?
>
> I managed to do it for the first oil change with, per example:
> B#=IF(A#-A$1>250;"OIL CHANGE";0)
>
> This only works for the first oil change because of A$1. I could easily
> change the formula manually after 250 hours, however this worksheet is for
> someone who only knows how to insert values.
>
> Thanks for everything

Hi again

Sorry Jim May, my problem continues.

Current situation: My Goal:

A B A
B
... ...

249 249
250 Oil change 250 Oil
change
251 Oil change 251
.... Oil change ....
499
500
Oil change



Big Thanks



"Jim May" escreveu:

>
> In B1 enter:
> =IF(SUM(A$1:A1)>=250,"Oil Change","")
> and copy down
>
> HTH
> Jim May
>
>
> "Vincent" wrote:
>
> > Hi.
> >
> > I really hope i can explain myself. Sorry if i can´t.
> >
> > In 1 column (A) i have the total of hours a tractor has worked. The results
> > are daily and may vary. How can i insert a "OIL CHANGE" (column B) saying
> > that a oil change is always needed after 250 hours?
> >
> > I managed to do it for the first oil change with, per example:
> > B#=IF(A#-A$1>250;"OIL CHANGE";0)
> >
> > This only works for the first oil change because of A$1. I could easily
> > change the formula manually after 250 hours, however this worksheet is for
> > someone who only knows how to insert values.
> >
> > Thanks for everything