Additional forumlas on a sports bracket

[stevestaser]

As you can see Im working on a sports bracket,if you look at the highlighted H22 box you see the formula that I use as this bracket is for a single elimination tournament........the B,C,D columns all represent games....B is Game 1,C is Game 2 and If necessary D is Game 3....... what I would like to see,if its possible.....to manipulate the formula a bit to where is a team only advances if it wins 2 of the 3 games....Like with Long Beach State & Louisville...and nothing changes if they only win the first like in the Florida State line......Thx for any suggestions


Image2.jpg

[Estevaoba]

Try this:

=IF(OR(B21="",B23=""),"Winner Series 6",IF(AND(B21>B23,C21>C23),A21,IF(AND(B23>B21,C23>C21),A23,"Winner Series 6")))

[stevestaser]

thx.....Didnt work though

[Estevaoba]

I don't get it. It does work here.

[stevestaser]

Perfect... now it worked great...its now setup to if both teams win a game it stays winner of series #..thx for the help on that.....now I have tried to add a d columns into your forumla to get the winner of game 3 to advance..... =IF(OR(B21="",B23=""),"Winner Series 6",IF(AND(B21>B23,C21>C23,D21>D23),A21,IF(AND(B23>B21,C23>C21,D23>D21),A23,"Winner Series 6"))) hoping it would show the Team but still shows Winner Series 6.... Im sure I need to add something else to it but not sure what.....Thanks again....finally getting close to what I was wanting out of this

Steve

[Estevaoba]

Glad it worked, Steve!
For the third win in a row, your addition looks perfect!

[stevestaser]

It still has Winner Series 6 instead of switching to Louisville...any suggestions....thx

Image2.jpg

[Estevaoba]

The formula looks ok, Steve.
It'll take three wins to switch to Louisville, but they lost the second game.

[Estevaoba]

OK, I get it.
You want them to advance with either 2 out of the three games, right?
The formula gets bigger, but it can be done.

Try this.

=IF(OR(B21="",B23=""),"Winner Series 6",IF(OR(AND(B21>B23,C21>C23),AND(C21>C23,D21>D23),AND(B21>B23,D21>D23)),A21,IF(OR(AND(B21<B23,C21<C23),AND(C21<C23,D21<D23),AND(B21<B23,D21<D23)),A23,"Winner Series 6")))

[stevestaser]

Thank you,thank you,thank you...................works like a charm........really appreciate your help