roundup, ceiling or whatever

I would like to create a calculation that rounds to the next higher 9000 and
add 900. I wonder if this can be done?

Example: a home price calculates to $447,865.75 in value. I want to make a
price of $449,900.

It would be nice if this solution could work in the five digit area also
such as a home calculating to $46,789.56 rounded up to $49,900.

An ideas?

Thanks all,

One way:

=CEILING(A1,10000)-100


In article <[email protected]>,
"Blake" <[email protected]> wrote:

> I would like to create a calculation that rounds to the next higher 9000 and
> add 900. I wonder if this can be done?
>
> Example: a home price calculates to $447,865.75 in value. I want to make a
> price of $449,900.
>
> It would be nice if this solution could work in the five digit area also
> such as a home calculating to $46,789.56 rounded up to $49,900.