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.

GAME TOTAL FORECAST SCORE OUTCOME OVER UNDER WON LOST 102 16 97 U L 115 -11 131 O L 104 -1 103 U W 110.5 -4.5 112 O L 112 -6 128 O L 103.5 9.5 182 O W <tbody> </tbody>

<tbody>
</tbody>

 

[Marcusandkylie]

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

	A	B	C	D	E	F	G	H
1	GAME TOTAL	FORECAST	SCORE OUTCOME	OVER	UNDER	WON	LOST
2	102	16	97		U		L
3	115	-11	131	O			L
4	104	-1	103		U	W
5	110.5	-4.5	112	O			L
6	112	-6	128	O			L
7	103.5	9.5	182	O		W

<tbody>
</tbody>

 

[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