Select winner of tie once 4 games are won

**pajc72** · 09-17-2011, 09:41 AM

Hi,

I have a playoff bracket where the following formula is used (in cell F16) to select the winner

=IF(AND(E16<>"",E17<>"",E16<>E17),IF(E16>E17,C16,C17),"")

Where E16 is home score, E17 is away score, C16 is home team, C17 is away team

This works so that whichever team has the greater score pulls through to F16, However I cant amend the formula to work so that it only pulls through the winner once they have won 4 games (playoff is best of seven).

Any ideas greatly appreciated

Thanks
Pete

**MarvinP** · 09-17-2011, 10:35 AM

Hi pajc72,

I do tiebreakers in golf. The rule is: if scores are tied after 18 holes then use the last 9 holes scores. If they tie then use last 6, then 3 then 1. I do the calculation by using decimals. If a player shot a 80 for 18 holes and a 42 on the back, I save this as 80.042.

In your case you could add one seventh to each playoff game win. Then instead of looking at their scores look at their scores/wins rounded. The team that got to 4/7 first would round up and be the winner.

hope that helps.

**pajc72** · 09-18-2011, 05:23 AM

Thanks for the reply, it makes sense in theory but putting that into a working formula is beyond me. I was hoping there was an addition to my existing formula that would do the trick?

**MarvinP** · 09-18-2011, 08:42 AM

Hi pajc72,

Attach a sample file with your playoff results and I'll show you how I'd do it.

To attach a sample, click on "Go Advanced" and then on the Paper Clip Icon above the advanced message area.

**pajc72** · 09-22-2011, 07:04 AM

Hi,

ive attached a spreadsheet 'playoff' and highlighted the cells where I need the help

I only want the name of the winning team to appear in cell F14 if they have won 4 games, as the ties are best of 7

thanks for the help