I have a mark sheet of a set of marks of a group of learners. e.g.
Sean 34.2 %
I want excel to identify a range and convert it in a next column to a number
e.g. marks between 1 and 29.9 = must be converted in a new column as a 1
marks between 30 and 39.9 = must be converted in a new column as a 2
If you define somewhere in workbook your marks ranges not to hardcode them, like on this mockup
the formula will be