Round to nearest thousand

[sifatnabil]

Hi all,

I'm not able to find a good solution for rounding - floor and ceil would round up or down, but what if I wanted to just round to the nearest thousand? e.g. 500,990 should become 501,000

[sunny_talwar · Accepted solution]

May be this:

=Round(500990, 1000)

[sifatnabil]

Ah, didn't know it was that simple!

[sunny_talwar]

But now you do