Multi Conditional IF statement (malformed error)

CherieACI

I'm trying to write a multi conditional if statement but I'm getting the malformed if statement error. I have defined 2 columns in a previous formula to be either true or false. Now I want to compare these 2 columns and if both columns are true then I want this new column = true, if they are both false I want the result = true otherwise false. Here is my if statement: 

If [On Last Month Not on this Month] ="True" and [On this Month Not on Last Month] = "True" then "True"
else if [On Last Month Not on this Month] ="False" and [On this Month Not on Last Month]="False" then "True"
else "False" endif

The previous formula defining the 2 columns as True/False: 

What am I doing wrong? 

Thanks in advance!

Luke_C

Hi @CherieACI 

If you're using 'else if' you will need to put 'endif' twice at the end of your formula. You could also change the 'else if' to 'elseif' and it should work as is.