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)