# F1 prediction

#### NELG10

##### New Member
Hi, I would like to run a simple formula one prediction game next year and would like to use the last remaining races to trial what ever I get together.

setting the bar low I think, but I just what a top 8 prediction.
8 points for correct position then one point less for out of position, ie: predicted lewis hamilton 3rd and he finished 8th, so there for you would get 5 points.

have set the drivers names in a column (1-8) then the next column would just like to enter actual finished position and excel fill out points in separate cell.

have search for the formula with no success.

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
NELG10,

Welcome to MrExcel.

Is this what you want....

Excel 2007
ABCD
1PredictionDriverFinishedPoints
21Snakehips10
32NELG1142
43Lewis Hamilton85
65Ping G523
76Stirling Moss33
87My Daughter70
98My Wife62
Sheet6
Cell Formulas
RangeFormula
D2=ABS(C2-A2)

NELG10,

Welcome to MrExcel.

Is this what you want....
Excel 2007
ABCD
1PredictionDriverFinishedPoints
21Snakehips10
32NELG1142
43Lewis Hamilton85
65Ping G523
76Stirling Moss33
87My Daughter70
98My Wife62

</tbody>
Sheet6

Worksheet Formulas
CellFormula
D2=ABS(C2-A2)

</tbody>

<tbody>
</tbody>

spot on, just for instance predicted 1st comes in first you would gets 8 points. but if predicted 1st and came 8th only 1 point. just to throw it in, if they finish outside the top 8 nill points.

Thanks for responding be trying to get this nailed all afternoon.

spot on, just for instance predicted 1st comes in first you would gets 8 points. but if predicted 1st and came 8th only 1 point. just to throw it in, if they finish outside the top 8 nill points.

So are you ok to formulate the above?

Tony, I admire you for placing yourself 7 places above the wife (till she sees it anyway).

Hi, if I have predicted snakehips 1st ,then it comes in 1st, it should be 8 points not 0.
When I said spot on was referring to the general look of the sheet.

@MARK,

Yep, on reflection, a bad move!!!
She has seen it and as a consequence my right eye is closing fast.

I've asked her to finish off this post whilst I go to see if there's any steak in the fridge.....

*****
@ NELG10,

Is this it..
Excel 2007
ABCD
1PredictionDriverFinishedPoints
21My Wife*****18
32NELG1142
43Lewis Hamilton63
65Ping G523
76Stirling Moss33
87My Daughter78
98Snakehips88
Sheet6
Cell Formulas
RangeFormula
D2=IF(A2=C2,8,ABS(C2-A2))

Hope that helps
Regards Mrs Snakehips ****

@MARK,

Yep, on reflection, a bad move!!!
She has seen it and as a consequence my right eye is closing fast.

I've asked her to finish off this post whilst I go to see if there's any steak in the fridge.....

*****
@ NELG10,

Is this it..Excel 2007
ABCD
1PredictionDriverFinishedPoints
21My Wife*****18
32NELG1142
43Lewis Hamilton63
65Ping G523
76Stirling Moss33
87My Daughter78
98Snakehips88

</tbody>
Sheet6

Worksheet Formulas
CellFormula
D2=IF(A2=C2,8,ABS(C2-A2))

</tbody>

<tbody>
</tbody>

Hope that helps
Regards Mrs Snakehips ****

Hi think its getting there, still not fully working, as what I was after is, say you predict all 8, in the correct postion, you would get 64 points, and on the chart above for instance
NELG11 was predicted 2nd and result was 4 there for 2 places from correct position so should recieve 6 points
I appreciate you help on this

Glen

I think this does what you are looking for:

Excel Workbook
ABCD
1PredictionDriverFinishedPoints
21Snakehips Wife18
32NELG1146
43Lewis Hamilton65
65Ping G525
76Stirling Moss35
87Snakehips Daughter78
98Snakehips220
Sheet2

Well done Form.

Looks like Mrs Snakehips stuffed that one up whilst I was incapacitated.

Replies
0
Views
154
Replies
5
Views
202
Replies
1
Views
516
Replies
8
Views
171
Replies
3
Views
997

1,203,453
Messages
6,055,530
Members
444,794
Latest member
HSAL

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back