Posted to microsoft.public.excel.worksheet.functions
|
|
assigning points to rankings
Cause I, ahhhh...never thought about that. :)0
Your right! The Rank function would never be negative.
Thanks for the catch. :)
If the op wanted to go this route, then perhaps just: =MOD(14,7+MIN(A1,7))
Thanks again.
--
Dana DeLouis
Windows XP, Office 2003
"Sandy Mann" wrote in message
...
Dana,
=MOD(14,7+MAX(MIN(A1,7),0))
May I ask why you included the Max() function? The formula seems to work
just as well without it unless A1 is negative and as A1 is being generated
by a RANK() function surely it can never be negative.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"Dana DeLouis" wrote in message
...
1st=6pts, 2nd=5pts, 3rd=4pts,
4th=3pts, 5th=2pts, 6th=1pt,
7th place through 30th place =0.
Perhaps another option with numbers in A1
=MOD(14,7+MAX(MIN(A1,7),0))
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003
"Nan-C" wrote in message
...
I have ranked the times of races for 30 participants. The results are in
a
column. I want to display the points given in the next column. The only
points given are for 1st through 6th place. 1st=6pts, 2nd=5pts,
3rd=4pts,
4th=3pts, 5th=2pts, 6th=1pt, 7th place through 30th place =0. Times,
therefore ranks, will change with each race, so this information needs
to be
in every cell in that column.
NAME TIME RANK PTS
Joe 12.05 2 5
Mary 13.00 3 4
Sue 10.57 1 6
Sam 15.04 8 0
I figured out the rank formula, but I can't figure out how to assign the
points. Can someone help me, please?
|