Russ At Index
Wellknown Member
 Joined
 Sep 23, 2002
 Messages
 704
 Office Version

 365
 2016
 Platform

 Windows
 MacOS
Hi All,
Here goes....
C4 Actual Home Score
D4 Actual Away Score
E4 Joker ( Doubles Pts Score if Played )
F4 Predicted Home Score
G4 Predicted Away Score
H4 Has the following formula:
=((SIGN(C4D4)=SIGN(F4G4))+(C4=F4)*(D4=G4)*3)*IF(E4="Joker",2,1)
Therefore you will get 1 pt for a correct outcome ( home win although
your prediction was incorrect)
3 pts for a 100% correct prediction
& If you have played your Joker in in cell E4 , you will double your
pts score ( providing you have pts to double)
Formula above is not reporting correctly....... convinced it did last season !
Can someone point me in the right direction ?
Thanks In Advance
Russ
Here goes....
C4 Actual Home Score
D4 Actual Away Score
E4 Joker ( Doubles Pts Score if Played )
F4 Predicted Home Score
G4 Predicted Away Score
H4 Has the following formula:
=((SIGN(C4D4)=SIGN(F4G4))+(C4=F4)*(D4=G4)*3)*IF(E4="Joker",2,1)
Therefore you will get 1 pt for a correct outcome ( home win although
your prediction was incorrect)
3 pts for a 100% correct prediction
& If you have played your Joker in in cell E4 , you will double your
pts score ( providing you have pts to double)
Formula above is not reporting correctly....... convinced it did last season !
Can someone point me in the right direction ?
Thanks In Advance
Russ