View original (French)

Ceiling in a sum formula

Solved
Calou -  
 Calou12345 -
Hello,

I want to sum a column of percentages, and the result has two decimal places, but it is displayed as the lower rounding (45.00% instead of 45.01%). How can I fix this? I tried the formula =SUM(E88:E105);ROUNDUP(SUM(E88:E105),2), but it doesn't work. Where is the error?

Thank you for your help.

1 réponse

Réponse 1 / 1
debilosus Posted messages 8 Registration date   Status Membre Last intervention   5
 
Try =ROUNDUP(SUM(E88:E105),2) and it should work :)
2
Calou12345
 
Great! Thank you very much, it works perfectly.
0