Using a formula as a return value (THEN) in IF statement

[Vwest]

Hi All,

I am trying to use a formula using existing columns as the return value after THEN in an IF statement and am receiving the Unmatched error when reaching the 2nd Then statement shown in red below. I have the data type set to Double. Any suggestions on what may be causing the error and how it can be fixed?

IF [x] > 0 OR [z] = "Yes"

Then 0

Elseif (ABS ([x]) > (ABS([m-y]))

Then [m-y]

Else [x]

Endif

[Luke_C · Accepted solution]

Hi @Vwest 

I think you're missing a parenthesis at the very least. Try the below

IF [x] > 0 OR [z] = "Yes"

Then 0

Elseif (ABS ([x])) > (ABS([m-y]))

Then [m-y]

Else [x]

Endif