This content has been marked as final. Show 3 replies
I am trying to create an IF statement to classify different field values into normalized ranges. I want to make it so if FIELD starts with B it is categorized as 1 in NewField.
I have created the statement below but it is not working as desired. Any help would be appreciated.
If([FIELD] LIKE 'B%','1',
If([FIELD] LIKE 'Y%','2',
If([FIELD] LIKE 'P%','3',
If([FIELD] LIKE 'F%','4',)))) AS NewField