I'm hoping someone has the answer.
I Have a value within a cell to which I would like to check against a number of ranges and return a new value a shown below.
<tbody>
14 = 1
</tbody>
<tbody>
Less than 25 =
1
Between 25-75 =
2
Between 75-150 =
3
Between 150-250 =...