1.

Solve : formulas in Excel?

Answer»

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

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

Thanks,

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

Krys


Discussion

No Comment Found

Related InterviewSolutions