lap

So im trying to rank my lap times but i keep getting the error that my lap time is a text value and not a number value because it has two decimal places. e.g 2.23.340 i get an error but 2.23 works. is there a way to rank numbers with two decimal places. Formula =RANK(D3:D27,LapTimes,1)...

hi all - Thanks ahead of time if you can help me ! I am trying to create the formula to count cells if there are values but it has to meet certain criteria. I need to count how many laps a car makes a lap around the track. The only data points I have are the laps and the speed in which each...

I am trying to get in better shape. One part of my regimen is running (jogging). I usually just go out and run one of several routes in our neighborhood that I have mapped out with Google Maps so I know the distance. I take a stopwatch and time the run. When I get back, I log the date, distance...

Hello, I'm having some difficulty trying to use the SUM and ROUNDDOWN function. I have the following formula "=IF(ISTEXT(D3),IF(D3="Basic",SUM(L3:AP3)+COUNTIF(L3:AP3,"NA"),""),"")". This formula looks in column D to see the rate, then sums the entries in cells L:AP. In some cases I need...

hello, I need help in sorting lap time for school event (sport day) and display it automatically after the time been insert in the sheet. I'm sorry I don't know how to attach my excel here but here are my google doc link for the excel book...

hello all.. i have excel formula, that's make confused : how to make more easy or similar that, name sheet "Input Lap" =VLOOKUP(VLOOKUP($N$2;'Input Lap'!$A:$CQ;ROW(A23);FALSE);'Input Lap'!$A:$CQ;69;FALSE) i must typing one by one to change cell A23. A24,.....etc.... any help thank in...