I have my championship leaderboard, which has a line " Number of laps per race " and below " laps completed ".
I want to go through all the values in the line " Completed laps" and compare with " Number of laps per race ", with the following logic:
se Voltas Completadas < (Voltas por corrida*0,35 ),
retorna 1(quantas vezes ocorrer) na célula,
senão,
retorna 0
But I can not make it work. I tried with CONT.SE
, but it seems to only work with some specific value!
How to work out this formula?