fetzer

07-10-2005, 12:05 AM

Hello,

I am in a racing league and have a page in my spreadsheet which will

distribute points to a driver depending upon where he/she has finished

in the race.

As an example, the driver who finishes in the 1st postion receives 21

points, 2nd position receives 17 points, etc. The list contains a total

of twelve drivers. My intention was to enter the finishing position of

each driver in a particular cell, and in another cell the formula will

calculate the appropriate points. I have attempted to use the "If"

function, as in IF(L22="1","21", If(, etc: However, a well known

limitation to Excel is that you cannot "nest" more than 7 functions

with this statement.

I have used the CHOOSE function, which works nicely as when the

finishing position is entered, the formula will assign the driver the

appropriate number of points. However, I am still running into an

issue. Each cell that has the CHOOSE funtion looks like this: ######.

It's onlly until I enter the finishing position for the driver that it

will return the points awarded.

The last column of the spreadsheet there is a "Total Points" column

which will add the total number of points for each driver throughout

the race season. The cells in that column look like this: $VALUE! It

is only until I enter the finishing position for the driver for every

race that the Total Points column will change from $VALUE! to, say a

total points of 75. I would like the Total Points column to show

accumulated points after every race. With this funtion you have to

finish every race in a season to show the total number of points for

each driver

I have noticed on a number of websites, such as this that the VLOOKUP

function may be an option, but I am uncertain on how to use this for my

spreadsheet. This is probably very confusing and have worded this the

best that I can being a beginner to the program. Any help would be

much appreciated. Thank you!

--

fetzerPosted from http://www.pcreview.co.uk/ newsgroup access

I am in a racing league and have a page in my spreadsheet which will

distribute points to a driver depending upon where he/she has finished

in the race.

As an example, the driver who finishes in the 1st postion receives 21

points, 2nd position receives 17 points, etc. The list contains a total

of twelve drivers. My intention was to enter the finishing position of

each driver in a particular cell, and in another cell the formula will

calculate the appropriate points. I have attempted to use the "If"

function, as in IF(L22="1","21", If(, etc: However, a well known

limitation to Excel is that you cannot "nest" more than 7 functions

with this statement.

I have used the CHOOSE function, which works nicely as when the

finishing position is entered, the formula will assign the driver the

appropriate number of points. However, I am still running into an

issue. Each cell that has the CHOOSE funtion looks like this: ######.

It's onlly until I enter the finishing position for the driver that it

will return the points awarded.

The last column of the spreadsheet there is a "Total Points" column

which will add the total number of points for each driver throughout

the race season. The cells in that column look like this: $VALUE! It

is only until I enter the finishing position for the driver for every

race that the Total Points column will change from $VALUE! to, say a

total points of 75. I would like the Total Points column to show

accumulated points after every race. With this funtion you have to

finish every race in a season to show the total number of points for

each driver

I have noticed on a number of websites, such as this that the VLOOKUP

function may be an option, but I am uncertain on how to use this for my

spreadsheet. This is probably very confusing and have worded this the

best that I can being a beginner to the program. Any help would be

much appreciated. Thank you!

--

fetzerPosted from http://www.pcreview.co.uk/ newsgroup access