Apple numbers User Manual

    Dictionary of Functions 

 

  

The ROUND function rounds a number to the specified number of places. 

ROUND(number, digits)

 number:  The number you want to round. It can be a numeric expression in the 

function or a reference to a cell containing a numeric expression.

 digits:  The number of digits you want to round to, 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, ROUNDUP, ROUNDDOWN, 
TRUNC.
  

The ROUNDDOWN function rounds a number toward zero to the specified number of 
places.

ROUNDDOWN(number, digits)

 number:  The number you want to round. It can be a numeric expression in the 

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

ROMAN(12) returns XII.

ROMAN(999) returns CMXCIX.

ROMAN(999,1) returns LMVLIV.

ROMAN(999,2) returns XMIX.

ROMAN(999,3) returns VMIV.

ROMAN(999,4) returns IM.

ROUND(1.49,0) returns 1.

ROUND(1.50,0) returns 2.

ROUND(1.23456,3) returns 1.235.

ROUND(1111.222,-2) returns 1100.

ROUND(-2.2,0) returns -2.

ROUND(-2.8,0) returns -3.