Hello,
I am in a racing league and have a page in my spreadsheet which wil
distribute points to a driver depending upon where he/she has finishe
in the race.
As an example, the driver who finishes in the 1st postion receives 2
points, 2nd position receives 17 points, etc. The list contains a tota
of twelve drivers. My intention was to enter the finishing position o
each driver in a particular cell, and in another cell the formula wil
calculate the appropriate points. I have attempted to use the "If
function, as in IF(L22="1","21", If(, etc: However, a well know
limitation to Excel is that you cannot "nest" more than 7 function
with this statement.
I have used the CHOOSE function, which works nicely as when th
finishing position is entered, the formula will assign the driver th
appropriate number of points. However, I am still running into a
issue. Each cell that has the CHOOSE funtion looks like this: ######.
It's onlly until I enter the finishing position for the driver that i
will return the points awarded.
The last column of the spreadsheet there is a "Total Points" colum
which will add the total number of points for each driver throughou
the race season. The cells in that column look like this: $VALUE! I
is only until I enter the finishing position for the driver for ever
race that the Total Points column will change from $VALUE! to, say
total points of 75. I would like the Total Points column to sho
accumulated points after every race. With this funtion you have t
finish every race in a season to show the total number of points fo
each driver
I have noticed on a number of websites, such as this that the VLOOKU
function may be an option, but I am uncertain on how to use this for m
spreadsheet. This is probably very confusing and have worded this th
best that I can being a beginner to the program. Any help would b
much appreciated. Thank you
--
fetzerPosted from http://www.pcreview.co.uk/ newsgroup acces