Did you know that the OpenOffice.org Wiki has a WYSIWYG editor? See Help:FCKeditor

From OpenOffice.org Wiki

ROUNDUP

Rounds a number up, away from zero, to a certain precision.

Syntax:

ROUNDUP(number; places)

returns number rounded up (away from zero) to places decimal places. If places is omitted or zero, the function rounds up to an integer. If places is negative, the function rounds up to the next 10, 100, 1000, etc.

This function rounds away from zero. See ROUNDDOWN and ROUND for alternatives.

Example:

ROUNDUP(1.1111; 2)

returns 1.12

ROUNDUP(1.2345; 1)

returns 1.3

ROUNDUP(45.67; 0)

returns 46

ROUNDUP(-45.67)

returns -46

ROUNDUP(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.

---

See Also

• INT
• TRUNC
• ROUND
• ROUNDDOWN
• CEILING
• FLOOR
• EVEN
• ODD
• MROUND
• Mathematical functions
• Functions listed alphabetically
• Functions listed by category