Round down fomula

Debbie Sin

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

 

 

rjudenberg

=1000 * ROUND(Value/ 1000)

Debbie Sin

Hi 

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

rjudenberg

=1000*INT(Value/1000)

Debbie Sin

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

Debbie

Debbie Sin

Got it, Thanks so much