Creating a new variable or column using nested 'IF' containing substr, or and then2 followers
I want to create a new column using 4 different columns with conditions. I tried using this below formula but doesn't work:
IF(SUBSTR(#Sheet1!XXXX;14;1) ='L' OR SUBSTR(#Sheet1!XXXXX;1;1) ='I') THEN 'DSA' ELSE 'TAR'
Can anyone help me out with this one