In this tutorial we will learn how to use the ROUNDDOWN function in Microsoft Excel. The ROUNDDOWN function differs from the standard ROUND function in that it rounds a number down rather than up. For example, if a number 2.95 is given as an argument to both the ROUND and ROUNDDOWN functions, the ROUND function will return 3, while the ROUNDDOWN function will return 2.9.
Microsoft Excel is a powerful spreadsheet software developed by Microsoft Corporation and is part of the Microsoft Office suite. It is widely used for data analysis, data management, and data presentation. Excel provides a user-friendly interface with a variety of features and tools that allow users to manipulate and analyze data with ease. It includes built-in functions and formulas for mathematical and statistical calculations, pivot tables for data summaries and grouping, and chart creation tools for visual representation of data.
Step 1 – Select a Blank Cell
– Select a targeted Blank cell where you want to ROUND DOWN a number.
Step 2 – Place an Equals Sign
– Place an Equals sign in the targeted blank cell.
Step 3 – Use the ROUNDDOWN function
– The syntax of ROUNDDOWN function is
ROUNDDOWN(A2,2)
– Where the first argument i.e. A2 is the cell containing the number to be rounded.
– The second argument i.e. 2 is an optional argument that specifies the number of decimal places to round down to.
Step 4 – Press the Enter Key and Apply the ROUNDDOWN function to Each Row
– Press the Enter key to get the results.
– Use the “handle select” and “ drag and drop” method and apply the ROUNDDOWN function to each row.
Step 5 – Comparing ROUNDDOWN function with ROUND function
– By comparing the outputs of both the ROUNDDOWN function and the ROUND function we can conclude that the ROUNDDOWN is an opposite function to the ROUND function.