- Summary. The Excel ROUNDDOWN function returns a number rounded down to a given number of places. …
- Round down to given number of digits.
- A rounded number.
- =ROUNDDOWN (number, num_digits)
- number – The number to round down. num_digits – The place at which number should be rounded.
This article focuses on using Microsoft Excel’s ROUNDDOWN formula. The function returns the number that was entered, rounded to the specified number of places. What makes it useful is its unique properties. Because this function rounds all numbers downward, it differs from standard rounding.
How to ROUND DOWN in Excel
How to round down in Excel
Here are steps to follow to round down in Excel:
1. Locate your data
Find the numbers you want to round down. Find the cells where the data is if they are a part of the spreadsheet’s existing data so you can quickly locate them for the formula. Make sure you have the numbers handy for quick reference if you intend to manually enter the formula.
2. Decide on a digit
The number you choose will depend on how precise a result you require. Use 0 as your digit because it rounds to the nearest integer if you need a precise value but no decimals. It may be more useful to use -1 or -2 to round down to the nearest ten or hundred if your data has values in the hundreds or thousands and you don’t need a precise value.
Here are the most common digits and what they do:
3. Enter the formula
By typing the function into the cell and pressing the “enter” key on your keyboard, you can enter the formula. For example, type =ROUNDDOWN(A4,0) into cell D12. The “fx” button next to the data entry line near the top of the page is another choice. Then, enter the number and digit in the dialog box that appears, select ROUNDDOWN from a list of functions, and press “OK.” “.
4. Save your spreadsheet
To avoid losing your progress, it’s crucial to regularly save your spreadsheet after making changes. By simultaneously pressing the “ctrl” and “S” keys on your keyboard, you can use a keyboard shortcut to save your spreadsheet. Another choice is to choose “File” in the window’s upper left corner, then “Save” or “Save As” if you want to change the name of the Excel file.
What is the ROUNDDOWN function in Excel?
Depending on your needs, you may round numbers in Excel using a variety of functions, including ROUND for standard rounding, ROUNDUP for rounding up, and MROUND for rounding to the nearest multiple. A number is rounded down by ROUNDDOWN to the number of decimal places you specify, heading towards zero.
The ROUNDDOWN function is =ROUNDDOWN(number, digit). The function requires two pieces of information in order to function: a number and a digit. Here are explanations of each:
Number
The value you want rounded. This can be a number, like 136. 6853 or it may refer to information in another cell or formula on the worksheet, in which case you would use cell A2 or the formula A2+A5. The number goes first in the formula.
Digit
The number of decimal places to be rounded down is specified by the digit, or num_digit. The most common decimal places to round to are zero, one, two, or to remove decimals and round to the nearest ten or one hundred. The digit goes second in the formula.
Tips for rounding down in Excel
Here are some pointers for rounding down in Excel along with some additional helpful formulas:
INT function
The INT function displays only the integer portion of a rounded-down number. For example, INT(99. 99) would give the result 99. Negative numbers get worse with this function, so INT(-99) becomes more negative. 99) would give the result -100.
FLOOR function
Use the FLOOR function if you want to round down to a specific multiple. The formula for this function is =FLOOR(number,significance), where number is the value to round and significance is the multiple to use. For instance, use =FLOOR(128 if you want to round down to a multiple of three. 534,3) would give the result of 126.
Round down multiple numbers
You don’t need to enter the ROUNDDOWN function for each individual number if you want to round down several numbers using the same digit. Multiple numbers can be rounded down in a few easy steps. Please take note that rather than entering numbers individually, these steps call for referring to data that is already on the spreadsheet:
For instance, if you want to round down the numbers in cells A1 through A10 to the nearest tenth and you want those numbers to appear in the B column, you would first enter the function =ROUNDDOWN(A1,-1) in cell B1. After copying cell B1, selecting cells B2 through B10, and pasting The function in cell B2 would change to =ROUNDDOWN(A2,-1) if you copied and pasted it this way because it retains the digit but changes the referenced cell to the subsequent one in the column.
Round down time
You can use FLOOR or ROUNDDOWN to round down times in Excel that you track, such as clock-in and clock-out times. You can choose any option for the nearest minute, such as the nearest fifteen minutes, or round down to the nearest hour. The more straightforward choice is FLOOR, which has the function =FLOOR(value, TIME(hour, minute, second)).
Please be aware that the function is likely to return a number with too many decimal points if it is entered in a cell that is formatted as a number. Make sure the cell is formatted as time by selecting “Time” from the drop-down menu next to the “Conditional Formatting” button on the “Home” tab. If you had 3:27:32 entered in cell A1 to represent three hours, 27 minutes, and 32 seconds, here are a few examples of rounding down time with the FLOOR function:
Knowing what percentage of a day a number represents is necessary to use ROUNDDOWN for time, such as that one hour is 1/24th of a day and 15 minutes is 1/96th of a day. The function is =ROUNDOWN(value*portion,0)/portion. Using the same value as the FLOOR examples, the following examples are given:
Please note that Indeed is not affiliated with any of the businesses mentioned in this article.
FAQ
How do you round down numbers?
- Select the range that you want to round the numbers.
- Apply the tool by selecting Kutools > Round, and in the Round Without Formula dialog box, enter the decimal place digits and rounding option. See screenshot:
- Click Ok to apply the operation.
How do you round down a .5 in Excel?
- Round the number up if 5, 6, 7, 8, or 9 come after the number you’re rounding. Example: 38 rounded to the nearest ten is 40.
- Round the number down if the rounded number is followed by a 0, 1, 2, 3, or 4. Example: 33 rounded to the nearest ten is 30.
