Win, Lose, Tie Calculation

[misticjeff]

Got a fairly simple task to perform but cannot for the life of me get it working completely. Need some help.

My issue is a "Tie". Above is the formula i'm using which works great for a Win or Loss but when a Tie occurs as is shown on the last score I'm not sure what to add to the formula to make it show.

Thanks in advance for any assistance.

Jeff

 

[T. Valko]

Got a fairly simple task to perform but cannot for the life of me get it working completely. Need some help.

My issue is a "Tie". Above is the formula i'm using which works great for a Win or Loss but when a Tie occurs as is shown on the last score I'm not sure what to add to the formula to make it show.

Thanks in advance for any assistance.

Jeff

If the line is +6.5, which team is getting the points?

 

[misticjeff]

If the line is +6.5, which team is getting the points?

Hi,

For the purposes of this chart, the home team is getting the points. So you'll see on the last entry that the home team gets 7.0 points and the score ends up Home/20 and Visitor/27 which when you factor in the line is a Tie. I need to be able to show Tie and not loss.

 

[T. Valko]

Hi,

For the purposes of this chart, the home team is getting the points. So you'll see on the last entry that the home team gets 7.0 points and the score ends up Home/20 and Visitor/27 which when you factor in the line is a Tie. I need to be able to show Tie and not loss.

Let's assume:

• C2 = line
• D2 = Home team score
• E2 = Visiting team score

Then:

=IF(D2+C2=E2,"Tie",IF(D2+C2>E2,"Won","Lost"))

 

[misticjeff]

Let's assume:

• C2 = line
• D2 = Home team score
• E2 = Visiting team score

Then:

=IF(D2+C2=E2,"Tie",IF(D2+C2>E2,"Won","Lost"))

Worked beautifully!

Thanks a TON

Jeff

 

[T. Valko]

Worked beautifully!

Thanks a TON

Jeff

You're welcome. Thanks for the feedback!