| Round Function |
Syntax
Round(expression[, numdecimalplaces])
Round(number,precision)
expression
Use: Required
Data Type: Numeric Expression
Any numeric expression.
numdecimalplaces
Use: Optional
Data Type: Long
The number of places to include after the decimal point.
Return Value
The same data type as expression.
Description
Rounds a given number to a specified number of decimal places.
Rules at a Glance
numdecimalplaces can be any whole number between and 16.
Round follows standard rules for rounding. That is, if the digit in the position to the right of numdecimalplaces is 6 or greater, the digit in the numdecimalplaces position is incremented by 1; if 5, it becomes the nearest even number; otherwise, the digits to the right of numdecimalplaces are dropped.
Programming Tips and Gotchas
Round with a numdecimalplaces set to 2 is equivalent to Format (expression, "#.##").
If expression is a string representation of a numeric value, Round converts it to a numeric value before rounding. However, if expression isn't a string representation of a number, Round generates runtime error 13, "Type mismatch." The IsNumeric function insures that expression is a proper numeric representation before calling Round.
If expression contains fewer decimal places than numdecimalplaces, Round doesn't pad the return value with trailing zeros.
See Also
- Fix Function, Int Function
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access