How to Round Down – ROUNDDOWN Function – Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 9, 2023

Download Example Workbook

Download the example workbook

This tutorial demonstrates how to use the Excel ROUNDDOWN Function in Excel, Google Sheets, and VBA to round a number down.

ROUNDDOWN Formula Main

How to use the ROUNDDOWN Function

The ROUNDDOWN Function Rounds a number down (towards zero) to a specified number of digits.

Round down to Nearest Whole Number

To round down to the nearest whole number set the num_digits argument to 0.

=ROUNDDOWN(A2,0)

Rounddown Whole Number

Round down to Two Decimal Places

To round down to two decimal places, set the num_digits argument to 2. Here we will round down a price to the nearest cent:

=ROUNDDOWN(A2,2)

Rounddown Two Decimal

Round down to Nearest 10, 100, or 1000

To round down to the other side of the decimal (to 10, 100, or 1000s), use negative numbers for num_digits:

=ROUNDDOWN(A2,-1)
=ROUNDDOWN(A2,-2)
=ROUNDDOWN(A2,-3)

Rounddown 10 100 1000

Round down Percentages

When rounding down percentages remember that percentages are decimal values. So to round down to the nearest whole percentage use the ROUNDDOWN Function with num_digits = 2.

=ROUNDDOWN(A2,2)

Percentage RoundDown

Other ROUND Functions / Formulas

Excel / Google Sheets contains many other round functions. Here are quick examples of each:

Other ROUND Formulas

Read our tutorials to learn more:

Excel Date Functions
Round Formulas Mega-Guide	yes
ROUND - Round Numbers
ROUNDUP - Round Numbers Up
ROUNDDOWN - Round Numbers Down
MROUND - Round to Multiple
CEILING - Round Up to Multiple
FLOOR - Round Down to Multiple
TRUNC - Trim off Decimal
INT - Get Integer Portion of Number

Below, we will point out a few functions in particular.

ROUND and ROUNDUP

The ROUND and ROUNDUP Functions work exactly the same way as the ROUNDDOWN Function, except the ROUND Function uses normal rounding rules and ROUNDUP always rounds up.

=ROUND(A2,-2)
=ROUNDUP(A2,-2)

Round up down

ROUND down to a Multiple

The FLOOR Function is similar to the ROUNDDOWN Function. It will round a number down, but the FLOOR Function allows you to round down to a specific multiple (instead of rounding to a specific number of digits).

=FLOOR(A2,B2)

Rounddown FLOOR

ROUNDDOWN in Google Sheets

The ROUNDDOWN Function works exactly the same in Google Sheets as in Excel:

ROUNDOWN Google

ROUNDDOWN Examples in VBA

You can also use the ROUNDDOWN function in VBA. Type:

application.worksheetfunction.rounddown(number,num_digits)

Executing the following VBA statements

Range("C2") = Application.WorksheetFunction.RoundDown(Range("A2"), Range("B2"))
Range("C3") = Application.WorksheetFunction.RoundDown(Range("A3"), Range("B3"))
Range("C4") = Application.WorksheetFunction.RoundDown(Range("A4"), Range("B4"))
Range("C5") = Application.WorksheetFunction.RoundDown(Range("A5"), Range("B5"))
Range("C6") = Application.WorksheetFunction.RoundDown(Range("A6"), Range("B6"))

will produce the following results

Vba ROUNDDOWN function

For the function arguments (number, etc.), you can either enter them directly into the function, or define variables to use instead.