Soccer Formula

[jayjaysb]

Hi all, Looking for some help with a formula that allocates 3 points for a predicting Home Win, Away Win or Draw, but also allocates 6 points should the person predict the correct score, in the instance below Susan predicted 3-3, which was correct, in turn gets a total of 9 points, 3 for predicting draw and 6 for correct score. Much obliged JJSB

[TABLE="width: 604"]
<tbody>[TR]
[TD]Name[/TD]
[TD="colspan: 2"]Matches[/TD]
[TD="colspan: 2"]Predicted Score[/TD]
[TD][/TD]
[TD="colspan: 2"]Actual Score[/TD]
[TD][/TD]
[TD]Points[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]Russia[/TD]
[TD]Saudi Arabia[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]Russia[/TD]
[TD]Saudi Arabia[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]Russia[/TD]
[TD]Saudi Arabia[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]Russia[/TD]
[TD]Saudi Arabia[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Susan[/TD]
[TD]Russia[/TD]
[TD]Saudi Arabia[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Paul[/TD]
[TD]Russia[/TD]
[TD]Saudi Arabia[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Mel[/TD]
[TD]Russia[/TD]
[TD]Saudi Arabia[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Connor[/TD]
[TD]Russia[/TD]
[TD]Saudi Arabia[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[jayjaysb]

Another approach;

=(SIGN($F$2-$G$2)=SIGN(D2-E2))*3+(D2&E2=$F$2&$G$2)*6

Thanks krykm, it works sweet as a nut, Cheers JJSB

 

[jayjaysb]

Thanks to all of you for your input. much obliged to you all. JJSB

 

[Legacy 143009]

Never mind<g2,d2<e2),3,0)))< html=""></g2,d2<e2),3,0)))<>