How can you round a number to the nearest 900?
 

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?

How can you round a number to the nearest 900?
 

=ROUND(A1,-3)-100


"trainer07" wrote:

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?

How can you round a number to the nearest 900?
 

=ROUND(A1,-3)-100

"trainer07" wrote:

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?

How can you round a number to the nearest 900?
 

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

"Teethless mama" wrote in message
...
=ROUND(A1,-3)-100


"trainer07" wrote:

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?