Forum Discussion

lswobx's avatar
lswobx
Copper Contributor
Jun 11, 2021
Solved

Nested IF AND OR Functions

I am working on a fairly simple project but have hit a roadblock in my Excel knowledge. I want to track oil change and tire rotation for a fleet of vehicle.    I record mileage at last oil change, ...
Formulas and Functions
  • JMB17's avatar
    JMB17
    Jun 11, 2021

    lswobx

     

    You didn't really say anything about how your current data is laid out. But, if it were me, I would set up separate fields for the oil and tire service to try to make it easier to work with and filter.

     

    Attached is an example that I hope will be helpful. 

HansVogelaar's avatar
HansVogelaar
MVP
Jun 11, 2021

lswobx 

How about using a lookup table? See the attached version. You can change the text in the lookup table, of course.

Resources