Equating a Percentage to a Number

[Guest]

I am a new excel user. I am trying to set up an electronic grade book and I wanted to know is there is a formula I can use to tie a letter grade to a percentage.

Thank You

 

[Peo Sjoblom]

You are a bit vague, do you have number grades or letter grades?

=IF(A1="","",VLOOKUP(A1,{0,"F";0.6,"D";0.7,"C";0.8,"B";0.9,"A"},2))

that means 0-59% F, 60-69 D and so on, replace them with numbers 1-5 if
needed
or change the whole scale if needed



--

Regards,

Peo Sjoblom

I am a new excel user. I am trying to set up an electronic grade book and

I wanted to know is there is a formula I can use to tie a letter grade to a
percentage.