Excel issue - maint. tracker

Question

Greetings, all.&nbsp;&nbsp;I've been tasked with creating a live service interval tracking formula for our preventative maintenance. This maintenance is tracked by mileage on the vehicle. We would like to know when the vehicle has been properly serviced within its parameters.&nbsp;For example -Current Mileage - 230,000Serviced Mileage - 234,000This would be serviced within good standing because it is within the 4,500-5,500-mile buffer (from last service).&nbsp;&nbsp;Currently, I have created this formula -=IF((C8-C7&gt;4500-5500),"GOOD","BAD")&nbsp;I know there is a better way to develop with conditional formulas. Can you walk me through this? I would greatly appreciate any help!

hansvogelaar · Answer

Aspen_Robert&nbsp;
That should be
&nbsp;
=IF(AND(C8-C7&gt;=4500,C8-C7&lt;=5500),"GOOD","BAD")

aspen_robert · Answer

Thank you, Hans!Is there a way to conditionally format to make the cell change to green or red?

aspen_robert · Answer

Another question - Is there a way to create the spreadsheet to have the built in formulas where the service is sporadic like this?

Or will the formula need to be updated after each service?

hansvogelaar · Answer

Aspen_Robert&nbsp;
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
&nbsp;

patrick2788 · Answer

Yes. It's do-able. Would just need to know your logic for how many blank rows should go between entries. Is it a fixed amount or does it changed based on a criteria?

Forum Discussion

Excel issue - maint. tracker

Share

Resources