Help for my football prediction game

[1.zer0]

Hi all,

I have devised a football prediction game for my workmates. what i need to know is how i can automate the results.

so, if i enter the correct score from the game, it will enter how many points the player has got.

rules are as follows:
correct score e.g 2-1 is 3 points
correct result e.g 1-0 but score was 2-1 is 1 point
0 points for anything else.

I've made a half-assed botched attempt and managed to get the 3 and 1 point to work (sort of) but not the 0 point.

i hope you understand what i mean and any help would be massively appreciated.

Many Thanks,
1.zer0

[zbor]

Try this:

Book1.xls

[1.zer0]

Brilliant!!! thank you zbor.

but one little thing, the score would be in 2 different cells so col A, B would be real score col C, D would be prediction for example.

I'm sorry to be a pain.... does it take much altering??

thanks a lot!!!!

[zbor]

No, that's even easier

So you make:

=IF(AND(A4=C4;B4=D4);3;IF(SIGN(A4-B4)=SIGN(C4-D4);1;0))

(replace ; with , if needed)

First part check if they perfectly match, seconf part look did you guess winner, 0 is everything else

[1.zer0]

i think your avatar says it all!! i should have made it clearer to start with so you didnt have to do all that work!!

massive thanks mate, very happy now

[1.zer0]

sorry for dp but it says formula error?? i tried changing the ; to , but no luck. sorry im complete noob....


Found the Edit button, lol.

got the formula to work but it only results with 1 point or 0 points. there is no 3 points. if the result is correct and the scoreline is correct they both show 1 point instead of 1 or 3 respectively.

EDIT AGAIN!!
OMG sorry to waste your time it was my fault. all is working perfectly now.

Thank you zbor!

[zbor]

Please, make thread [solved]

(Go to first post -> Edit -> Go advanced -> Choose solved from drop down menu)

Yes, avatar explain all of us sometimes

[JediMaster]

can you post the working link thanks

[JediMaster]

if no prediction score is not entered due non entrant and the correct score equals 0 0 gets 3 points or 2 2 draw the non entered player still scores 1 how do i get a n/a or just blank basically how do enter another default of being of 0 or even a blank cell