If you want to round a number to the nearest major unit, such as thousands, hundreds, tens, or ones, use a function in a formula, follow these steps:
If you don’t want unnecessary decimal places in cells because they cause # symbols to appear, or you don’t need accuracy down to the microscopic level, change the cell format to get the number of decimal places you want.