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

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

    Syntax

    ROUNDUP(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

    Regardless of the sign of the number specified by the value argument, the number is rounded away from zero.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    ROUNDUP(A3,–2)

    ROUNDUP(C4,B2)

    ROUNDUP(R1C2, 2)

    ROUNDUP(PI(),5) gives the result 3.14160

    ROUNDUP(29.2,-2) gives the result 100

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

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ROUND | ROUNDDOWN | CEILING | FLOOR | Math and Trigonometry Functions