Logic help

SahilArora3139

Hi team

i want to create a logic using formula tool with following details:

destination      Travel                     Class

Domestic.        All flights/train.     Base class

international   <.  8 hours              Base class
                        >= 10 hours.           1st class

please confirm if i am using correct logic to get the desired outcome

if travel < 8 then ‘base class’ else ‘1st class’

endif

but i am getting error in this.

please help me to get the logic sorted.

I want to highlight the exceptions where these parameters are not met

For example: like if international destination where time is taken less than 8 hours but is using 1st class then this is the exception as class should be base in this case.

Qiu

@SahilArora3139 
Interesting. Our company is also using the criteria of 8 hours for international flight.

First, I think we should see if it is domestic or international travel then for international flight, we can judget by travel time.

There is an argument for flight time between 8 and 10 hours, which class it should be?
I assume belowl

1128-SahilArora3139.yxmd