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

Follow

Jayraj

• October 01, 2018 14:11

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

0

• 

  Alan

  • October 01, 2018 14:24

  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

  • October 02, 2018 13:55
  • Edited

  Thank you Alan, it works

  0

  Comment actions Permalink

Please sign in to leave a comment.