Short tutorial on rounding numbers in spreadsheet program. Learn here how to round a number in Excel.
Rounding a decimal number is not a big task but it really needs lot of patience when working with bulk data. Rounding numbers is made quite easier and simpler with the spreadsheet application. You can round a numbers in excel at no time using a ROUND function. Follow our simple step by step tutorial to learn how to round a numbers in excel / spreadsheet program.
Use ROUND function to round a number. The function uses two arguments.
First argument is number to be rounded or its cell reference
Second is the number of digits to be rounded..
The syntax is
=ROUND(number, number_digits)
You can use ROUND function for rounding numbers in three ways.
Formula | Description |
=ROUND(number) | Rounds to Zero Decimal Places |
=ROUND(number, positive_number_digits) | Rounds to the Nearest Decimal Values we Mention |
=ROUND(number, negative_number_digits) | Rounds to nearest 10 Decimal Places (-1= 10s, -2 = 100s, -3=1000s) |