Huge thanks to Daddy Long Legs, one of the Administrators for fixing my recent problem http://www.excelforum.com/excel-worksheet-functions/646345-football-predictions-predicted-goals.html
This one is similar, but there is more different scoring.
I have attached an excerpt of my spreadsheet and I want the scoring to be the following:
Predict Home Win = 1 point
Exact Score = 3 points
Predict Away Win = 2 points
Exact Score = 4 points
Predict Draw = 3 points
Exact Score = 5 points
The actual match score goes in columns D & E, predictions go in F & G and points will be entered into H depending if they match the above criteria.
Also, I would like the points column to stay blank until a score has been iput as Daddy Long Legs provided assistance with in the above post.
Hope I explained myself okay.
As always, thankyou for your valued assistance.
Regards, Craig
Last edited by keawyed; 06-20-2008 at 04:01 PM.
Hello Craig, try this formula in H3 copied down
=IF(COUNT(D3:G3)=4,(F3=D3)*(G3=E3)*2+CHOOSE(SIGN(D3-E3)+2,2,3,1)*(SIGN(D3-E3)=SIGN(F3-G3)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks