mercredi 4 novembre 2020

How do I use the "IF statement" to select numbers from a range?

I have a set of measurements ranging from 1 to 30. Any number between 1 and 10 is "Good", any number between 11 and 24 is "Mild" while any number from 25 to 30 is "Bad". I hope to use the IF statement to do this classification but I have am yet to get it right. I have tried the following:

=IF((1<=A2<=10),"Good",IF((11<=A2<=24),"Mild",IF(A2>=25,"Bad")))

I would appreciate your kind suggestions on the most effective way to get this done.

Aucun commentaire:

Enregistrer un commentaire