Formulas > =ROUNDDOWN()

How To Use ROUNDDOWN() Function in Google Sheets


Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

Common Questions about the ROUNDDOWN Formula:
1. When should I use the ROUNDDOWN formula?
2. What are the different arguments and parameters of the formula?
3. How do I enter the ROUNDDOWN formula in Google Sheets?

How can the ROUNDDOWN Formula be used appropriately:
The ROUNDDOWN formula is used to truncate, or round down, a given value to the next lowest whole number or specified degree of precision. This formula can be used to round down monetary values, percentages, whole numbers, and values outside of those parameters.

How can the ROUNDDOWN Formula be commonly mistyped:
The ROUNDDOWN formula can be easily mistyped if the user does not type the correct arguments and parameters for the formula. It is important to make sure the formula is typed in the correct syntax: ROUNDDOWN(number, [num_digits]). Some other common misspellings are RUNDOWN, RUNDDOWN, ROUNDOWN.

What are some common ways the ROUNDDOWN Formula is used inappropriately:
The ROUNDDOWN formula is commonly used inappropriately to round up numbers instead of down, or to include non-numeric characters in the formula arguments.

What are some common pitfalls when using the ROUNDDOWN Formula?
1. Not using the correct syntax when typing in the formula arguments or parameters.
2. Rounding non-numeric values.
3. Not entering the optional parameters properly.

What are common mistakes when using the ROUNDDOWN Formula?
1. Not paying attention to the order in which the arguments have been entered.
2. Not double-checking the output of the formula to ensure proper rounding has been applied.
3. Not increasing the precision level of the formula as needed for finer rounding.

What are common misconceptions people might have with the ROUNDDOWN Formula?
1. That it can be used to increase numbers instead of decreasing.
2. That it can be used to manipulate non-numeric values. 
3. That it can be used to round to a specific decimal place instead of to the nearest whole number.

How To Actually Use ROUNDDOWN() in Sheets

ROUNDDOWN(value, [places])

1Better Sheets Tutorial

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.

Learn more about the ROUNDDOWN() formula:

Rounding Functions

Discover rounding functions: round, roundup, and rounddown. Select the HD quality option for the best full-screen viewing experience. Visit for more videos and tutorials!

Generate a ROUNDDOWN() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.