+ Reply to Thread
Results 1 to 1 of 1

Formula needs work

  1. #1
    Registered User
    Join Date
    04-15-2005
    Posts
    1

    Unhappy Formula needs work

    I have a spreadsheet that keeps track of generator hours so that we know when to change the oil, etc. The hours are typed in every day (day values are stored also) and the formula subtracts the hours from the day prior, then adds this number to another field for a total amount of hours. Here's where the problem comes in. There is a cell that tells what PM (Preventative Maintenance) is due, such as 300 hr, 500 hr, or 1500 hr. When the generator hours exceed the numbers in the formula, the PM due cell still remains. Is there some way to reset this cell without changing the generator start hours again?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1