Case ( UntilNextChange ≤ 3000 ; "Good" ; UntilNextChange ≥ 3001 ; "Service Soon" ; UntilNextChange > 4501 ; "Schedule for Service" )

The above is the function I created - it is to alert a tech when one of our support vehicles needs to be serviced. Problem is I need to make the second result calculate using a span of miles - 3001-4500. What is happening is when the miles are over 4501 - the text result still says Service Soon instead of Schedule for Service because the result holds true seeing the number in UntilNextChange is greater than or equal to 3001.

How do I calculate a result using only a span of 3001 - 4500 and get Service Soon so that if the result is greater than or equal to 4501, I will get a reault of Schedule for Service.

With vs. 7 and 8, Case() short-circuits, meaning it quits evaluating when it hits the first true. So, if I understand you correctly, this would work:

Case (

UntilNextChange ≤ 3000 ; "Good" ;

UntilNextChange ≤ 4500 ; "Service Soon" ;

"Schedule for Service"

)

Try to read the associated thread to this message:

http://www.nabble.com/Case-vs.-If-tf1350857.html#a3622429

--sd

Thank you, that works perfect!