2 Replies Latest reply on Feb 9, 2012 10:22 AM by MarcMcCall

    Formula that returns a text result if field content ends with a specific suffix

    MarcMcCall

      Title

      Formula that returns a text result if field content ends with a specific suffix

      Post

      I'm trying to figure out a formula to generate one of 2 results.  I have a field named Dove Code. I have another field named: part type I want the calculation to say "OEM" if the last 2 letters of Dove Code are "MN" or "Compatible if the last 2 letters in Dove Code say anything else.  The part #'s will look like this  HEP1106MN or CAN20122MR or BRO20163GN.  The length of the part number will vary, but will always end with either "MN" "GN" or "MR".