Spread WPF Documentation
ROUNDUP
Spread WPF Documentation > Formula Reference > Formula Functions > ROUNDUP

Summary

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

See Also