4 Replies Latest reply: Oct 29, 2015 8:57 AM by Paolo Ferri RSS

    Create a new column and populate it with recoded variables

      Hi All,
      Here is my question:


      I have uploaded an excel file where there is a column with a list of email addresses and a column called ''answers''.
      In this column there are numerical values from 1 to 100.
      Now, I know that those who answered giving a value equal or greater to 54 gave the correct answer, while the others answered wrong


      What I want to do is to create a new column, called ''answers recoded'' where I simply put CORRECT when the person answered =>54 and WRONG for all the other values.


      Please kindly let me know if you have any ideas. Since I am a very beginner, please also tell me if I have to write the ''If-else'' conditions in the script or somewhere else.