ROUND()
Syntax. ROUND(number,num_digits)
Definition. This function rounds a number to a specified number of decimal places.
Arguments
number (required) The number you want to round
num_digits (required) The number of decimal places to which you want to round a number
Background. For our number system, rounding is unavoidable. Most number values are rounded at some point. There are many reasons to round numbers: Large numbers are clearer and can be more easily calculated, such as for demographic statistics or pi (π). Also, (almost) all prices are rounded to two decimal places because the smallest unit for money amounts is one cent.
If the number after the number to be rounded is greater than 4, the number is rounded up. If this number is smaller than ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
