Problem with ranking numbers

From: Pati M (M_at_discussions.microsoft.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 15:19:06 -0800

I am having trouble with ranking numbers. I am trying to rank heat times for
7 out of 24 contestants. my rankedx numbers are going from 18 through 24
instead of 1 through 7. How can I correct this? The formula I am using is as
follows:
=IF(L12="TNT",0,IF(L12="DNF",0,IF(L12="DNS",0,IF(L12="SCRATCH",0,IF(L12="DISQ",0,IF(L12="DNF/FLIP",0,IF(L12=0,0,RANK(L12,L$12:L$300,1))))))))
each row has the same formula for the correct cell.