D
Dajani
Please help!! I want to use the precentage in one colum to display a letter grade in another colum.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
Didn't you ask this 35 minutes ago?
--
Don Guillett
SalesAid Software
[email protected]
--
Don Guillett
SalesAid Software
[email protected]
letter grade in another colum.Dajani said:Please help!! I want to use the precentage in one colum to display a
P
Peo Sjoblom
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
=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
letter grade in another colum.Dajani said:Please help!! I want to use the precentage in one colum to display a
J
Jason Morin
One way:
=LOOKUP(A1*100,{0,60,70,80,90},{"F","D","C","B","A"})
HTH
Jason
Atlanta, GA
=LOOKUP(A1*100,{0,60,70,80,90},{"F","D","C","B","A"})
HTH
Jason
Atlanta, GA
to display a letter grade in another colum.-----Original Message-----
Please help!! I want to use the precentage in one colum