Comparing and Finding greater of 3 numbers in excel 2002

[mlhurst]

I am trying to keep score of a fantasy league that I am in. I have three teams that accumulate scores. I would like to have a statement in a cell that compares and finds the greater number of three cells and then enters a person's name if they have the greatest score. I have set up an if...then statement, but the problem is, if the first statement in the list is true, it does not check to see if other statements are true and just assigns the name for the first condition that it finds to be true. Can anyone help me figure out how to make it check and compare all three numbers?

[duane]

it sounds like you want to use the rank function to find the highest
something like the following

this finds the max of b6:d6 and assigns a name based on result

=IF(RANK(B6,B6:D6)=1,"Tom",IF(RANK(C6,B6:D6)=1,"Bob","Harry"))

[mlhurst]

Thank you! It worked!