Nel post news:09507D31-D366-4E65-B476-84A27A2CE020@microsoft.com
*elaine* ha scritto:

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

Till Excel 2003 there's a limit of 7 level of nested functions.
You can solve using a table and the VLOOKUP function.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy