Round
 
Purpose 
Returns a number rounded to the specified precision (number of decimal places).
Format 
Round(number;precision)
Parameters 
number - any numeric expression or field containing a numeric expression
precision - any numeric expression or field containing a numeric expression
Data type returned 
number
Originated in 
FileMaker Pro 6.0 or earlier
Description 
If you round a negative number of decimal places, all digits to the right of the decimal point are dropped, and the number is rounded to the nearest tens, hundreds, and so on. The Round function always rounds up at 0.5.
Examples 
Round(123.456;2) returns 123.46.
Round(14.5;0) returns 15.
Round(29343.98;-3) returns 29000.
Round(123.456;-1) returns 120.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas