NBA totals

[Marcusandkylie]

Hello, can someone please help with this... I'm trying to get excel to IF function to return to words to W and L without having to manually type it in.

Here is an example below. The forecast means, +16 play the over to win and -11 means play the under to win. basically any plus symbol play over and any minus play under.

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]GAME TOTAL[/TD]
[TD]FORECAST[/TD]
[TD]SCORE OUTCOME[/TD]
[TD]OVER[/TD]
[TD]UNDER[/TD]
[TD]WON[/TD]
[TD]LOST[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]16[/TD]
[TD]97[/TD]
[TD][/TD]
[TD]U[/TD]
[TD][/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]115[/TD]
[TD]-11[/TD]
[TD]131[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]104[/TD]
[TD]-1[/TD]
[TD]103[/TD]
[TD][/TD]
[TD]U[/TD]
[TD]W[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]110.5[/TD]
[TD]-4.5[/TD]
[TD]112[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]112[/TD]
[TD]-6[/TD]
[TD]128[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]103.5[/TD]
[TD]9.5[/TD]
[TD]182[/TD]
[TD]O[/TD]
[TD][/TD]
[TD]W[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcusandkylie]

Opps I'm new to this and I see everyone inserting the column and rows, so here go again



[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]GAME TOTAL[/TD]
[TD]FORECAST[/TD]
[TD]SCORE
OUTCOME[/TD]
[TD]OVER[/TD]
[TD]UNDER[/TD]
[TD]WON[/TD]
[TD]LOST[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]102
[/TD]
[TD]16[/TD]
[TD]97[/TD]
[TD][/TD]
[TD]U[/TD]
[TD][/TD]
[TD]L[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]115[/TD]
[TD]-11[/TD]
[TD]131[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD]L[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]104[/TD]
[TD]-1[/TD]
[TD]103[/TD]
[TD][/TD]
[TD]U[/TD]
[TD]W[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]110.5[/TD]
[TD]-4.5[/TD]
[TD]112[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD]L[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]112[/TD]
[TD]-6[/TD]
[TD]128[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD]L[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]103.5[/TD]
[TD]9.5[/TD]
[TD]182[/TD]
[TD]O[/TD]
[TD][/TD]
[TD]W[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Michael M]

Still don't get it !!
Why is 16 in row 2 a Loss
you stated

basically any plus symbol play over and any minus play under.

and then in row 2 a plus is an Under ????

 

[Marcusandkylie]

I forecast the final game score to be 102+16= 118 but the final score outcome was 97 therefore the total was under my forecast which also means I lost.

Look at row 4, "the nail biter game" game total line came out as 104, I forecast -1 meaning the final score would have to be 103 or less to win.

Almost similar to this link https://www.mrexcel.com/forum/excel-questions/24973-nfl-scores-point-spread-spreadsheet.html