Newbie formula check

[MaryB]

I'm trying to write this formula but it errors out, not sure where the syntax is wrong.

IF IsNull([Project Name]) THEN [Target] = 0 END

[MaryB]

I'm trying to write this formula but it errors out, not sure where the syntax is wrong.

IF IsNull([Project Name]) THEN [Target] = 0 END

[GarthM]

Assuming you're trying to set the value of the 'Target' field to either 0 or 1 then:

IF IsNull([Project Name]) THEN 0 ELSE 1 ENDIF

[MaryB]

Do you have to have an "ELSE" part?

[Ned · Accepted solution]

Yes - the expression has to return a value.  If in the ELSE you don't want to change the value then that's easy, just return the original value:

IF IsNull([Project Name]) THEN 0 ELSE [Target] ENDIF