Hi Guys
I got one for you. I have a sheet that i have attached
Is there a way I can come up with a function/formula that will check all the
predictions against the actual match results as I enter them.
Points are scored as follows:
HOME WIN PREDICTED
SPOT ON =*40 pts
CLOSE = 20 PTS (-3 PER GOAL OUT)
WRONG = 0 PTS (-3 PER GOAL OUT)
DRAW PREDICTED
SPOT ON =*50 pts
CLOSE = 30 PTS (-3 PER GOAL OUT)
WRONG = 0 PTS (-3 PER GOAL OUT)
AWAY WIN PREDICTED
SPOT ON =*50 pts
CLOSE = 30 PTS (-3 PER GOAL OUT)
WRONG = 0 PTS (-3 PER GOAL OUT)
I am using Excel 2003.
I would really appreciate it if someone could come up with the answer to
this beauty!!
Thanks
Bookmarks