change locked cell if
 

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$1250;"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

change locked cell if
 

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$1250;"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

change locked cell if
 

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$1250;"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