5 simple and most detailed ways to round numbers in Excel

In some Excel use cases, you will need to round to the nearest number because the decimal value is negligible, or you will need the data to be an integer to simplify the calculation. Tnhelearning.edu.vn will share with you 5 simple ways to round numbers in Excel.

Round numbers by adding number formatting

Step 1: Select the cell/range you want to format, then select General on the toolbar

Step 2: Select More Number Formats.

Step 3: Choose the appropriate format, such as Currency (Currency), Accounting (Accounting), Percentage ,…

Step 4: Enter the number of decimal places you want to display in the Decimal places box .

In addition, you can also do it quickly using the Increase Decimal or Decimal tool in the toolbar.

Use the function to round numbers up

The ROUNDUP function is used to round a number up, away from zero (zero).

For example, =ROUNDUP(3.275, 1) means rounding the number 3.275 up to 1 decimal place. The displayed result will be 3.3.

Using the Function Rounds Numbers Down

The ROUNDDOWN function is used to round a number down to zero (zero).

For example, =ROUNDDOWN(3.275,1) means rounding the number 3,275 down to 1 decimal place. The displayed result will be 3.2.

Function that rounds a number to the nearest number

The ROUND function is used to round a number to the nearest number of decimal places specified.

For example, =ROUND(3.275,2) means rounding the number 3.275 to 2 decimal places. The displayed result will be 3.28.

How to round with ODD and EVEN . functions

ODD . function

The ODD function is used to round up to the nearest odd integer, away from 0 (zero).

For example, =ODD(3.275) means rounding the number 3.275 up to the nearest odd integer. The displayed result will be 5.

When using the ODD function, regardless of the sign of the number, the value is always rounded up according to the principle away from zero (zero). If the number is an odd integer, no rounding will occur.

For example, =ODD(-3.275) means rounding -3.275 up to the nearest odd integer. The displayed result will be -5.

EVEN . function

The EVEN function is used to round up to the nearest even integer, away from zero (zero).

For example, =EVEN(3.275) means rounding the number 3.275 up to the nearest even integer. The displayed result will be 4.

Similarly, when using the EVEN function, regardless of the sign of the number, the value is always rounded up according to the principle away from zero (zero). If the number is an even integer, no rounding will occur.

The article has shown you 5 ways to round numbers in Excel in the most detail. Hope you are succesful.