for all those interested.
I answered my own question with this website

http://www.wfu.edu/~matthews/plus_mi...l_example.html



"excelguy" wrote:

I want to use the "if" function to report letter grades when a number is
within a specified range. For example:

if(a1<=63, F, if(a1<=67, D, if(a1<=69 ...

I keep using the if function until I reach the last grade of A+ where a1<=100.

I was able to write the formula successfully typing in 9 or so if functions
but excel wouldn't allow to write in anymore! The above function is exactly
what I need but longer. Any suggestions.

I'm making this for my class and this formula would calulate all my
students' numerical averages into letter grades.