• ANSI Character Functions
• CLNTDIR Function
• CLNTNAME Function
• CURRENCY Function
• DOCPATH Function
• IN Function
• LEFT Function
• LENGTH Function
• LOWER Function
• LTRIM Function
• MID Function
• MKSTR Function
• PRGDIR Function
• RIGHT Function
• SCANSTR Function
• SPACE Function
• STR Function
• SUBSTR Function
• Text Functions
• TITLE Function
• TOKEN Function
• TOKENSUB Function
• TRIM Function
• TRIMRTF Function
• UPPER Function
• XRND Function
• XWKS 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.

Related Topics

• Text Functions