Malformed IF statement

Question

Hi

I am struggling with seeing the problem with this IF statement (used within a formula tool to create a new column).

IF Contains([SER Description],'Elderly' AND [Placement term]='Long') Then 'Residential - EMI Long Term' ELSE 'Residential - EMI Short Term ELSE ' ' ENDIF

The formula output is a V_WString type fields and both fields within [ ] are V_WString type fields.

Probably very simple - thanks in advance.

adm510 · Accepted Answer

Looks like you didn't close your contains function, try this:

IF Contains([SER Description],'Elderly') AND [Placement term]='Long' Then 'Residential - EMI Long Term' ELSE 'Residential - EMI Short Term' ENDIF

MarqueeCrew · Accepted Answer

IF

Contains([SER Description],'Elderly')

AND [Placement term]='Long'

Then 'Residential - EMI Long Term'

ELSE 'Residential - EMI Short Term'

ENDIF

if c then T else F endif

if c then T elseif c2 then T else F endif

some potential help

cheers

mark