Round

[Fredrennes]

Hello à tous,

Qq utilise ou connait la fonction "ROUND" svp ? Qq peut me faire un petit topo là-dessus ?

Merci

Amicalement
Fred

 

[Mytå]

Salut Fredrennes

Round(Version anglaise) ou Arrondi(version francaise)

12345,6789 =ARRONDI(A1;5) 12345,6789
12345,6789 =ARRONDI(A2;4) 12345,6789
12345,6789 =ARRONDI(A3;3) 12345,679
12345,6789 =ARRONDI(A4;2) 12345,68
12345,6789 =ARRONDI(A5;1) 12345,7
12345,6789 =ARRONDI(A6;0) 12346
12345,6789 =ARRONDI(A7;-1) 12350
12345,6789 =ARRONDI(A8;-2) 12300
12345,6789 =ARRONDI(A9;-3) 12000
12345,6789 =ARRONDI(A10;-4) 10000
12345,6789 =ARRONDI(A11;-5) 0

Mytå

 

[Fredrennes]

Merci bcp

Bonne soirée

Amicalement
Fred