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>