Ceiling in a sum formula
Solved
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.
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.