I'm trying to do some transformation with numbers in excel. First i have that table: 
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