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>
</tbody>
<tbody>
</tbody>
Which fuction should I be using within my formula
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.
14 = 1 |
<tbody>
</tbody>
Less than 25 = | 1 |
Between 25-75 = | 2 |
Between 75-150 = | 3 |
Between 150-250 = | 4 |
Above 250 = | 5 |
<tbody>
</tbody>
Which fuction should I be using within my formula