Hi again everyone,
Thanks for the guys that helped with the post I submitted the other day - managed to successfully get the formula working for scoring predicted scores.
Predictor.png
At the moment, however, since the predicted scores (column C and D) are blank and so are the actual scores to measure against (I & J), they are scoring them as a "correct score" with 5 points - what I want to be able to do is leave the score column blank until scores are entered in both the predicted column and the actual scores column. Is there anything I can add to the following formula to do this? Or is there any formatting I can do?
=IF(OR((C4>D4)-(I4>J4);(C4<D4)-(I4<J4));0;IF(AND(C4=I4;D4=J4);5;2))
Cheers,
J
Bookmarks