Nathaniel a écrit :
I am creating a spreadsheet in Calc to track the drivers and teams in this
years Formula 1 championship.
At the moment it consists of 3 sheets with the main sheet being 18 cols by
25 rows. After each race I'm entering the finishing position of the drivers
from 1 to 8 as the points system only pays down to 8th place.
My question then is Can I use a formula to scan my race results sheet and
take the information from their and use it on both the drivers tally sheet
and the teams tally sheet? The catch being that I want the points for the
position to be added not the position the driver actually finished in.
To explain:
1st=10points
2nd=8
3rd=6
4th=5
5th=4
6th=3
7th=2
8th=1
So is there a formula that can get Calc to see the number 1 but actually add
10 to the cell on the other sheet and so on down the list??
I hope I have explained this correctly.
Nathaniel,
If The position of a driver is in Sheet1.A1 and you want to have his
points in Sheet2.A1 then put in this cell the following formula
=IF(Sheet1.A1>8;0;IF(Sheet1.A1>3;9-Sheet1.A1;12-2*Sheet1.A1))
The first section of the Formula IF(Sheet1.A1>8;0;
says that if the position of the driver is greater than 8 he has 0 points.
The second section IF(Sheet1.A1>3;9-Sheet1.A1
will be executed if the first test is not true and wil verify if the
position of the driver is greater than 3 in wich case his points will be
9 - his position
And the last section 12-2*Sheet1.A1
wil be executed if the other cases (less or equal 3). The points of the
driver wil then be 12 - two times his position.
You will have to copy this formula for all the cells.
Phil
P.S. You can put the position even if it is greater than 8.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
