How to round numbers in Excel extremely simple. However, in reality, many people don’t know or have forgotten how to do this. So let’s go Blog Thien Minh We guide you and don’t forget to put it into practice to make it easier How to round numbers with Excel.

How to Round Excel Numbers Using the ROUND Function

With this way of rounding a number to the nearest number, you also use the ROUND function. You must follow this 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 the number to the nearest number

How to Round Numbers in Excel Using the ROUNUP Function

Use the ROUNDUP function to round numbers

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

This method is extremely simple. Take the number to round and follow the syntax: =ROUNDUP(number to round, number_digits). Where, number is the number you need to round and number_digits is the number of decimal places you need to round.

How to Round Numbers in Excel Using the ROUNDDOWN Function

Use the ROUNDDOWN function to round the number down

In addition to the function to round numbers, you can also use the function to round numbers. The method is extremely simple. You must do the following:
Implementation syntax: =ROUNDDOWN(number, num_digits). In which number is the number you need to round. Num_digits is the decimal number after the decimal point that you must round to zero.

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 formatting. This method is extremely simple. At the same time, it also offers 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 and select General on the right in the toolbar.

Select the number to round and select general

2nd step: Select more number formats or add a number format. Next, choose the appropriate format for rounding in step 2 above.

Select the format value to round the number

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

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

Round numbers in Excel with the FLOOR function and CEILING function

The FLOOR and CEILING functions are similar to MROUND. Both of these functions round to the nearest multiple of the number you need to round. However, the FLOOR function will round the desired number to zero, while the CEILING function will round the number from zero.

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

Use the FLOOR Function to Round Numbers in Excel

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

Use the CEILING function to round numbers in Excel

In which the meaning is the decimal number that must be rounded. The number is the number you need to round.

How to Round Numbers in Excel with the ODD and EVEN Functions

You can use the ODD and EVEN functions to round numbers in Excel. How to do this is extremely simple as follows:

For SDG function

The ODD function allows you to round a number to the nearest odd integer away from 0. The syntax is as follows: =ODD(number). In which number is the number you need to round.

Use the 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 allows you to round to the nearest even integer but far from 0. The syntax is as follows: =EVEN(number). In which number is the number you need to round.

Use the 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 remain the same. At the same time, the same rules apply to positive or negative numbers.

Above are the How to round numbers in Excel The simplest thing you should do right away. Certainly, by applying these methods, you will achieve high rounding efficiency.