7 Replies Latest reply on Jun 22, 2016 10:26 AM by PeterDoern

    IF THEN function question for alphabetical location


      I am looking to do a calculation based on the first three letters alphabetically. I already have a field that shows the first three letters that I can reference. For example:


      If ABC-GEH, return row one

      If GEH-LAR, return row two

      if LAR-POR, return row three


      I assume this doesn't work, but just thinking out loud:

      If ( Location = "ABC" < "GEH" ; "Row One" ; If ( Location = "GEH" < "LAR" ; Row Two" ; etc....) )