AnsweredAssumed Answered

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

Question asked by MarcMcCall on Feb 8, 2012
Latest reply on Feb 9, 2012 by 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".

Outcomes