2 Replies Latest reply on Jan 16, 2017 11:40 AM by Mauricio Contreras

    how to corrct the If functions with LEN?

    Mauricio Contreras

      Dear forum,

       

      I'm struggling with the IF function, my goal is to count 8 characters of that is the case make it = 1 if the count is greater that 8 give the right  digit...

       

      IF (LEN([Cell])=8 THEN '1' ELSE RIGHT([Cell],1) ELSE END

       

      my goal is to create a new column with the 1, 2, 3, and 4...

       

       

      Cell
      229669_1
      229669_1_2
      229669_1_3
      229669_1_4
      229669_2
      229669_2_2
      229669_2_3
      229669_2_4
      229669_1