[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
TRUNC ( x [ , number-digits ] )
Description: Truncates x to the number of fractional digits by number-digits.
Arguments:
|
Name |
Type |
Description |
|
array, reference |
The value to be rounded down. | |
|
number-digits |
number |
The number of fractional digits to which x is to be truncated. The default value for number-digits is 0. |
Return Type and Value: number – The truncated value of x.
[Example:
TRUNC(PI()) results in 3
TRUNC(PI(),1) results in 3.1
TRUNC(PI(),3) results in 3.141
TRUNC(PI(),5) results in 3.14159
end example]