EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel Excel ROUNDDOWN Function
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

Excel ROUNDDOWN Function

By Pradeep SPradeep S

ROUNDDOWN in Excel

ROUNDDOWN Function in Excel (Table of Contents)

  • ROUNDDOWN in Excel
  • ROUNDDOWN Formula in Excel
  • How to Use the ROUNDDOWN Function in Excel?

ROUNDDOWN in Excel

Rounddown function in excel rounds off the decimal number, but it also allows us to eliminate the complete digits after the selected number and replaces those numbers after decimal with Zeros. For example, if we have a number with 4 decimal digits and we select 2 in place of num_digit then after 2 digits of decimal we will be having 00 till the last decimal digit that number has.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,858 ratings)

ROUNDDOWN Step 1

ROUNDDOWN Formula in Excel:

Below is the ROUNDDOWN Formula:

ROUNDDOWN Formula in Excel

The ROUNDDOWN function syntax or formula has the below-mentioned arguments:

number: It is the number that you want to round down. It is a compulsory & required argument.

It can be entered as a cell reference, number, function or formula.

num_digits: It is the number of digits to which number should be rounded down

or

We have to specify how many units (decimal places) you want to round it to

Prior to applying the round down function, you should be aware of how to determine the number of digits? Suppose I have a number 950.134

           9                  5                   0            .         1                   3                      4

Hundreds Tens ones  Tenth  Hundredth Thousandth

Place value towards Left-hand side data is called as ones, tens & hundreds. Whereas place value after a decimal point, i.e. towards the right is called Tenth, Hundredth & Thousandth.

How to Use ROUNDDOWN Function in Excel?

ROUNDDOWN Function is very simple to use. Let us now see how to use the ROUNDDOWN function in Excel with the help of some examples.

You can download this ROUNDDOWN Function Excel Template here – ROUNDDOWN Function Excel Template

Example #1

Round down a number to zero decimal place

In the below-mentioned example, Cell “B9” contains a number with decimal values. i.e. 984.5395, With the help of the ROUNDDOWN function, I need to round down a number to zero decimal value in the cell “C9.”

ROUNDDOWN Example 1-1

Let’s apply the ROUNDDOWN function in cell “C9”. Select the cell “C9” where the ROUNDDOWN function needs to be applied.

ROUNDDOWN Example 1-2

Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “ROUNDDOWN” in the search for a function box, a ROUNDDOWN function will appear in select a function box. Double click on a ROUNDDOWN function.

ROUNDDOWN Example 1-3

A dialog box appears where arguments for the ROUNDDOWN function needs to be filled or entered

, i.e. =ROUNDDOWN(number, num_digits)

number: It is the number that I want to round down. Here either 984.5395 or B9 cell reference is entered to get the desired output. Here I mentioned the reference cell, i.e. “B9.”

num_digits: I want the number with zero decimal value. I have to enter “0”, or it can be left blank. Note: by default, if we don’t enter any value. it takes zero

ROUNDDOWN Example 1-4

Click ok after entering both the arguments.

ROUNDDOWN Example 1-5

Here =ROUNDDOWN(B9,0) formula results in or Rounds 984.5395 down to a number with zero decimal value, i.e. 984

ROUNDDOWN Example 1-6

Example #2

Round down a number to two decimal places

In the below-mentioned example, Cell “G9” contains a number with decimal values. i.e. 984.5395, With the help of the ROUNDDOWN function, I need to round down a number to two decimal value in the cell “H9.”

ROUNDDOWN Example 2-1

Let’s apply the ROUNDDOWN function in cell “H9”. Select the cell “H9” where a ROUNDDOWN function needs to be applied.

ROUNDDOWN Example 2-2

Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “ROUNDDOWN” in the search for a function box, a ROUNDDOWN function will appear in select a function box. Double click on a ROUNDDOWN function

ROUNDDOWN Example 2-3

A dialog box appears where arguments for the ROUNDDOWN function needs to be filled or entered

i.e. =ROUNDDOWN(number, num_digits)

number: It is the number that I want to round down. Here either 984.5395 or G9 cell reference is entered to get the desired output. Here I mentioned the reference cell i.e. “G9”

num_digits: I want the number with two decimal values. I have to enter “2”

ROUNDDOWN Example 2-4

Click ok after entering both the arguments.

ROUNDDOWN Example 2-5

Here =ROUNDDOWN(G9,2) formula results in or Rounds 984.5395 down to a number with two decimal value, i.e. 984.53

 ROUNDDOWN Example 2-6

Example #3

For a Negative value or Dataset

In the below-mentioned example, Cell “B16” contains a negative number with decimal values. i.e. -984.5395, With the help of the ROUNDDOWN function, I need to round down a number to the nearest integer in the cell “C16.”

Example 3-1

Let’s apply the ROUNDDOWN function in cell “C16”. Select the cell “C16”. where a ROUNDDOWN function needs to be applied.

Example 3-2

Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “ROUNDDOWN” in the search for a function box, a ROUNDDOWN function will appear in select a function box. Double click on a ROUNDDOWN function.

Example 3-3

A dialog box appears where arguments for the ROUNDDOWN function needs to be filled or entered

, i.e. =ROUNDDOWN(number, num_digits)

number: It is the number that I want to round down. Here either -984.5395 or B16 cell reference is entered to get the desired output. Here I mentioned the reference cell, i.e. “B16.”

num_digits: I have to enter “-2” I want the number rounded down to the left side of the decimal point

Example 3-4

Click ok after entering both the arguments.

 Example 3-5

Here =ROUNDDOWN(B16,-2) formula results in or Remove all the decimals in -984.5395 and rounds integer down to the nearest hundred, i.e. -900

Example 3-6

Things to Remember

A ROUNDDOWN function can round either to the right or left side of the decimal point.

  • If the num_digits argument is greater than 0, Then it results in, or number is rounded down to the specified number of decimal places to the right of the decimal point.

E.G. =ROUNDDOWN(984.5395,2) returns the value 984.53

  • If a num_digits argument is equal to 0, Then it results in, or number is rounded down to the nearest integer

E.G. =ROUNDDOWN(984.5395,0) returns the value 984

  • If a num_digits argument is lesser than 0, Then it results in, or number is rounded down to the left side of the decimal point (i.e. to the nearest 10, 100, 1000, etc.).

E.G. =ROUNDDOWN(-984.5395,-2) returns the value -900

Recommended Articles

This has been a guide to Excel ROUNDDOWN function. Here we discuss the ROUNDDOWN Formula and how to use the ROUNDDOWN function in Excel, along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Excel ROUNDUP Function
  2. MROUND in Excel
  3. ROUND Formula in Excel
  4. Excel Rounding
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download ROUNDDOWN Function Excel Template

EDUCBA

Download ROUNDDOWN Function Excel Template

EDUCBA

डाउनलोड ROUNDDOWN Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more