Ask Your Question

Round function

asked 2017-08-15 13:17:11 +0200

libnac gravatar image

The Round function does not work. What could be the reason? =Round(2,5) Result: #Name?

edit retag flag offensive close merge delete


Are you using a localized version where the function might have a different name? Is Options-LibreOffice Calc-Formula-Use English function names active?

Also: does the locale use comma as decimal separator? Don't you need to use dot instead?

Mike Kaganski gravatar imageMike Kaganski ( 2017-08-15 13:20:00 +0200 )edit

Make assumption 'I'm not using it right', not 'it doesn't work'.

Kruno gravatar imageKruno ( 2017-08-16 10:06:29 +0200 )edit

using a dot does not change the result.

libnac gravatar imagelibnac ( 2017-09-16 18:08:49 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-03-08 17:02:05 +0200

yakov gravatar image

check it. i think this tutorial say very clear about that.

might be you still havent understand the syntax rightly.

edit flag offensive delete link more

answered 2017-08-16 10:03:37 +0200

Kruno gravatar image

updated 2017-08-16 11:01:25 +0200

Lupp gravatar image

You are missing argument. If you want to round 2,5543 to 3, function should look something like =ROUND(2,5543; 0). Last number is telling round function how many decimal places you need. Zero will round to whole number. If you put 2 as last argument, you'll get 2,56. Check documentation:

Functions ROUNDDOWN and ROUNDUP work the same way.

Mike Kaganski's suggestions are very important, don't ignore them.

Accept this answer if it helped.

(Editing: 2 decimal place instead of 1 in the second example. Typo.)

edit flag offensive delete link more


=round(2,5543; 0) --> result: #NAME? =round(2,5543; 2) --> result:#NAME?

libnac gravatar imagelibnac ( 2017-09-16 18:06:45 +0200 )edit

What locale are you using? What about =round(2.5543, 0) → what character you use for decimal separator and for separating arguments in functions?

Kruno gravatar imageKruno ( 2017-09-16 19:16:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-15 13:17:11 +0200

Seen: 7,641 times

Last updated: Mar 08 '18