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 answer

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