Excel help
Having a complete and utter brainfart here and dont know why. I have the following data in columns.
Cell F2 contains the home spread
Cell J2 contains the game margin for the home point of view, ie -6 says they lost by 6 etc
Now I want a formula that will say "Win" if the team covered the 6pt teaser line, and obviously "Loss" for a loss and "Push" if it ties.
I've been playing around for about 2 hours and its irritating me somewhat, although the solution is probably very easy.
Anyone care to help with what the formula should be before I stick a burning hot fork in my eyeball?
Cheeeeers
Cell F2 contains the home spread
Cell J2 contains the game margin for the home point of view, ie -6 says they lost by 6 etc
Now I want a formula that will say "Win" if the team covered the 6pt teaser line, and obviously "Loss" for a loss and "Push" if it ties.
I've been playing around for about 2 hours and its irritating me somewhat, although the solution is probably very easy.
Anyone care to help with what the formula should be before I stick a burning hot fork in my eyeball?
Cheeeeers
