Formula that returns a text result if field content ends with a specific suffix
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".