diff options
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index f894aafd81..389cf9d237 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -618,7 +618,7 @@ <paragraph id="par_id3157866" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KUERZEN">Truncates a number by removing decimal places.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3148511" role="code" xml-lang="en-US">TRUNC(Number; Count)</paragraph> +<paragraph id="par_id3148511" role="code" xml-lang="en-US">TRUNC(Number[; Count])</paragraph> <paragraph id="par_id3150796" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> with at most <emph>Count</emph> decimal places. Excess decimal places are simply removed, irrespective of sign.</paragraph> <paragraph id="par_id3150816" role="paragraph" xml-lang="en-US"><item type="literal">TRUNC(Number; 0)</item> behaves as <item type="literal">INT(Number)</item> for positive numbers, but effectively rounds towards zero for negative numbers.</paragraph> <warning id="par_id3148548">The <emph>visible</emph> decimal places of the result are specified in <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences @@ -627,6 +627,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3152569" role="paragraph" xml-lang="en-US"><item type="input">=TRUNC(1.239;2)</item> returns 1.23. The 9 is lost.</paragraph> <paragraph id="par_id7050080" role="paragraph" xml-lang="en-US"><item type="input">=TRUNC(-1.234999;3)</item> returns -1.234. All the 9s are lost.</paragraph><comment>see also INT, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND</comment> +<paragraph role="paragraph" id="par_id441635243969504"><input>=TRUNC(-45.67)</input> returns -45. The default value for <emph>Count</emph> is 0.</paragraph> +<tip id="par_id151635245092041">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC" name="TRUNC_Wiki">TRUNC</link> wiki page for more details about this function.</tip> </section> <section id="Section34"> |