frustratedwthis wrote:
Will ROUNDUP work if I want to take the sum of so many rows and round it to
the next whole # even if it should be rounded down. i.e. the # is 5.33, but
I want it to show 6.


Yes assuming 5.33 is in cell A1 use the formula =ROUNDUP(A1,0)

Using "0" rounds to the nearest integer.


--
Message posted via http://www.officekb.com