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!
Solved! Go to Solution.
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.
Oh my goodness, changing the 'else if' to 'elseif' worked! Thank you so much!
Happy to help @CherieACI! Don't forget to mark the solution.