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

Comments

2 comments

  • 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
    Comment actions Permalink
  • Jayraj

    Thank you Alan, it works

    0
    Comment actions Permalink

Please sign in to leave a comment.