NFL Scores and Point spread Spreadsheet

[Mykro]

I'm Trying to build a spreadsheet that will tell me if a team has "won" or "lost" against the point spread.What you do is Enter in the team you want to play and the points. EX:

Teams Spread Score Result

SF -7 14 "LOST"
SD 21

SD +10 22 "WON"
NYJ 10

I Understand the IF Function But I'm missing something...I'm such a novice

 

[maxflia10]

Book1
	A	B	C	D
1	SFO	SAN	PointSp.
2	14	21	-7	lost
Sheet1

 

[Mykro]

Thanks for the reply ! Just one thing though.. I used your example but I added NO data in the fields.. The result was "WON"

What can be added to the formula to have it so it won't print WON or LOSE when no data has been entered ??

Thankx

 

[PaddyD]

=if(len(a2),IF(A2+C2<B2,"lost","won"))
This message was edited by PaddyD on 2002-10-19 00:49

 

[Mykro]

Thanks for your Help.. One thing it returns
the word "FALSE" is that as good as gets??

Thanks

 

[PaddyD]

things can always get better!

=if(len(a2),IF(A2+C2<B2,"lost","won"),"")

 

[Mykro]

Awesome !! I truely Appreciate your Help !
This board is Great !! Thank you !!

 

[Mykro]

Geuss What?? I have one more dilemma...
I'll use "Win" "Lose" for this example (True False). I have to win ALL my teams to win a Parlay.. If one team loses I've lost my bet...

Result Result

Won Won
Won Won
Won Won
Won Lose
Won Won

Answer "Won" Answer "Lose"

Thanks

 

[PaddyD]

=IF(ISNUMBER(MATCH("Lose",A1:A5,0)),"Lose","Won")

paddy

EDIT: typo
This message was edited by PaddyD on 2002-10-19 08:08

 

[Mykro]

Thanks for the reply.. But.. "won" is in the field when no data has been entered..

Thankx