Formulas > =ROUNDDOWN()
How to Use ROUNDDOWN() in Google Sheets
Description
How To Actually Use ROUNDDOWN() in Sheets
ROUNDDOWN(value, [places])
Try ROUNDDOWN yourself
Use the ROUNDDOWN formula to round down the numbers in the range A1:A10 to 1 decimal place. Place your formula in cell B1.
Hints (2)
-
Remember to specify the number of decimal places you want to round down to.
-
Think about how to apply the formula to an entire range.
1 Better Sheets Tutorial
Create an Email Campaign Stats Calculator
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.
CONCATENATE()
ROUNDDOWN()
UPPER()
Learn more about the ROUNDDOWN() formula:
Generate a ROUNDDOWN() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses ROUNDDOWN(). 2 free AI generations, no signup. Members get unlimited use.
Generate a ROUNDDOWN() formula