Function to Round a number to nearest higher integer in MS Office, OpenOffice, NeoOffice

by rajesh 2013-12-09 21:02:04

Lets consider that you want a number like 1.1 to be rounded as 2.

We can easily do this using office function ROUNDUP
This is known to be availble in all office softwares including MS Office, NeoOffice and OpenOffice.

E.g:
=ROUNDUP(4.2,0) Rounds 3.2 up to zero decimal places as 4
=ROUNDUP(16.9121,2) Rounds 16.9121 up to two decimal places as 16.92
1332
like
0
dislike
0
mail
flag

You must LOGIN to add comments