Nested If statements using IFS()

[iosiflupis]

I am working on a table with arrivals and departures for airlines at my airport. I have two columns, a time column (HH:MM) and a delay column. I want to annotate in a third column whether the airline departed early, late, on time, or was canceled.

I can get the early, late and on-time ifs statement to work. But the canceled portion is giving me fits.

So far I have: =IFS([@[Dep Delay (minutes)]]<0,"Early",[@[Dep Delay (minutes)]]=0,"On-Time",[@[Dep Delay (minutes)]]>0,"Late"), which works beautifully.
and then I have =IF([@[Actual Dep Time]]+[@[Dep Delay (minutes)]]=0,"Canceled",) which also works beautifully,
But when I try to combine the two it does not work. What have I done wrong?

 

[Fluff]

Maybe

=IFS([@[Dep Delay (minutes)]]<0,"Early",[@[Dep Delay (minutes)]]=0,"On-Time",[@[Dep Delay (minutes)]]>0,"Late",[@[Actual Dep Time]]+[@[Dep Delay (minutes)]]=0,"Canceled")

or just

=IFS([@[Dep Delay (minutes)]]<0,"Early",[@[Dep Delay (minutes)]]=0,"On-Time",[@[Dep Delay (minutes)]]>0,"Late",True,"Canceled")

 

[iosiflupis]

@Fluff, Thank you. Actually, I went back into the Power Query and used a conditional column with the four arguments, I just had to arrange them in the proper order so that the canceled statement was before the on-time statement.

 

[Fluff]

Glad you sorted it & thanks for the feedback.