If you use Data | Validation to ensure that you only have A,B,C,D or F (& no
blanks), then perhaps this Array formula...

=AVERAGE(MOD(2530,CODE(A1:A5)-59))

HTH :)
--
Dana DeLouis
Win XP & Office 2003


"Will in SF" <Will in wrote in message
...
Hi.

I need a formula that averages grades with the following values...
A=4,B=3,C=2,D=1,F=0. I am entering the actual letter grades in the cell.