# Difference between revisions of "Documentation/How Tos/Calc: ROUND function"

From Apache OpenOffice Wiki

< Documentation | How Tos

OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||

Line 38: | Line 38: | ||

* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||

* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||

− | [[Category: Documentation/Reference/Calc]] | + | [[Category: Documentation/Reference/Calc/Mathematical functions]] |

## Revision as of 07:36, 3 May 2010

## ROUND

Rounds a number to a certain precision.

### Syntax:

**ROUND(number; places)**

- returns
rounded to**number**decimal places. If**places**is omitted or zero, the function rounds to the nearest integer. If**places**is negative, the function rounds to the nearest**places**,**10**,**100**, etc.**1000**

### Example:

**ROUND(2.348; 2)**

- returns
**2.35**

**ROUND(2.348; 0)**

- returns
**2**

**ROUND(2.5)**

- returns
**3**

**ROUND(987.65; -2)**

- returns
**1000**

If these examples do not seem to work, see **Tools - Options - OpenOffice.org Calc - Calculate** to check the display precision.