ROUNDDOWN Function in Excel

Question

What is the ROUNDDOWN function in Excel?

Answer

The ROUNDDOWN function is used to round a number down towards the next lowest number.  ROUNDDOWN is similar to the ROUND function except that it always rounds a number downward while the ROUND function will round up or down depending on whether the last digit is greater than or less than 5. 


For example, the ROUND function would round the number 34.567 up to 34.6 because the second decimal place (6) is greater than 5. Since ROUNDDOWN doesn't care whether the second digit is greater or less than 5 it rounds the answer down to 34.5. 
 

The syntax for the ROUNDDOWN function is: = ROUNDDOWN ( Number, Num_digits )

  • Number - the value to be rounded.
  • Num_digits - the number of decimal places to reduce the above number to.  
     

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3

If you need further assistance, please click the CTL Support Request button on this page

CTL Support Request

Details

Article ID: 7934
Created
Thu 12/29/22 12:34 PM
Modified
Fri 11/3/23 3:56 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.