Round down fomula

I would like to round down the figure into thousand. However, it seems there is only a Round function but to Round down. How can I make it happen?

Thanks

Find more posts tagged with

=1000 * ROUND(Value/ 1000)

Thanks, I try to round down 10597 into 10000. If I use the formula as suggested, the figure will show 11000.

=1000*INT(Value/1000)

Is there any other formula that I can use to round down 10597 into 10000?

Debbie

Got it, Thanks so much