AnsweredAssumed Answered

IF THEN function question for alphabetical location

Question asked by talkersw on Jun 22, 2016
Latest reply on Jun 22, 2016 by PeterDoern

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....) )

Outcomes