beautypg.com

Mround, 183 mround – Apple iWork '09 User Manual

Page 183

background image

Chapter 8

Numeric Functions

183

MROUND

The MROUND function rounds a number to the nearest multiple of a specified factor.

MROUND(num-to-round, factor)

Â

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

Â

factor: The number to use to determine the closet multiple. factor is a number
value. It must have the same sign as num-to-round.

Examples

=MROUND(2, 3) returns 3.
=MROUND(4, 3) returns 3.
=MROUND(4.4999, 3) returns 3.
=MROUND(4.5, 3) returns 6.
=MROUND(-4.5, 3) returns an error.

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

“ODD” on page 185

“ROUND” on page 191

“ROUNDDOWN” on page 192

“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