If you make the num_digits argument a positive value, **Excel rounds** the **number** to the specified **number** of decimal places. If you enter the num_digits argument as a negative **number**, **Excel rounds** the **number** to the left of the decimal point. Instead of the **ROUND** function, you can use the ROUNDUP or ROUNDDOWN function.

Correspondingly, how do you round to the nearest number?

Look to the next smallest place value, the digit to the right of the place value you're **rounding** to. For example, if you want to **round to the nearest** ten you'd look at the ones place. If the digit in the next smallest place value is less than five (0, 1, 2, 3, or 4), you leave the digit you want to **round** to as-is.

What are the methods of rounding?

Some languages, such as PHP, provide functions that round a value to a specified number of decimal digits, e.g. from 4321.5678 to 4321.57 or 4300. On the other hand, truncation (round to zero) is still the default **rounding method** used by many languages, especially for the division of two integer values.

**You May Like Also**