From 74944d4f7fb26dd0db7a94cebf8c66d3023b4aa6 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Fri, 27 Jun 2014 22:09:38 -0300 Subject: Fix fdo#80438: help entries of Excel new functions MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit write help entrie for FLOOR.PRECISE, CEILING.PRECISE and ISO.CEILING spreadsheet functions Change-Id: I922fefbc84a7c7842a4510242e1dd477475810a5 Reviewed-on: https://gerrit.libreoffice.org/9948 Reviewed-by: Caolán McNamara Tested-by: Caolán McNamara --- source/text/scalc/01/04060106.xhp | 47 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 47 insertions(+) diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 1b7a807c27..9329c36630 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -725,6 +725,38 @@ oldref="338">Example =CEILING(-11;-2;1) returns -12see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP +
+CEILING.PRECISE function +rounding;up to multiples of significance +mw added one entry + +CEILING.PRECISE +Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance +Syntax +CEILING.PRECISE(Number; Significance) +Number (required) is the number that is to be rounded up. +Significance (optional) is the number to whose multiple the value is to be rounded up. +Example + +=CEILING.PRECISE(-11;-2) returns -10 +see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP +
+
+ISO.CEILING function +rounding;up to multiples of significance +mw added one entry + +ISO.CEILING +Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance +Syntax +ISO.CEILING(Number; Significance) +Number (required) is the number that is to be rounded up. +Significance (optional) is the number to whose multiple the value is to be rounded up. +Example + +=ISO.CEILING(-11;-2) returns -10 +see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP +
PI function @@ -1306,6 +1338,21 @@ oldref="507">Example =ODD(-3.1) returns -5.see also CEILING, FLOOR, EVEN, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP
+
+FLOOR.PRECISE function +rounding;down to nearest multiple of significance +mw added one entry + +FLOOR.PRECISE +Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance +Syntax +FLOOR.PRECISE(Number; Significance) +Number is the number that is to be rounded down. +Significance is the value to whose multiple the number is to be rounded down. +Example + =FLOOR.PRECISE( -11;-2) returns -12 +see also CEILING, EVEN, ODD, MROUND,INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP, +
FLOOR function rounding;down to nearest multiple of significance -- cgit v1.2.3