change locked cell if

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
 
Back
Top