Spread 8.0 Documentation
ROUND
Support Options
Formula Reference > Built-In Functions > ROUND

Glossary Item Box

ROUND


Name

Round

Description

Rounds the specified value to the nearest number, using the specified number of decimal places.

Syntax

ROUND(value1, value2)

Remarks

Use the value1 argument to specify the number to round. Use the value2 argument to specify the number of decimal places.

Note the following about the value2 argument:

See also CEILING, EVEN, FLOOR, INT, ODD, ROUNDDOWN, ROUNDUP, TRUNC.

Data Type

Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

ROUND(R1C2,2)
ROUND(A3,–2)
ROUND(C4,B2)
ROUND(PI(),5)=3.14159
ROUND(29.2,-2)=0
ROUND(-1.963,0)=-2

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.