Ronding off numbers appears from sum formula

[R J Solanki]

I want to round off (near zero) the number which appears from sum formula

25.50
25.25
50.75 this 50.75 appears from sum formula now i want that instead of 50.75 it appears after rounding off near zero i.e. 51

 

[Weaver]

if your cells are A1 and A2

=round(sum(a1:a2),0)

 

[R Pelle]

or possibly if you always want to roundupwards
=ROUNDUP(SUM(A1:A2),0)


Rob

 

[R J Solanki]

Thanks it works