Round up to 100?

Fred Holmes · Feb 21, 2005

I'm trying to construct a worksheed formula that will round up to the
nearest 100.

f(26,335.37) = 26,400.00

JE McGimpsey · Feb 21, 2005

One way:

=CEILING(A1,100)

Another:

=ROUNDUP(A1,-2)

rounding a number up to a certain ending digit	6	May 4, 2012
Alternate Rounding Up & Down of .50 in a column	5	Jun 2, 2010
rounding up to the nearest 1000	1	Feb 23, 2010
rounding to nearest 100	2	Dec 17, 2007
Divide a # into 3 #'s rounded to a whole #	9	Feb 7, 2013
Rounding Time to Nearest 5 Minutes	1	Mar 2, 2011
Round Question	3	May 20, 2011
Round Function	5	Feb 24, 2010

Ask a Question