[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ROUND ( x , number-digits )
Description: Rounds x to the number of digits specified by number-digits.
Arguments:
|
Name |
Type |
Description |
|
number |
The value to be rounded. | |
|
number-digits |
number |
The number of digits to which x is to be rounded. If number-digits is greater than 0, x is rounded to the specified number of decimal places. If number-digits is 0, x is rounded to the nearest integer. If number-digits is less than 0, x is rounded to the left of the decimal point. |
Return Type and Value: number – The rounded-down value of x.
[Example:
ROUND(2.15,1) results in 2.2
ROUND(2.149,1) results in 2.1
ROUND(-1.475,2) results in -1.48
ROUND(21.5,-1) results in 20
end example]