beautypg.com

Roundup, 193 roundup – Apple iWork '09 User Manual

Page 193

background image

Chapter 8

Numeric Functions

193

Related Topics
For related functions and additional information, see:

“CEILING” on page 170

“EVEN” on page 173

“FLOOR” on page 176

“INT” on page 178

“MROUND” on page 183

“ODD” on page 185

“ROUND” on page 191

“ROUNDUP” on page 193

TRUNC” on page 204

“More on Rounding” on page 355

“Listing of Numeric Functions” on page 167

Value Types” on page 36

The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

ROUNDUP

The ROUNDUP function returns a number rounded away from zero (rounded up) to
the specified number of places.

ROUNDUP(num-to-round, digits)

Â

num-to-round: The number to be rounded. num-to-round is a number value.

Â

digits: The number of digits you want to retain, relative to the decimal point. digits
is a number value. A positive number represents digits (decimal places) to the right
of the decimal point to include. A negative number specifies digits to the left of the
decimal point to replace with zeros (the number of zeros at the end of the number).