# ROUND Function in Excel

In this post you will learn about the ROUND Function in Excel, how to use it in your excel spreadsheets.

Syntax

`=ROUND(number, num_digits)`
• number – This holds the number to be round off.
• num_digit – This holds number of digits that you want to round off the number.

Both the arguments are required to perform this function

## How to use ROUND Function in Excel?

• The function rounds up the number to a given number of digits. The function can be used to round up the numbers before and after the decimal point.
• This function is usually used for decimal numbers.
• To start with enter the numbers and the second argument data in the excel sheet and in a new cell enter the syntax. Highlight the data to include them in the syntax
• Press enter to display the answer, and use the fill handle to apply the function on 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 off 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.