If 2 results don't match, how can I make a 'Total' cell show 0, right now it shows 2 or 5

Hi all,

I have a score predictor game in a spreadsheet (see attached), and I have a formula in to work the points out already e.g. if the actual score is 1-1 and the person predicted the correct score exactly (e.g. 1-1), then they get 5 points, if they predicted the correct result (e.g. 2-2) then they get 2 points, or if they predicted in this case, a win for either time, then they would get 0 points.

My problem is that I have entered people's predictions (please see Sheet1, table titled Week 2 - I have entered 'Zak W' and 'Luke B' score predictions) and the games haven't been played yet so the actual results are blank. However, the total points adds up to 2 whenever someone has predicted a score draw, or if someone has predicted 0-0, it automatically gives them 5 points. How can I make these points stay at '0' until I have entered the actual results as well e.g. something along the lines of 'if actual scores blank, points = 0'.

Here is my current formula which works minus the problem I have:

Formula:

Please Login or Register  to view this content.

Hopefully I made sense and I look forward to any assistance.

Thank you so much, Zak

Like this:
=IF(OR(actual scores = "",(D16>E16)-(F16>G16),(D16<E16)-(F16<G16)),0,IF(AND(D16=F16,E16=G16),5,2))

Part of your problem is that you typed in "-" instead of just leaving the cells empty.
In H16, etc, use:

Please Login or Register  to view this content.

Please Login or Register  to view this content.