IF formula help

  • Thread starter Thread starter Bob Risner
  • Start date Start date
B

Bob Risner

Help, I'm trying to setup a tournament worksheet that will automatically add
points for a certain place in the standings. Is there a limit to the number
if "IF" statements in a formula?

Here is what I have now:

=IF(K2=1,"50",IF(K2=2,"49",IF(K2=3,"48",IF(K2=4,"47",IF(K2=5,"46",IF(K2=6,"4
5",IF(K2=7,"44",IF(K2=8,"43"))))))))+G2

But if I add another IF say K2=9 it over writes the K2=8 formula! Is there a
limit? I want to add 50 places so that if cell K2=50 the points would be 1.
I want to start at IF(K2=1,"50") and go to IF(K2=50,"1")

Thanks in advance,

Bob....
 
Bob,

The maximum number of nested IFs is 30.
Maybe you could simplify your formula by cretaing a table
in a different place in the workbook and using VLOOKUP
instead of IF.

Regards,
Felipe
 
The maximum number of nested IFs is 30

The maximum number of nested IFs is 7

The whole thing could be done with a simple:-

=51-K2
 
From the data you have supplied, your formula is the same as =51-K2

If you really wanted to use VLOOKUP (But don't need to do for this), then:-

put 1 to 50 in cells A1:A50, and 50 to 1 in cells B1:B50.

Then in any other cell, do =VLOOKUP(K2,A1:B50,2,0)
 
Back
Top