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
You can use ROUND function for rounding numbers in three ways.
|=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)