Hello all,
Im trying to add another true_value onto this following formula:
=IF(OR(RIGHT(A2,5)={"396OL","400OL"}),"101OL",RIGHT(A2,5))
I have attached a sample workbook. On the left side is my current formula and on the right will be result I'd like to achieve.
My current formula will do the following
396OL will convert to 101OL
400OL will convert to 101OL
If false then keep the last 5 values from the original code.
But Id like to place in the following true_value:
If 413OL then convert to 103OL NOT 101OL
Bookmarks