Error when creating a CUSTOM COLUMN

[anabianco09]

Hi, I am trying to create the following column:

and it shows up an error message that the name IF wasn't recognized. How to Solve?

[SumitChandra · Accepted solution]

Please refer the screenshot and modify your formula, it will works👍. Kindly mark my post as solution, Appreciate your Kudos .

if [Condition1] = "Value1" and [Condition2] = "Value2" then "Result1"
else "Result2"

 

[anabianco09]

It worked! Thanks @SumitChandra 

[DOLEARY85]

Hi,

try a lower case if

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍