Try this:

=ROUND(A250,-3)

Does that help?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"JNAP101" wrote in message
...
Would anyone know a formula for the following?

What formula would round down if the tens of thousands in a number is less
then 10,000.00 or round up if over 10,000.00? For example if cell A250
equals
506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the
cell
would read 512,000?