ROUNDUP

F

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

JOn K via OfficeKB.com

frustratedwthis said:
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.
Click to expand...


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

Using "0" rounds to the nearest integer.
 
Top