Round to next Whole Number

[Disarmonious]

Hello,

If my sum cell equals 25.13, and I want that cell to round up to 26.00, what formula would I use?

 

[DataBlake]

hello,

if my sum cell equals 25.13, and i want that cell to round up to 26.00, what formula would i use?

=roundup(a1,0)

 

[joeu2004]

One caveat.... If the cell might appear to be 25.00 due to formatting, but it is actually 25.001, I presume that you would expect the result to be 25.00, not 26.00.

If that might be an issue, try: =ROUNDUP(ROUND(A1,2),0) .

 

[Disarmonious]

Thank you BlakeSkate!

 

[Disarmonious]

Thank you Joeu2004!