I am looking for a formula that will return the lowest value in a range, expressed as a letter.

The relative values of these letters are:

F=0

P=1

M=2

D=3

For example,

If in cells A1:A4 we entered the values F, P, M & D in A5 the result would be F (as it is the lowest value in the A1:A4 range).

I have included an example worksheet with fictional data and the intended result in the Final Score column.

Thanks in anticipation.

The relative values of these letters are:

F=0

P=1

M=2

D=3

For example,

If in cells A1:A4 we entered the values F, P, M & D in A5 the result would be F (as it is the lowest value in the A1:A4 range).

I have included an example worksheet with fictional data and the intended result in the Final Score column.

Thanks in anticipation.

## Comment