Round up to 100?

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

f(26,335.37) = 26,400.00

One way:

=CEILING(A1,100)

Another:

=ROUNDUP(A1,-2)

In article <c5sj115jhv9tept5658bo7q2s2uu7fujs1@4ax.com>,
Fred Holmes <fsh@his.com> wrote:

> I'm trying to construct a worksheed formula that will round up to the
> nearest 100.
>
> f(26,335.37) = 26,400.00