ROUNDDOWN Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

ROUNDDOWN is an Excel Math & Trig function. Always rounds a number down, toward zero.

ROUNDDOWN syntax

=ROUNDDOWN(number, num_digits)

ROUNDDOWN is used in financial models and engineering-style calculations where precise numeric work is needed.

Open the live Excel-style spreadsheet and try ROUNDDOWN yourself. No Excel install or sign-up needed to start.

What does the ROUNDDOWN function do in Excel?

Always rounds a number down, toward zero.

What is the syntax of ROUNDDOWN in Excel?

The syntax is =ROUNDDOWN(number, num_digits). number: A number to use in the calculation; num_digits: How many decimal places to round to.

Where can I practice ROUNDDOWN online for free?

Open the free live spreadsheet on Cellgrids and try ROUNDDOWN yourself. No Excel install is needed and you can start without signing up.