Rounddown Function in Excel

Prepare to enhance your precision in Excel! The ROUNDDOWN function is your key to precise numerical manipulation. In this brief guide, we'll provide valuable insights and expert advice on mastering the ROUNDDOWN function. Learn efficient techniques for rounding down numbers, ensuring accuracy in your calculations. Join us as we uncover the secrets to optimizing your Excel formulas with this essential tool.

The ROUNDDOWN function in Excel is designed to round a number down to a specified number of digits. In this guide, we'll walk you through using the ROUNDDOWN function, offering tips and error handling methods along the way. Whether you're a seasoned Excel user or just getting started, mastering the ROUNDDOWN function can significantly enhance your data precision and streamline your spreadsheet tasks.

---

Supported versions

• All versions

---

Syntax

---

Arguments

number	The number to be rounded.
[num_digits]	The number of digits.

---

Examples

Firstly a reminder: Named ranges are added to ease of reading formulas.

Rounddown Function in Excel Example 1

formula returns 314.16; because when num_digits is greater than 0, then number is rounded down to the specified number of decimal places.

Rounddown Function in Excel Example 2

formula returns 315; because when num_digits is equal to 0, then number is rounded down to the nearest integer.

Rounddown Function in Excel Example 3

formula returns 400; because when num_digits is less than 0, the number is rounded down to the left of the decimal point.

Download Workbook

---

Tips

• Unlike generic rounding the ROUNDDOWN function rounds all numbers 1 to 9 down.
• Use the ROUND for standard rounding.
• Use the ROUNDUP to always round up.