<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Surprizing result from ROUND()"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131246#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Surprizing result from ROUND()"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131246">bug 131246</a>
from <span class="vcard"><a class="email" href="mailto:xv3247@gmail.com" title="Xavier Van Wijmeersch <xv3247@gmail.com>"> <span class="fn">Xavier Van Wijmeersch</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>