Summing & Rounding

[picktr]

I need 1 formula to do the following:

Sum of 2 cells then round up or down to 0 d.p.s
(note: it must go either direction in rounding)


I get this, my work is done!

after 4 days.

Tom (e-mail address removed)

 

[AlfD]

Hi!

If the cells are A1 and A2 the formula is =round(A1+A2,0)

This rounds down if the result is less than "a half" and up if it i
greater than or equal to "a half".

Al

 

[Frank Kabel]

Hi
maybe
=ROUND(A1+A2,0)

 

[Karl]

round(a1+a2,0) replace a1 and a2 for whatever you need sum of