Summing & Rounding

P

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 [email protected]
 
A

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
 
Top