Our Formula Function Reference
Formula Function Reference
Round - Rounding and Truncating
(Number x, Number y)
Returns the multiple of y which is nearest to x.
You may notice small discrepancies when you use this function with floating point numbers. For example, Round(37.785,0.01) returns 37.78 instead of 37.79. This is not a QuickBase-specific issue; the discrepancies happen because some floating point numbers cannot be represented exactly in the binary format required by computers and are instead approximated.
Round(3.12345, .01) returns 3.12 Round(3.6, 2) returns 4 Round(-3.6, 2) returns -4