You could try this:

=LOOKUP(D3,{"A","B","B+","C","C+","D","D+","F";4,3 ,3.5,2,2.5,1,1.5,0})

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"elaine" wrote in message
...
I have the following function that I am using to replace letter grades with
grade points. Excel will not allow me to enter more than seven nested
functions. Is there another way?
=IF(D3="a","4",IF(D3="b+","3.5",
IF(D3="b","3",IF(D3="c+","2.5",IF(D3="C","2",IF(D3 ="D+","1.5",IF(D3="D","1",IF(D3="F","0"))))))))