One way:

=CEILING(A1,100)

Another:

=ROUNDUP(A1,-2)

In article ,
Fred Holmes wrote:

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

f(26,335.37) = 26,400.00