formulas in Excel

[krysd]

I need to be able to relate the number of points based on finishing position.  For instance:

=if (a2=1,"10", if (a2=2,"9")) etc.

The problem is that I can only nest up to seven IF functions in Excel, and I need to do 11.  Any ideas for a NEWBIE???

I assume I can do it in a macro, but I don't know how.

Krys

[Peccavi]

Use lookup option instead.
=LOOKUP(A2,{0,60,63,67,70,73,77,80,83,87,90,93,97},{"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"})

[krysd]

Thanks,

I'll give it a try, a really appreciate the help.

Krys