You are here: Features > Cell Functions > Text 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.

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.

Related Topics