How can you round a number to the nearest 900?

[trainer07]

I am trying to round to the nearest 900. Example: if you have $100,500 in a
cell I want it rounded to $100,900. If I have $100,200 I want it rounded to
$99,900. Is there a way to do this?

 

[Teethless mama]

=ROUND(A1,-3)-100

 

[MrAcquire]

=ROUND(A1,-3)-100

 

[David Biddulph]

Or perhaps =ROUND(A1+100,-3)-100 if you want the nearest?