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

fernman Wrote:


Hi fernman

Try creating a lookup table, or using the IF function

If this does not answer your question, try giving some example data and
you may get a better response


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401868

especially when some of us can see only this

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

--
paul
remove nospam for email addy!



"Paul Sheppard" wrote:


fernman Wrote:


Hi fernman

Try creating a lookup table, or using the IF function

If this does not answer your question, try giving some example data and
you may get a better response


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401868

=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


--
NlCO
------------------------------------------------------------------------
NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123
View this thread: http://www.excelforum.com/showthread...hreadid=401868