# 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

#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 E5to 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)MIKEhttp://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