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

[fernman]

[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 and you may get a better response

[paul]

especially when some of us can see only this

Subject: Re: 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
>
>

[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