Roundup – Apple Numbers '08 User Manual

Page 269

Advertising
background image

Chapter 12

Dictionary of Functions

269

Notes
Other functions related to rounding numbers: CEILING, INT, ROUND, ROUNDUP, TRUNC.

ROUNDUP

The ROUNDUP function rounds a number away from zero to the specified number of
places.

ROUNDUP(number, digits)

 number: The number you want to round. It can be a number, numeric expression, or

a reference to a cell containing a numeric expression.

 digits: The number of digits of the result relative to the decimal point. A positive

number represents digits (decimal places) to the right of the decimal point. A
negative number specifies digits to the left of the decimal point.

Notes
Other functions related to rounding numbers: CEILING, INT, ROUND, ROUNDDOWN,
TRUNC.

Examples

ROUNDDOWN(1.49,0) returns 1.

ROUNDDOWN(1.50,0) returns 1.

ROUNDDOWN(1.23456,3) returns 1.234.

ROUNDDOWN(1111.222,-2) returns 1100.

ROUNDDOWN(-2.2,0) returns -2.

ROUNDDOWN(-2.8,0) returns -2.

Examples

ROUNDUP(1.49,0) returns 2.

ROUNDUP(1.50,0) returns 2.

ROUNDUP(1.23456,3) returns 1.235.

ROUNDUP(1111.222,-2) returns 1200.

ROUNDUP(-2.2,0) returns -3.

ROUNDUP(-2.8,0) returns -3.

Advertising