|Subject:||change locked cell if|
|Date:||Wed, 22 Aug 2007|
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:
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