Excel round to nearest 1000

Most people are aware of how to use the ROUND functions to round numbers to various decimal levels e.g. 5.5678 to either 5.568 or 5.57 or 5.6 or 6 depending on what you specify the number of digits (3, 2, 1 or 0 respectively for the numbers above). What about how to get Excel round to nearest 1000 (or similar rounding after the decimal sign).

It is surprisingly simple. In the number of digits field you must put a negative in front of the number.

So for a number like

123 456 789,

depending on the number of digits input you would get:

123 456 789 (0 digits)
123 456 790 (-1 digits)
123 456 800 (-2 digits)
123 457 000 (-3 digits)
123 460 000 (-4 digits)
123 500 000 (-1 digits)
123 000 000 (-1 digits)
120 000 000 (-1 digits)

The same logic works with ROUNDUP, ROUNDDOWN etc