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?
|