Forum Discussion
Round off to a higher value
I've used a SUM-formula which have given me an answer in cell B2, which is 1251,67. I want to round off so that the answer in cell B2 is 1252. How do I manage that?
there are a number of options: =ROUND(), ROUNDUP(), CEILING and others. In you example they will work about the same but if the number was 1251.22 (i.e. <0.5) then they would act differently. Also the significance parameter would be 0 as you want 0 decimal places. so for example:
=ROUND( SUM(A1:A5), 0)