rounding nearest 1000

[SMILE]

Hi guys
How do I do round to nearest 1000s or 100s ???
Eg: I have a value 25479 and I need it to be round to 25000

or I have 153 to be changed to 200 . Also I need another function to change to 100 instead of 200

Hope to see some solution
Thanks
Toms

[Drummond]

Hi Toms,

>How do I do round to nearest 1000s or 100s ???

Try this:
with the interger in cell A1
enter in A2 =(ROUND((A1/100),0))*100

You can then fill this down column B to round off values in column A.

> Also I need another function to change to 100 instead of 200

That would be to round down, right? so 100 becomes 100, 199 becomes 100 and 200 becomes 200?

In this case the above formula will work with the ROUND command replaced with the ROUNDDOWN command.

HTH,
Drummond

[SMILE]

Hi Drummond
Thanks for the answer.
Toms