Hello,
Job Codes =
EX12.01
EX24.02
EX33.03
I need a nested statement that says:
IF Job Code begins with "EX" and and ends in "1", THEN result = "TIER 1"
IF Job Code begins with "EX" and and ends in "2", THEN result = "TIER 2"
IF Job Code begins with "EX" and and ends in "3", THEN result = "TIER 3"
Thank you!
Bookmarks