You are here: All Help Topics > Other Information > Cell Functions > XRND function

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.

XRND("document identifier")

"Document identifier" is the identifier specified in the document properties. It can be up to eight characters long.

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.

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.

Related Topics