RNDPENNY(number)

 

Numerical Function Returns Numerical Value
Returns the value of a number and rounds to the nearest penny.

Examples:

RNDPENNY(100.444 + 77.333)

Returns 177.78 (100.444 + 77.333 = 177.777 = 177.78)

Note: Use the FMT$( ) function to convert a RNDPENNY( ) value to a string. The STR$( ) function will not return the value in the desired format.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)