HOW DO I CREATE A TOOL FOR CONVERTING PERCENT INTO LETTER GRADES?

P

Paul Sheppard

Hi fernman

Try creating a lookup table, or using the IF function

If this does not answer your question, try giving some example data an
you may get a better respons
 
P

paul

especially when some of us can see only this

Subject: Re: HOW do i create a tol for convert.......
 
N

NlCO

=IF(A1="","N/A",IF(A1<0.2,"E",IF(A1<0.4,"D",IF(A1<0.6,"C",IF(A1<0.8,"B",IF(A1<1,"A","ERROR"))))))

You can change the percentages, the letters or nest up to 2 more IF
formulas.

Saludos

NlCO
 
Top