Excel: F1 prediction

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.

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of September 20, 2014.

For more resources for Microsoft Excel