This article explains how to round numbers down in Excel using the ROUNDDOWN function.
How to Round DOWN in Excel
The ROUNDDOWN function is used to decrease a value by a specific number of decimal places or digits. It keeps the rounding digit the same, changes the value of the data in the cell, and rounds toward zero.
The syntax for the ROUNDDOWN function is
= ROUNDDOWN (Number, Number_of_digits)