Help on IF function

Something to bear in mind is that the comparison operators also apply to the alphabetical sort order of text, thus

= IFS(
    A1>"asdz", "AFTER 'asdz'",
    A1>"asd",  "AFTER 'asd'",
    TRUE,      "BEFORE OR EQUAL TO 'asd'"
  )

are valid as text comparisons.