ROUNDUP
 

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.

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

Did you try? Apparently not...

Yes, it will work. Roundup(5.33,0)=6

"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.