how to use roundup

r4319hb · Dec 24, 2005

how to roundup the number to hundreds example 1250101 to 1250200 , 1250901 to
1251000 , 1250750 to 1250800
thank alot

Niek Otten · Dec 24, 2005

=ROUNDUP(A1,-2)

Bob Phillips · Dec 24, 2005

=CEILING(A1,100)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)