Nested If Statements

Microsoft Office excel 2007 home & stude...
July 18, 2010 at 14:58:36
Specs: Windows XP
We play a board game called acquire (highly recommend it). We used to play tournaments with three players whose scores and rankings we kept on an excel worksheet. I used the following formula to compute the rankings: =IF(B5>C5,IF(B5>D5,1,2),IF(B5>D5,2,3)). The problem is we now have 4 players. I used the following formula, but am getting errors in some of the sceneros: =IF(B5>C5,IF(B5>D5,IF(B5>E5,1,IF(B5>D5,IF(B5>E5,2,IF(B5>E5,3,4)))))). Note it is not possible to have a tie, as we have tiebreakers in place.

Help me please


See More: Nested If Statements

Report •

#1
July 18, 2010 at 18:12:42
You might want to look at the =RANK() function.

If you have totals in B5, C5, D5 and E5
to get a ranking of the four scores you would need to enter:

For cell B5: =RANK(B5,B5:E5)
For cell C5: =RANK(C5,B5:E5)
For cell D5: =RANK(D5,B5:E5)
For cell E5: =RANK(E5,B5:E5)

MIKE

http://www.skeptic.com/


Report •

#2
July 18, 2010 at 19:04:16
Awsome - worked out well, and will solve the problem if we add more players! I used to think I was pretty good at excel - guess I need to keep reading - Thanks again!!!

Report •

#3
July 18, 2010 at 19:37:01
Glad I could help.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question