Hello,

I hope that someone would be able to help me on what I am trying to
achieve. What I am trying to have is a simple grading system that
converts a grade to a number so for example:

A = 5
B = 4
C = 3
D = 2
E = 1

-What I have tried: (Works for one value)
In cell B1 I inputted a function using an IF statement where by the
Logical Test is A1="A" then The_Value_True = 5.

So the function is =IF(A1="A",5).

So if in Cell A1 I typed A, then in Cell B1, I get the number 5.

What I would like to have is, if Cells A1:A6 have the data, A, B, C,
D, A, D, I would like the numbers 5, 4, 3, 2, 5, 2 appear in the cells
B1:B6.

Your help is much appreciated on this little task.

Thanks
SP