[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
+---------------------------------+
|              ROUND              |
+---------------------------------+
ROUND(<expN1>, <expN2>)

-----------------------------------
Rounds numeric expression to specified number of decimal places.
Return value - Numeric
-----------------------------------

<expN1>
        Numeric expression to be rounded.

<expN2>
        Number of decimals places to round <expN1> to.

If <expN2> is negative, the rounded number returned is a whole number
containing <expN2> trailing zeros.  For instance, if <expN2> is -2, the
result is rounded to even hundreds.

+---------------------------------+
|             Examples            |
+---------------------------------+
? ROUND(1234.1962, 3)

? ROUND(1234.1962, 2)

? ROUND(1234.1962, 0)

? ROUND(1234.1962, -1)

? ROUND(1234.1962, -2)

? ROUND(1234.1962, -3)

-----------------------------------

See Also:  INT(), SET DECIMALS

-----------------------------------

See Also: INT() SET DECIMALS
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson