Have you ever had to round down a number in Excel for a large dataset manually? What if we told you that there is an Excel function to make it easier? It is called the rounddown function in Excel. So, without further ado, let’s take a look at how you can create round downs in your spreadsheets using the Rounddown function.
The ROUNDDOWN function in Excel rounds a number down to a specific number of decimal places, taking it down to the next valid increment.
Article source: https://www.basictutorials.in/rounddown-function-in-excel.php