Malformed IF Statement error on a simple If formula

[Goran]

Hi everyone,

Really not sure what I'm doing wrong here.  I have the following IF statement: 

IF [RecordID] = 1 THEN ([Core Time]+[Work Out]) END

I keep getting that Malformed error message regardless how I wrap the 1 whether it ends with END or ENDIF.  

RecordID is a calculated field, so perhaps that's the issue?

Any help would be appreciated!

[afv2688 · Accepted solution]

Hello @Goran 

You are missing the else statement

IF [RecordID] = 1 THEN ([Core Time]+[Work Out]) ELSE <SOMETHING HERE> ENDIF

for example:

IF [RecordID] = 1 THEN ([Core Time]+[Work Out]) ELSE [Core Time] ENDIF

Regards

[mpennington · Accepted solution]

The syntax should be:

IF [RecordID] = 1 THEN ([Core Time]+[Work Out])  ELSE '' ENDIF

[Goran]

Thank you.  I didn't realize IF statements always needed to have an ELSE