The ROUND function can round to the right or left of the decimal point.
Round to nearest 1000
If you need to round a number to the nearest 1000, you can use the ROUND function and supply -3 for number of digits.
The ROUND function can round to the right or left of the decimal point.