Hi!

You'd be better off just using a number system instead of using a letter
system then converting to a number system.

But anyhow, try this formula entered as an array using the key combo of
CTRL,SHIFT,ENTER:

=AVERAGE(IF(A1:J1="A",4,IF(A1:J1="B",3,IF(A1:J1="C ",2,IF(A1:J1="D",1,IF(A1:J1="F",0))))))

Biff

"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.