[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ROUNDDOWN ( x , number-digits )
Description: Computes x rounded down, toward zero, to the number of digits specified by number-digits. [Note: ROUNDDOWN behaves like ROUND (§3.17.7.275), except that ROUNDDOWN always rounds a number down. end note]
Arguments:
|
Name |
Type |
Description |
|
number |
The value to be rounded down. | |
|
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:
ROUNDDOWN(3.2,0) rounds 3.2 down to zero decimal places; that is, to 3
ROUNDDOWN(76.9,0) rounds 76.9 down to zero decimal places; that is, to 76
ROUNDDOWN(3.14159,3) rounds 3.14159 down to three decimal places; that is, to 3.141
ROUNDDOWN(-3.14159,1) rounds -3.14159 down to one decimal place; that is, to -3.1
ROUNDDOWN(31415.92654,-2) rounds 31415.92654 down to two decimal places to the left of the decimal; that is, to 31400
end example]