Reply to comment

Arguments: 

(Number x, Number y)

Result Type: 

Number

Explanation: 

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.

Example: 

Round(3.12345, .01) returns 3.12 Round(3.6, 2) returns 4 Round(-3.6, 2) returns -4

Tags:

Reply

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit