mardi 20 février 2018

Convert number to string in Excel

I'm trying to do some transformation with numbers in excel. First i have that table: Excel Numbers

And as you can see, i have Random Digits, which is generated by using RANDBETWEEN. Now i want the Column Type, to be automatically Generated. So for example if Random Digits is:

  • From 1 - 35 = Good
  • 36 - 80 = Fair
  • 81 - 100 = Poor

I was already trying with IF function, but with if function i'm able to generate only 2 values and not 3.

Thank you for answers.

Aucun commentaire:

Enregistrer un commentaire