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 to use the function of ‘Round’ numbers in Excel through this quick tutorial that we show you below.
Index( )
- What ways to use the ‘Round’ function in Excel from a computer?
- Entering the function =ROUND
- Just using =ROUND and select
- What to do to round by selecting the Fx option in the Excel toolbar?
- What are the rounding functions that Excel offers?
- Round Up, Round Down, and Auto Round
- even and Round.odd
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 how many decimal places after the comma the Excel application should round to.
It is possible to round numbers by entering the =ROUND function 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 selecting the cell that contains the value through the formula wizard provided by the application. 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 need to do to round by selecting the Fx option on the Excel toolbar 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. Note that the parameters are displayed in the formula bar and you can directly replace them or dynamically reference values that are contained in other cells on the same spreadsheet.
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 numerical values in a spreadsheet .
Round Up, Round Down, and Auto Round
The round.plus function allows you to 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 decimal places to round the number down. If you enter the formula =ROUND. MINUS (2,3, 0) will return the value 2.
To avoid errors when rounding figures, you can use automatic rounding through 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.even. 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 if you enter the expression =ROUND.ODD (5.60) in the formula bar, you will get the value 9. It is important to note that if the number is an odd integer, it cannot be rounded.
