ROUNDUP

[frustratedwthis]

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.

[JOn K via OfficeKB.com]

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

[Duke Carey]

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.