Bonjour,
jé un probleme au niveau cette formule =SI(A4<=2,65;"0";SI(A4<=2,7;"0,5";SI(A4<=2,75;"1";SI(A4<=2,8;"1.5";SI(A4<=2,85;"2";SI(A4<=2,9;"2,5";SI(A4<=2,95;"3";SI(A4<=3;"3,5";SI(A4<=3,05;"4";SI(A4<=3,1;"4,5";SI(A4<=3,15;"5";SI(A4<=3,2;"5,5";SI(A4<=3,3;"6";SI(A4<=3,4;"6,5";SI(A4<=3,5;"7";SI(A4<=3,6;"7,5";SI(A4<=3,7;"8";SI(A4<=3,8;"8,5";SI(A4<=3,9;"9";SI(A4<=4;"9,5";SI(A4<=4,1;"10";SI(A4<=4,16;"10,5";SI(A4<=4,23;"11";SI(A4<=4,3;"11,5";SI(A4<=4,37;"12";SI(A4<=4,46;"12,5";SI(A4<=4,53;"13";SI(A4<=4,6;"13,5";SI(A4<=4,67;"14";SI(A4<=4,73;"14,5";SI(A4<=4,8;"15";SI(A4<=4,87;"15,5";SI(A4<=4,99;"16";SI(A4<=5,11;"16,5";SI(A4<=5,21;"17";SI(A4<=5,35;"17,5";SI(A4<=5,47;"18";SI(A4<=5,59;"18,5";SI(A4<=5,71;"19";SI(A4<=5,83;"19,5";SI(A4<=5,95;"20";"20"))))))))))))))))))))))))))))))))))))))))) cé un brame de bac sport .elle marche bien pour l'office 2007 ;mais au niveau excel 2003 elle ne fonctionne pas .aidé moi svp
jé un probleme au niveau cette formule =SI(A4<=2,65;"0";SI(A4<=2,7;"0,5";SI(A4<=2,75;"1";SI(A4<=2,8;"1.5";SI(A4<=2,85;"2";SI(A4<=2,9;"2,5";SI(A4<=2,95;"3";SI(A4<=3;"3,5";SI(A4<=3,05;"4";SI(A4<=3,1;"4,5";SI(A4<=3,15;"5";SI(A4<=3,2;"5,5";SI(A4<=3,3;"6";SI(A4<=3,4;"6,5";SI(A4<=3,5;"7";SI(A4<=3,6;"7,5";SI(A4<=3,7;"8";SI(A4<=3,8;"8,5";SI(A4<=3,9;"9";SI(A4<=4;"9,5";SI(A4<=4,1;"10";SI(A4<=4,16;"10,5";SI(A4<=4,23;"11";SI(A4<=4,3;"11,5";SI(A4<=4,37;"12";SI(A4<=4,46;"12,5";SI(A4<=4,53;"13";SI(A4<=4,6;"13,5";SI(A4<=4,67;"14";SI(A4<=4,73;"14,5";SI(A4<=4,8;"15";SI(A4<=4,87;"15,5";SI(A4<=4,99;"16";SI(A4<=5,11;"16,5";SI(A4<=5,21;"17";SI(A4<=5,35;"17,5";SI(A4<=5,47;"18";SI(A4<=5,59;"18,5";SI(A4<=5,71;"19";SI(A4<=5,83;"19,5";SI(A4<=5,95;"20";"20"))))))))))))))))))))))))))))))))))))))))) cé un brame de bac sport .elle marche bien pour l'office 2007 ;mais au niveau excel 2003 elle ne fonctionne pas .aidé moi svp