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
ow to use ROUND Function in Excel?
  • 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
ow to use ROUND Function in Excel?
  • 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.
ow to use ROUND Function in Excel?

Additional Points

  • 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.