Rounds the number passed to the function to specified number of digits.
= ROUND(value, numberOfDigits)
Value |
A number which is to be rounded. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
numberOfDigits |
The number of places to which the number is to be rounded. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Decimal number.
In the case of an error, the function displays an error message: “ROUND(number, numberOfDigits): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= ROUND(-3.75, 1) |
-3.8 |
= ROUND(3.75, 0) |
4 |
= ROUND(“$3.74”, 1) |
3.7 |
= ROUND(UnitPrice, 1) |
The rounded value of UnitPrice upto 1 decimal place. |
= ROUND(“abcd”, “efg”) |
Displays message “ROUND(abcd, efg): Input string was not in a correct format.” |
= POWER(ROUND(UnitPrice), 2) |
The square of the round value of UnitPrice |
= MAX(ROUND(UnitPrice), 12) |
The maximum among the round value of UnitPrice and the number 12. |