You can use a formula like

=ROUNDUP(A1,-3)

where A1 is the value to be rounded.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Syrus the Virus "
wrote in message
...
Hey Guys and Galls,

Problem: I have got number from 1 to 99999999. I want Every
result to
be check and when the number is between 1 to 999 it needs to be
rounded
to 1000, 1001 to 1999 needs to become 2000 etc.

Sollution: I don't havre any that's why I asked.

Tnxs in advance


---
Message posted from http://www.ExcelForum.com/