4 Replies Latest reply on Nov 13, 2018 1:58 PM by NAYANA MADHEKAR

    Add Percentages

    NAYANA MADHEKAR

      Hi,

       

      Need urgent help on a easy problem, i guess.

      this is a dummy data set,

      I have stores and a few questions on them.

      If it the answer for the first question "Is it Big" is YES then it should grade it 8%. and for the second question "Is it Yellow" it should give it 10%. Later I need to add these two Percentages for Compliance Score. which should be 18% if both conditions are true.

       

      But the percentages are in string, how do I convert them into number?

       

      Attached is the workbook.

       

       

       

      1.PNG