IF/ELSE

[razzy]

Can someone help to debug this formula please it is giving me the error.

Error: Formula (21): Parse Error at char(52): Malformed If Statement (Expression #2)

IF(0>=[Age at DOV]<= 10)
THEN " 0-10"
ELSE Null()

// Data type of [Age at DOV] is int. I am trying to create a new column defined by set of categories using IF , ELSEIF conditions but the first parse is giving me an error . I am using the formula tool to create the conditions.

Thanks

[jdunkerley79 · Accepted solution]

You need to specify the range as two conditions.

IF ([Age at DOV] >=0 AND [Age at DOV] <= 10)
THEN " 0-10"
ELSE Null()
ENDIF

You also need to close the IF clause with an ENDIF