Creating a new variable or column using nested 'IF' containing substr, or and then

2 followers
0
Avatar

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

Jayraj

2 comments

  • Avatar
    Alan Mark

    Hi Jayraj,

    IF((SUBSTR(#SHEET1!XXXX;14;1) = 'L'); 'DSA'; IF((SUBSTR(#SHEET1!XXXX;14;1) = 'l'); 'DSA'; 'TAR'))

    IF substring = L

    THEN DSA

    ELSE IF substring = l

    THEN DSA

    ELSE TAR

    Let me know if you have any further questions.

    0
Please sign in to leave a comment.