Heya, im barely great at Excel, and im struggling to develop a formula.
I have one sheet that has a Numeric result in ONE cell - S2
The number is ANY value, with ANY decimal point value
I need to put a formula in another cell that defines a grade 1-5 based on its value S2's value.
*Each Peak / Mean score between the values below, get assigned the corresponding grade on the far left*
Im sure its an =IF(AND( kind of formula, but cannot get it to work.
Im looking for a single formula that will check all 5 grades parameters, and return the single grade number.
<tbody>
</tbody>
I have one sheet that has a Numeric result in ONE cell - S2
The number is ANY value, with ANY decimal point value
I need to put a formula in another cell that defines a grade 1-5 based on its value S2's value.
*Each Peak / Mean score between the values below, get assigned the corresponding grade on the far left*
Im sure its an =IF(AND( kind of formula, but cannot get it to work.
Im looking for a single formula that will check all 5 grades parameters, and return the single grade number.
Grade | Peak | Mean |
1 | 0 | 0 |
2 | 2.1 | 0.51 |
3 | 15.1 | 0.91 |
4 | 30.1 | 1.71 |
5 | 50 | 3 |
<tbody>
</tbody>