Excel Predictions IF Function Formula

[JEV086]

Hi can someone help me with this problem, i want to a formula that can calculate points based on a prediction.

i.e here is an example of how i have it now

John Matty
Home Team |2| v |Away Team |3| | 1-3 | 1 | 2-3 | 3

Now how the scoring works is 3 points for correct score and 1 point for correct result.

If anymore information is needed please let me know

[Pete_UK]

It's difficult to make out how your data is laid out in that example, so it would help if you attached a sample Excel workbook. To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete