change locked cell if

Giganews Newsgroups
Subject: change locked cell if
Posted by:  Vincent
Date: Wed, 22 Aug 2007

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

Replies