Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelROUNDDOWN Function in Excel

# ROUNDDOWN Function in Excel

In this post, you will learn about the ROUNDDOWN Function in Excel, how to use it in â€“ with the excel spreadsheets.

This function is similar to the Round function, but this function rounds down the number to the given number of integers.

Syntax

`=ROUNDDOWN(number, num_digit)`

This syntax has two arguments

• number â€“ This holds the number to be round down
• num_digit â€“ This holds the number of digits that you want to round off the number.

## How does the ROUNDDOWN Function work?

• The function is mostly used when working with decimal numbers.
• To start with, enter the numbers and the value of the second argument in the excel sheet. In a new cell enter the syntax and highlight the cells to insert them in the syntax.
• Press enter to display the answer and use the fill handle to apply the function to the rest of the data.
• To round off the number towards the decimal point, use positive numbers in the num_digit argument. For example
=ROUND(a, 1)Â rounds up the number to 1 number after the decimal point
=ROUND(b, 2)Â rounds up the number to 2 numbers after the decimal point
• Negative numbers are used in the num_digit argument to round down the number towards a whole number. For example
=ROUND(a, -1)Â rounds up the number to the nearest 10.
=ROUND(b, -2)rounds up the number to the nearest 100.

• The syntax does not accept non â€“ numeric values and returns an error.
• This function is one of the differentÂ RoundingÂ functions in Excel.
• If the number is already round off the function does not take place.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021