How to round numbers in Excel extremely simple. However, in practice, many people do not know or have forgotten how to do it. So let Blog Thiên Minh We guide you and don’t forget to apply it to make it easier how to round numbers when using excel.

How to round an Excel number using the ROUND function.

With this way of rounding a number to the nearest number, you are also using the ROUND function. You must do this with the following syntax: =ROUND(number, num_digits). Where, number is the number you want to round. Num_digits is the number of decimal places you need to round.

Use the ROUND function to round a number to the nearest number

How to round numbers in Excel by ROUNUP. function

Use the ROUND function to round numbers

In Excel, the function for rounding numbers is the ROUNDUP function. As a result, you can completely use it to round numbers in Excel.

With this implementation it is extremely simple. You take the number to round and follow the syntax: =ROUND(number to round, number_digits). Where number is the number you need to round and numbere_digits is the decimal number you need to round.

How to round numbers in Excel using the ROUNDDOWN function.

Use the ROUNDDOWN function to round numbers down

Besides the function to reduce the number, you can fully use the function to round the number down. The way to do this is very simple. You must do the following:
Implementation syntax: =ROUNDDOWN(number, num_digits). Where, number is the number you need to round up. Num_digits is the decimal number after the decimal that you should round to 0.

How to round numbers by adding number formatting

The next way to round numbers in Excel that we want to suggest to you is the method of rounding numbers by adding number formats. It is extremely simple to do. At the same time, also for high precision. Therefore, if you need to round numbers in Excel, please follow these steps:

Step 1: You select the cell to round the number to and select General Right from the toolbar.

Select the number to round and select general

2nd step: Select other number formats or add a number format. Then you choose the appropriate format for rounding in step 2 above.

Select the format value to round the number

Step 3: You enter the decimal you need to display at the decimal. You can choose to decrease decimal to decrease decimals or choose to increase decimal to increase decimals.

You choose to increase or decrease to round the number of decimal places you need to perform

Round numbers in Excel with FLOOR and CEILING function.

The FLOOR function and the CEILING function are similar to MROUND. Both of these functions round to the nearest multiple of the number you need to round. However, for the FLOOR function, it will help the number you want to round to 0. Meanwhile, the CEILING function will round the number from zero.

• For the FLOOR function the syntax is: =FLOOR(number, meaning)

Use FLOOR function to round numbers in Excel

• For the CEILING function, the syntax is: = CEILING(Number to round, meaning)

Using CEILING function to round numbers in Excel

Where, the meaning is the number of decimal places to round. The number is the number you need to round up.

How to round numbers in Excel with ODD and EVEN functions.

You can use ODD and EVEN functions to round numbers in Excel. It is very simple to do as follows:

For ODD function.

The ODD function is used to round a number to the nearest odd integer and away from zero. The syntax is: =ODD(number). Wherein, the number is the number you need to round up.

Use ODD function to round numbers in Excel

Note when using the ODD function: If the number is an odd integer, you do not need to round. Whether the number you need to round is negative or positive, it will be rounded according to the rule starting from zero.

For the PAIR function

This function is used to round to the nearest even integer but must be far from 0. The syntax is implemented as follows: =EVEN(number). Where, number is the number you need to round up.

Use EVEN function to round numbers in Excel

With the EVEN function, if the number you need to round is an even integer, the value will be kept. At the same time, with positive or negative numbers, the same rules are followed.

here are the how to round numbers in excel The simplest thing you should do now. Certainly, when applying these implementations, you will get high rounding efficiency.