Hi all

I am new on here and was hoping for a little help. My question is similar to one on the following thread, but I dont think mine is quite as complicated. I was unable to sort from the answers on this thread so was hoping someone could help with a formula for my document....

http://www.excelforum.com/excel-form...t-formula.html


Basically, I have started a football prediction game. The scoring works like this:

5 points for a completely correct result and scoreline for both teams e.g. 1-0 prediction and 1-0 result
2 points for a correct result but not correct scoreline e.g. 1-0 prediction and 2-0 (or 2-1 etc) result
0 points for an incorrect result e.g. 1-0 prediction and 2-2 (or 0-1 etc) result


My formula's in rows I-L are nowhere near how they need to be, and that is as far as my abilities in excel go really!

Chris - he guessed 0-1 - he got the result and the scoreline correct, therefore should be 5 points
Dave - he guessed 1-3 - he got the result right but the scoreline wrong, therefore should be 2 points
Freddie - he guessed 0-2 - he got the result right but the scoreline wrong, therefore should be 2 points
Graham - he guessed 1-1 - he got the result incorrect and therefore should be 0 points
Liam - he guessed 0-1 - he got the result and the scoreline correct, therefore should be 5 points
Theo - he guessed 1-0 - he got the result incorrect and therefore should be 0 points


Although it does not take that much to type it in, it would be very handy to know a formula to use for this. I want to be able to just type the result into the fixture tab, and then it automatically fill in columns H and I for me, adding the total points accrued into I41.

Any help would be very appreciated....

Thanks in advance...Tottenham Fixture Game.xlsTottenham Fixture Game.xls