When working with Excel, you often need to round the numbers to thousands. For example, 22,222,222 to round as 22,222,000.
The most common way to round a number to thousands is to use the Round Function with the following formula.
=TEXT(ROUND(A2,-3),"#,###")
Where ROUND(A2,-3) is to round a number to thousands, and Text function is to add a thousand separator.
Other than the Round Function, you can also use ROUNDUP function or ROUNDDOWN function.
The ROUND function is to round up when the hundred number is 5 or larger, and round down when the hundred number is less than 5.
The ROUNDUP function is to round up all numbers to thousands, while the ROUNDDOWN function is to round down all numbers if the number is less than 1000.
If you want to round up all numbers, please use the formula below.
=TEXT(ROUNDUP(A2,-3),"#,###")
If you want to round down all numbers, please use the formula below.
=TEXT(ROUNDDOWN(A2,-3),"#,###")
