Hello,
I have some numbers in columns that I want to put them in bucket below. Please help create a formula based on below: Anything above 100 should show greater than 100, abything between 76-100 should show in 76-100 buckets, anything falls in between 51-75 should show in 51-75 bucket and number between 0-50 should show in 0-50 bucket
<tbody>
</tbody><colgroup><col><col></colgroup>
I have some numbers in columns that I want to put them in bucket below. Please help create a formula based on below: Anything above 100 should show greater than 100, abything between 76-100 should show in 76-100 buckets, anything falls in between 51-75 should show in 51-75 bucket and number between 0-50 should show in 0-50 bucket
Numbers | Buckets |
101 | >100 |
100 | 76-100 |
75 | 51-75 |
50 | 0-50 |
<tbody>
</tbody><colgroup><col><col></colgroup>