G Guest Nov 7, 2003 #1 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
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
P Peo Sjoblom Nov 7, 2003 #2 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 Laura said: I am a new excel user. I am trying to set up an electronic grade book and Click to expand... I wanted to know is there is a formula I can use to tie a letter grade to a percentage.
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 Laura said: I am a new excel user. I am trying to set up an electronic grade book and Click to expand... I wanted to know is there is a formula I can use to tie a letter grade to a percentage.
