Rounding up a result in a cell to a whole number

I need to round up a result in a cell to the next whole number up. Cell B22 is a sum of a cell range (A2:A10) that will return a total of, say, 4500 and that has to be divided by 1000 giving 4.5 as a result, I need it to round up to 5. Many thanks.


=ROUNDUP(SUM(A2:A10)/1000;0) should do the job all in one go - or -
=ROUNDUP(B22/1000;0) (if you want to use sum in B22 already calculated)

Hope that helps.

It does indeed help, thanks very much, it’s appreciated.

If it is helpful please consider to click the check mark (:heavy_check_mark:) next to the answer. Thanks in advance …