XRND Function
The XRND function is useful when cross-referencing worksheets to determine if the values being linked from another CaseView document were rounded using CaseView's rounding feature.
Syntax
XRND("document identifier")
"Document identifier" is the identifier specified in the document properties. It can be up to eight characters long.
Example
XRND("FS")
where FS represents the CaseView document identifier. This function returns a value of 0, 1, 2, or 3 depending on the rounding criteria specified in the FS document.
|
Value |
What it represents |
|
0 |
Indicates that rounding is not activated for the specified document. |
|
1 |
Indicates that rounding to ones is activated. |
|
2 |
Indicates that rounding to thousands is activated. |
|
3 |
Indicates that rounding to millions is activated. |
