Hi,

This should work:

=IF(AND(C4=C3,E4=E3),3,IF(AND(C3E3,C4E4),1,IF(AN D(C3<E3,C4<E4),1,0)))

obviously you would have to match up the cells referred to with the cells
holding the score values...

Hope it helps

"J.Scargill" wrote:

Hi all,

Hope you are all well.

To boost staff morale at my work, I am trying to come up with a World Cup
2010 Predictions Competition.

I have 3 worksheets - Sheet 1 with all the fixtures from the group games on
where I will input the actual result; Sheet 2 with the individuals
predictions and Sheet 3 is going to be my League Table.

My points system is 3pts for an exact match and 1pt for predicting the
correct outcome of a fixture.

In Sheet 2 I have the formula
=IF((B4=Fixtures!C7)*(Predictions!C4=Fixtures!D7), 3,0) to calculate if the
prediction is worth 3pts. But what formula do I use to calculate if the
prediction is correct in terms of the outcome only

ie Prediction - Germany 2 France 1
Actual - Germany 1 France 0

Above should be worth 1pt.

Hope you can help!