Malformed IF Statement error on a simple If formula

Question

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 Answer

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 Answer

The syntax should be:

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