Classifying values according to range

Question

I have a column with values ranging from 0 to 5.

I want to assign those numbers ranging from:

0 to 1 to class i,
1 to 2.5 to class ii
2.5 to 4.5 to class iii
and 4.5 and above to class iv

using Microsoft Excel.

How do I go about it?

Answer 1

I believe you can just build a nested IF.

Assuming your values start in cell A2:

=IF(A2<1,"class I",IF(A2<2.5,"class ii",IF(A2<4.5,"class iii","class iv")))