Help with IF THEN

New to Designer. My field name is [AG/UG] and contains these numeric values (3000, 3100, 7000, and 7100). Trying to write an IF THEN statement that would change the 3100 and 7100 to equal "AG" (just the letters) text string, and, to change the 3000 and 7000 to equal "UG". Your help is greatly appreciated!

Expression

Accepted answers

ChrisTX

You'll need to create a new field, because the data type will be text

IF [my field] IN (3100, 7100) THEN "AG"

ELSEIF [my field] IN (3000, 7000) THEN "UG"

ELSE "<unknown>"

ENDIF

Chris

All comments

Luke_C

Hi @J25607

Assuming your field is numeric you could do the below. If it's text then put quotes around the numbers.

IF [AG/UG] IN (3100,7100) then 'AG'
ElseIf [AG/UG] IN (3000,7000) then 'UG'
Else Null()
Endif

ChrisTX

You'll need to create a new field, because the data type will be text

IF [my field] IN (3100, 7100) THEN "AG"

ELSEIF [my field] IN (3000, 7000) THEN "UG"

ELSE "<unknown>"

ENDIF

Chris

J25607

Luke, tried your suggestion. Still get an error.

Chris, how/where would that new field be created?

Thanks!

Luke_C

Hi @J25607

You'll need to be more specific and include the error to get any meaningful help. My solution is the same as what @ChrisTX 's is. You'd do it by adding a new field in the formula tool - see attached.