F1 prediction

[NELG10]

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.

 

[NELG10]

I think this does what you are looking for:

Sheet2

*	A	B	C	D
1	Prediction	Driver	Finished	Points
2	1	Snakehips Wife	1	8
3	2	NELG11	4	6
4	3	Lewis Hamilton	6	5
5	4	Roadrunner	5	7
6	5	Ping G5	2	5
7	6	Stirling Moss	3	5
8	7	Snakehips *Daughter	7	8
9	8	Snakehips	22	0

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:90px;"><col style="width:144px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D2 =MAX(0,8-ABS(A2-C2)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Perfect, works exactly as I intended.

Thank you

Now just got work out how to beat the missis