I made it work to fill in the lap times and max and avr speeds with the right formating.
however when I try to add a condition on the sector times for the average, it does not give me any error but nothing happens anymore in the cells.
Could you please tell me how and where to add the condition saying that if a sector time is superior to the previous sector time (in rows) multiplied by a factor 1.2 then it should not be included in the average?
Thanks in advance!!
(I am not sure 1.2 is the right coefficient but this is just a bit of tuning to do afterwards.)
Bookmarks