How to use the ‘Round’ Numbers Function in Excel | Quick Tutorial

Microsoft Excel allows you to manage spreadsheets, make tables and use them correctly, as well as include formulas with functions to make calculations quickly. In this sense, it is important that you know how use the ‘Round’ function numbers in Excel through this quick tutorial that we show you below.

What ways to use the ‘Round’ function in Excel from a computer?

There are several ways to use the ‘Round’ function in Excel from a computer such as entering the function or just using the ‘Round’ function and selecting by using the formula bar. You can even use other more complex formulas to round specific numbers precisely.

Entering the function =ROUND

The ROUND function allows you to round a number to a higher or lower decimal value according to the predecessor of that number. Therefore, the number entered in decimals reflects to how many decimal places after the comma the Excel application should round.

it’s possible round numbers by entering the function =ROUND in Excel. For this, you must take into account two parameters: the number you want to round and the number of decimals in order to perform the calculation in a cell. In this sense, you must go to a specific cell, type =ROUND (number; num_decimals) and press ‘Enter’.

Just using =ROUND and select

You can also round a number in Excel just by using =ROUND and select the cell that contains the value using the formula wizard that the application provides. This procedure is usually very useful because it speeds up the task of inserting values ​​without the need to write any parameters.

What to do to round by selecting the Fx option in the Excel toolbar?

What you must do to round by selecting the Fx option in the toolbar of Excel is to click on the ‘fx’ icon located above the spreadsheet. And type round in the search bar. Double click ‘Round’, select the cell to extract the number in field A1 and the decimal number for field A2.

Next, press the ‘OK’ button and the result of rounding the number will be displayed immediately in Excel. Notice that the parameters are displayed in the formula bar and you can override them directly or do dynamic value references that contain other cells on the same worksheet.

What are the rounding functions that Excel offers?

Microsoft Excel also offers other specific functions to be able to round a number such as round.up, round.down, automatic rounding or round.odd. These functions will be very useful for handling large amounts of data. numeric values ​​in a spreadsheet.

Round Up, Round Down, and Auto Round

The round.plus function allows increase the figure to the next whole unit. This function requires two parameters: the decimal number and how many decimal places after the comma to round off. Therefore, if we write the expression =ROUND.UP (4,32, 0) the value 5 will be displayed rounding to zero decimal places.

For its part, the function round.less is used to round down a specific number pointing to 0. The syntax of this function includes the number that you want to round and the number of decimals to round the number down. If you enter the formula =ROUND. MINUS (2,3, 0) will return the value 2.

For avoid errors when rounding figures you can use automatic rounding via the ‘Precision’ option. For this, click on ‘File’ and select ‘Options’. Go to ‘Advanced’ and check the ‘Set Display Precision’ box and press ‘OK’. Apply the format to put the digits or zeros and assign the number of decimals to the cells.

Round.even and Round.odd

Another function you can use to round a number in excel is round.par. This function allows you to obtain the upper even integer of a number using the expression =ROUND.EVEN (number). In this regard, if you write the formula =ROUND.EVEN (35) the value 36 will be displayed.

Another function to round numerical values ​​in Excel is round.odd. This function allows you to round a number to the nearest odd integer. so yes go to the formula bar the expression =ROUND.ODD (5,60) you will get the value 9. It is important to note that if the number is an odd integer, it cannot be rounded.