Issue with If Statement

[henrywqral]

Hi everyone,

I am currently receiving the following error message on a custom formula: "Malformed If Statement".

The statement can be found below:

IF Contains([Status], "Complete") THEN "Complete"
ELSE IF Contains([Status],"Received") THEN "Received"
ELSE IF Contains([Status],"Hold") THEN "Received"
ELSE "Cancelled" ENDIF

It says Parse error at char(221). [Status] field is in V_String. If anyone can explain why this If statement is not functioning I would appreciate all input.

[DataNath · Accepted solution]

Hey @henrywqral, if you remove the spaces between your ELSE and IFs so they’re just ELSEIF, does that help?

[henrywqral]

I believe this fixed this issue I was having. Thank you!