Master Rounding in Excel: Round to 2 Decimal Places Easily 📊

The Excel ROUNDUP function returns a number rounded up to a given number of decimal places. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDUP rounds all numbers up.

ROUNDUP takes two arguments, number and num_digits. Number is the number to be rounded, and num_digits is the place at which number should be rounded. When num_digits is greater than zero, the ROUNDUP function rounds on the right side of the decimal point. When num_digits is less or equal to zero, the ROUNDUP function rounds on the left side of the decimal point. Use zero (0) for num_digits to round to the nearest integer. The table below summarizes this behavior:

ROUNDOWN

The Excel ROUNDDOWN function returns a number rounded down to a given number of places. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDDOWN rounds all numbers down.