IF Statement

[student123456]

Hello,

When I use the formula:

IF Length([pcd7])=7 THEN Left([pcd7], 5) ELSEIF ([pcd7])=6 THEN Left([pcd7], 4) ELSEIF ([pcd7])=5 THEN Left([pcd7], 3) ELSE [pcd7] ENDIF

I receive the error message "Parse Error at char (0): Invalid type in operator =="

My data type match up, as they're both string. It works fine as a single if statement. 

Can someone please advise where I am going wrong? 

Thank you!

[kelsey_kincaid · Accepted solution]

Hi @student123456 ,

Try updating your formula to this:

IF Length([pcd7])=7 THEN Left([pcd7], 5) ELSEIF Length([pcd7])=6 THEN Left([pcd7], 4) ELSEIF Length([pcd7])=5 THEN Left([pcd7], 3) ELSE [pcd7] ENDIF

[student123456]

Perfect! Thank you.