﻿ ROUNDUP | Spread.NET 15 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:

• Set places to a value greater than zero to round to the specified number of decimal places.
• Set places to zero to round to the nearest whole number.
• Set places to a value less than zero to round the value left of the decimal to the nearest ten, hundred, etc.

#### 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.