[Libreoffice-bugs] [Bug 131246] Surprizing result from ROUND()

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131246

--- Comment #2 from Xavier Van Wijmeersch <xv3247 at gmail.com> ---
I removed the zero in Round(c11,0) and i have the correct result
I think you don't need the count argument in round() if you only want a result
without decimal numbers
I never use the count argument in the round function

ROUND

Rounds a number to a certain number of decimal places.
Syntax

ROUND(Number; Count)

Returns Number rounded to Count decimal places. If Count is omitted or zero,
the function rounds to the nearest integer. If Count is negative, the function
rounds to the nearest 10, 100, 1000, etc.

This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for
alternatives.
Example

=ROUND(2.348;2) returns 2.35

=ROUND(-32.4834;3) returns -32.483. Change the cell format to see all decimals.

=ROUND(2.348;0) returns 2.

=ROUND(2.5) returns 3.

=ROUND(987.65;-2) returns 1000.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200310/b2b30755/attachment-0001.htm>