Cell value based on numeric increments

I have built an app that records vehicle maintanance for our fleet. mileage is put in with every gas/repair expense recorded. I’ve been trying to figure out two things…
First… What expression/action can I use if I wanted it to let me know when its time to change oil in 7500 mile increments? Every 7500 miles I would like it to change the status of another column so I know its time…

Second… How can I subtract the current mileage that is being put in from the previous mileage put in from the last automobile expense so I can calculate the miles driven?

Thanks in advance for the great job this community does… I pretty much live on this place anytime i have questions…

Chris

0 2 415
2 REPLIES 2
Top Labels in this Space