Spread Formula Reference
Formula Functions / Functions R to S / ROUND
In This Topic
    ROUND
    In This Topic

    This function rounds the specified value to the nearest number, using the specified number of decimal places.

    Syntax

    ROUND(value,places)

    Arguments

    Use the value argument to specify the number to round. Use the places argument to specify the number of decimal places. The places argument has these rules:

    Remarks

    The result may be rounded up or rounded down.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    ROUND(A3,–2)

    ROUND(C4,B2)

    ROUND(R1C2,2)

    ROUND(PI(),5) gives the result 3.14159

    ROUND(29.2,-2) gives the result 0because 29.2 is closer to 0 than to 100.

    ROUND(-1.963,0) gives the result -2

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ROUNDDOWN | ROUNDUP | CEILING | FLOOR | MROUND | Math and Trigonometry Functions