CORRECT AN EXCEL FUNCTION

Thomas,

That's great you found the solution yourself. Nested IF works fine.

As the comment. As always in Excel you may achieve the result by several ways. The only minus of your formula is maintainability. If one day you decide to change "Nul" on "Extremely Low" or, as in UK, grades will be changed from alphabetical A-G on numerical 1-9, you have to change all your formulas.

Better to keep the list with scores somewhere in Excel sheet and connect all your formulas to this list. If any changes you correct only the list, in one place, not all formulas.

To S8 and other cells you may define data validation based on this list like this

assuming your list is in A2:A6 (and related scores are in B2:B6). Could at any place in your workbook.

To calculate related scores in X8, etc, the formula could be like

=IFERROR(INDEX($B$2:$B$6,MATCH(S8,$A$2:$A$6,0)),0)

MATCH finds the position of the S8 in the list and INDEX returns related score.

Please see attached file.