Using If then string to assign codes

[tpostlewate]

I promise I will only have 3 or 4 more questions today...

What I am using: 
IF [New age] = "" THEN "0" ELSEIF [New age] > "44" THEN "2" ELSE "1" ENDIF

In English this is what I am trying to accomplish- If the [New age] field is blank, I either want to move a "0" to the new field [formula age] or just move the blank. Whichever is easier. If [New age] is greater than 44, move a 2 to the new field, and finally, if it is less than 44 move a 1.

The problem is it codes a 1 for all of the blanks. I think I understand why it is doing that, I just don't know how to fix it. It is doing great on those 2 codes, but the 1s are giving me fits.

[Emil_Kos · Accepted solution]

Hi @tpostlewate,

Can you try this?

IF IsEmpty([New Age]) THEN "0" ELSEIF [New age] > "44" THEN "2" ELSE "1" ENDIF

I think this part might be problematic: [New age] = ""

[tpostlewate]

Brilliant! Worked perfectly! 🙂