malformed if statement

[lancegoh1]

hi can someone guide me as to what is wrong with my if statement?

.

Cheers,

Lance

[harikakummara · Accepted solution]

Hi Lance,

Remove second "IF" in your formula after "AND" ..

if IsNull(team2) AND Contains([Doc Cluster (pre-1p)],"Change of BO") then ....

Thanks,

Harika K

[Newbie_1]

I seem to get a similar eeror when i try this formula , Need help!

IF [A]="None" && [B] ="None"

THEN "No Change"

ELSE IF [A]="MO" && [B]="MO"

THEN "No Change: MO"

ELSEIF [A] != [B]

THEN "Change required"

ELSEIF [Inventory]>= "600" OR [ Inventory]<="-600"

THEN "Review Required"

ELSE "No Review Required"

ENDIF

Didn't want to create a new duplicate question as it is similar to this original question

[BenMoss]

@Newbie_1, your first elseif statement has a space.

Ben