Category: Number
Syntax: Round ( number; precision ) |
Parameters:
numberAny expression that resolves to a numeric value.
precisionAny number or numeric expression representing the number of decimal points to which to round the number.
Data type returned: Number
Description:
Returns the specified number rounded off to the number of decimal points specified by the precision parameter. The Round() function rounds numbers from 5 to 9 upward, and from 0 to 4 downward.
A precision of 0 rounds to the nearest integer. A negative number for the precision causes the number to be rounded to the nearest ten, hundred, thousand, and so on.
Examples:
Function | Results |
---|---|
Round (62.566; 2) | Returns 62.57. |
Round (62.563; 2) | Returns 62.56. |
Round (92.4; 0) | Returns 92. |
Round (32343.98; -3) | Returns 32000. |
Round (505.999; -1) | Returns 510. |
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
Calculation Signatures
Calculation Functions
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Scripting Primer
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information