Hi,

I need help!

I am trying to create a formula but i'm not really sure how to do it...

Basically, the jist of what i'm trying to do is a "predictions" league where you guess the outcome of a football match and get a points for correct scores.

Eg.

Arsenal V Chelsea.
The result was Arsenal 2 v 1 Chelsea.

- If i predicted the correct 2-1 score i would get 3 points,
- If i predicted the right result (Arsenal win) but wrong score i.e 3-1, i would get 1 point,
- If i predicted a draw or a loss i would get 0 points.

I have the excel spreadsheet laid out like this:

Cells
A1 A2 A3 A4
Arsenal 2 1 Chelsea

I have tried IF, AND, OR Formula's but i just can't seem to crack it and get all the results i need!

If anyone has any idea it would be much appreciated.