Please help!! I want to use the precentage in one colum to display a letter grade in another colum.
D Dajani Jan 6, 2004 #1 Please help!! I want to use the precentage in one colum to display a letter grade in another colum.
D Don Guillett Jan 6, 2004 #2 Didn't you ask this 35 minutes ago? -- Don Guillett SalesAid Software (e-mail address removed) Dajani said: Please help!! I want to use the precentage in one colum to display a Click to expand... letter grade in another colum.
Didn't you ask this 35 minutes ago? -- Don Guillett SalesAid Software (e-mail address removed) Dajani said: Please help!! I want to use the precentage in one colum to display a Click to expand... letter grade in another colum.
P Peo Sjoblom Jan 6, 2004 #3 Here's an example =IF(A1="","",VLOOKUP(A1,{0,"F";0.6,"D";0.7,"C";0.8,"B";0.9,"A"},2)) change the grades/percentages to fit -- Regards, Peo Sjoblom Dajani said: Please help!! I want to use the precentage in one colum to display a Click to expand... letter grade in another colum.
Here's an example =IF(A1="","",VLOOKUP(A1,{0,"F";0.6,"D";0.7,"C";0.8,"B";0.9,"A"},2)) change the grades/percentages to fit -- Regards, Peo Sjoblom Dajani said: Please help!! I want to use the precentage in one colum to display a Click to expand... letter grade in another colum.
J Jason Morin Jan 6, 2004 #4 One way: =LOOKUP(A1*100,{0,60,70,80,90},{"F","D","C","B","A"}) HTH Jason Atlanta, GA -----Original Message----- Please help!! I want to use the precentage in one colum Click to expand... to display a letter grade in another colum.
One way: =LOOKUP(A1*100,{0,60,70,80,90},{"F","D","C","B","A"}) HTH Jason Atlanta, GA -----Original Message----- Please help!! I want to use the precentage in one colum Click to expand... to display a letter grade in another colum.
