# Excel question.

starlet 06:27 13 Jul 05
Locked

I am missing something in a formula I am trying to write if anyone can help please.
Lets say I have three teams of players and I want to show the “Winner”, and if so a “Draw” or “Blank” for the lowest after four games.
=IF(B8=\$B10, "Winner","",IF(\$B\$10=B8:D8,"DRAW","")) B8:C8:D8, is the total, B10 is the highest score, individually the two If statements work but together only the first works, can someone show me the way please.
Regards Starlet

VoG II 09:11 13 Jul 05

Sorry, I've read this 3 or 4 times and I don't quite understand the question. Try

=IF(B8=\$B10, "Winner",IF(\$B\$10=B8:D8,"DRAW",""))

starlet 11:04 13 Jul 05

Thanks VOG,your formula did not do what I want.
I'll try and write it a little clearer.

I am trying to built a nested formule to show three teams of players if one team out of the three has the highest score it shows "Winner" and the others show blank,that part I have done,what I want to show now is if two or more teams have the same score it shows "Draw" in the same cell as it showed "Winner".
This is just a test piece the final sheet will have sixteen players, this is for a visually impaired bowling team I am helping.
Regards Starlet

VoG II 11:21 13 Jul 05

=IF(AND(B8=\$B\$10,COUNTIF(\$B8:\$D8,B8)=1),"Winner",IF(AND(B8=\$B\$10,COUNTIF(\$B8:\$D8,B8)>1),"Draw",""))

starlet 11:35 13 Jul 05

Many thanks VOG, It works a treat your expertise in Excel is fantastic, I have a lot to learn yet.
Best regards Starlet

This thread is now locked and can not be replied to.

New Google phones UK release date | Pixel XL price, new features, specifications: Pixel X and…

1995-2015: How technology has changed the world in 20 years

This is the future of TV, VR and holograms

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…