View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vincent Vincent is offline
external usenet poster
 
Posts: 39
Default 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