aboutsummaryrefslogtreecommitdiff
path: root/source/es/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2020-04-15 14:08:14 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2020-04-15 14:12:29 +0200
commit1cf550347fdb87391903b533dd1c47135875a9d7 (patch)
tree42aeb67f0d164abb01f73d6ddc7c1d8927a253a3 /source/es/helpcontent2/source/text/scalc/01.po
parent0a73e51795ef412006c59d3723f265fed445dea1 (diff)
update translations for master
and force-fix errors using pocheck Change-Id: I9f37f1bad2c1005d8b63991fb1a66cd2f14e259b
Diffstat (limited to 'source/es/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/es/helpcontent2/source/text/scalc/01.po1629
1 files changed, 1008 insertions, 621 deletions
diff --git a/source/es/helpcontent2/source/text/scalc/01.po b/source/es/helpcontent2/source/text/scalc/01.po
index 2f250f87bc4..3ff1a41857f 100644
--- a/source/es/helpcontent2/source/text/scalc/01.po
+++ b/source/es/helpcontent2/source/text/scalc/01.po
@@ -3,8 +3,8 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-04-03 11:46+0200\n"
-"PO-Revision-Date: 2020-03-21 09:16+0000\n"
+"POT-Creation-Date: 2020-04-15 12:52+0200\n"
+"PO-Revision-Date: 2020-04-14 06:16+0000\n"
"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: Spanish <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/es/>\n"
"Language: es\n"
@@ -6199,14 +6199,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">Calculates the amount received that is paid for a fixed-interest security at a given point in time.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">Calcula la cantidad recibida que se paga por un valor a interés fijo en un momento determinado.</ahelp>"
-#. XhTVX
+#. BiDCz
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3145362\n"
"help.text"
-msgid "RECEIVED(\"Settlement\"; \"Maturity\"; Investment; Discount; Basis)"
-msgstr "CANTIDAD.RECIBIDA(\"Liquidación\"; \"Vencimiento\"; Inversión; Descuenta; Bases)"
+msgid "RECEIVED(Settlement; Maturity; Investment; Discount[; Basis])"
+msgstr ""
#. oHAVz
#: 04060103.xhp
@@ -6991,14 +6991,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_DISC\">Calculates the allowance (discount) of a security as a percentage.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_DISC\">Calcula la provisión (descuento) de un valor en forma de porcentaje.</ahelp>"
-#. tusey
+#. fBGBA
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3149756\n"
"help.text"
-msgid "DISC(\"Settlement\"; \"Maturity\"; Price; Redemption; Basis)"
-msgstr "DISC(\"Liquidación\"; \"Vencimiento\"; Precio; Redención; Bases)"
+msgid "DISC(Settlement; Maturity; Price; Redemption[; Basis])"
+msgstr ""
#. Uyj29
#: 04060103.xhp
@@ -7081,14 +7081,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calculates the duration of a fixed interest security in years.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calcula la duración, en años, de un valor de interés fijo.</ahelp>"
-#. bJZPP
+#. 7ixum
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3153373\n"
"help.text"
-msgid "DURATION(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)"
-msgstr "DURACION(\"Liquidación\"; \"Vencimiento\"; Vale; Rendimiento; Frecuencia; Base)"
+msgid "DURATION(Settlement; Maturity; Coupon; Yield; Frequency[; Basis])"
+msgstr ""
#. JeeVp
#: 04060103.xhp
@@ -7144,14 +7144,14 @@ msgctxt ""
msgid "A security is purchased on 2001-01-01; the maturity date is 2006-01-01. The Coupon rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how long is the duration?"
msgstr "Un valor se compra el 01-01-2001; la fecha de vencimiento es el 01-01-2006. El interés nominal asciende al 8 %. La rentabilidad es del 9 %. El interés se paga semestralmente (la frecuencia es 2). ¿Cuál es la duración al realizar un cálculo (base 3) diario?"
-#. ggYzf
+#. ADc8t
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3154902\n"
"help.text"
-msgid "<item type=\"input\">=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>"
-msgstr "<item type=\"input\">=DURACION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>"
+msgid "<input>=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</input> returns 4.2 years."
+msgstr ""
#. TjeEJ
#: 04060103.xhp
@@ -12661,420 +12661,6 @@ msgctxt ""
msgid "<item type=\"input\">=LOG10(5)</item> returns the base-10 logarithm of 5 (approximately 0.69897)."
msgstr "<item type=\"input\">=LOG10(5)</item> devuelve el logaritmo en base 10 de 5 (aproximadamente 0,69897)."
-#. fnS8m
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id3152518\n"
-"help.text"
-msgid "<bookmark_value>CEILING function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-msgstr "<bookmark_value>función MULTIPLO.SUPERIOR</bookmark_value> <bookmark_value>redondear;al alza hacia múltiplos de precisión</bookmark_value>"
-
-#. FtjnD
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3152518\n"
-"help.text"
-msgid "CEILING"
-msgstr "MULTIPLO.SUPERIOR"
-
-#. BDPUw
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153422\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Redondea al alza un número al múltiplo más próximo de Precisión.</ahelp>"
-
-#. fhdEu
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153454\n"
-"help.text"
-msgid "CEILING(Number; Significance; Mode)"
-msgstr "MULTIPLO.SUPERIOR(Número; Precisión; Modo)"
-
-#. PyYGM
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153467\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded up."
-msgstr "<emph>Número</emph> es la cifra que se debe redondear."
-
-#. GQVYD
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3155000\n"
-"help.text"
-msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>Precisión</emph> es el número cuyo valor de múltiplo se debe redondear al alza."
-
-#. dEi4T
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3155020\n"
-"help.text"
-msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero."
-msgstr "<emph>Modo</emph> es un valor opcional. Si se proporciona el valor de Modo y este difiere de cero, y si los valores de Número y Precisión son negativos, el redondeo se efectúa según el valor absoluto de Número; esto es, los números negativos se redondean alejándose de cero. Si el valor de Modo es cero o se omite, los números negativos se redondean aproximándose a cero."
-
-#. MUqdA
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163792\n"
-"help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
-msgstr "Si el libro se exporta a Microsoft Excel, la función MULTIPLO.SUPERIOR se exportará como la función equivalente MULTIPLO.SUPERIOR.MAT, la cual existe desde Excel 2013. Si tiene pensado utilizar el libro con versiones anteriores de Excel, elija entre emplear MÚLTIPLO.SUPERIOR.EXACTO, disponible desde Excel 2010, o MULTIPLO.SUPERIOR.XCL, la cual se exporta como MULTIPLO.SUPERIOR, compatible con todas las versiones de Excel. Observe que MULTIPLO.SUPERIOR.XCL siempre redondea alejándose de cero."
-
-#. B5jSx
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3145710\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING(-11;-2)</item> returns -10"
-msgstr "<item type=\"input\">=MULTIPLO.SUPERIOR(-11;-2)</item> devuelve −10."
-
-#. H6Ai9
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3145725\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING(-11;-2;0)</item> returns -10"
-msgstr "<item type=\"input\">=MULTIPLO.SUPERIOR(-11;-2;0)</item> devuelve −10."
-
-#. X8Ebc
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3145740\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING(-11;-2;1)</item> returns -12"
-msgstr "<item type=\"input\">=MULTIPLO.SUPERIOR(-11;-2;1)</item> devuelve −12."
-
-#. NWAdq
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id2952518\n"
-"help.text"
-msgid "<bookmark_value>CEILING.PRECISE function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-msgstr "<bookmark_value>función MULTIPLO.SUPERIOR.EXACTO</bookmark_value> <bookmark_value>redondear;al alza hacia múltiplo de precisión</bookmark_value>"
-
-#. TL2Mo
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id2952518\n"
-"help.text"
-msgid "CEILING.PRECISE"
-msgstr "MULTIPLO.SUPERIOR.EXACTO"
-
-#. uP3ef
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953422\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_CEIL_MS\">Redondea al alza un número al múltiplo más próximo de la precisión, sin importar el signo de esta</ahelp>"
-
-#. af8Jy
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953454\n"
-"help.text"
-msgid "CEILING.PRECISE(Number; Significance)"
-msgstr "MULTIPLO.SUPERIOR.EXACTO(Número; Precisión)"
-
-#. c2S3Q
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953467\n"
-"help.text"
-msgid "<emph>Number</emph> (required) is the number that is to be rounded up."
-msgstr "<emph>Número</emph> (obligatorio) es el número que se redondeará al alza."
-
-#. De3wj
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2955000\n"
-"help.text"
-msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>Precisión</emph> (opcional) es el número cuyo valor de múltiplo se debe redondear al alza."
-
-#. ATzN5
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2945710\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.PRECISE(-11;-2)</item> returns -10"
-msgstr "<item type=\"input\">=MULTIPLO.SUPERIOR.EXACTO(-11;-2)</item> devuelve -10"
-
-#. CyR3Z
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id911516997198644\n"
-"help.text"
-msgid "<bookmark_value>CEILING.MATH function</bookmark_value>"
-msgstr "<bookmark_value>función MULTIPLO.SUPERIOR.MAT</bookmark_value>"
-
-#. 47WTb
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id91516997330445\n"
-"help.text"
-msgid "CEILING.MATH"
-msgstr "MULTIPLO.SUPERIOR.MAT"
-
-#. fj22A
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id81516997342088\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number up to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Redondea al alza un número hasta el múltiplo de Precisión más próximo.</ahelp>"
-
-#. dEs2U
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id841516997669932\n"
-"help.text"
-msgid "CEILING.MATH(Number; Significance; Mode)"
-msgstr "MULTIPLO.SUPERIOR.MAT(Número; Precisión; Modo)"
-
-#. mVrcG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id651516997706287\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded up."
-msgstr "<emph>Número</emph> es la cifra que se debe redondear al alza."
-
-#. eWEoz
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id491516997725772\n"
-"help.text"
-msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>Precisión</emph> es el número cuyo valor de múltiplo se debe redondear al alza."
-
-#. DhhJP
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id451516997742909\n"
-"help.text"
-msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero."
-msgstr "<emph>Modo</emph> es un valor opcional. Si se proporciona el valor de Modo y este difiere de cero, y si los valores de Número y Precisión son negativos, el redondeo se efectúa según el valor absoluto de Número; esto es, los números negativos se redondean alejándose de cero. Si el valor de Modo es cero o se omite, los números negativos se redondean aproximándose a cero."
-
-#. pNkWd
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id291516998575663\n"
-"help.text"
-msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
-msgstr "Esta función existe por motivos de interoperatividad con Microsoft Excel 2013 y versiones más recientes de este."
-
-#. AWN7C
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id111516997803684\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.MATH(-10;-3)</item> returns -9"
-msgstr "<item type=\"input\">=MULTIPLO.SUPERIOR.MAT(-10;-3)</item> devuelve −9"
-
-#. VRy7N
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id1001516997821483\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.MATH(-10;-3;0)</item> returns -9"
-msgstr "<item type=\"input\">=MULTIPLO.SUPERIOR.MAT(-10;-3;0)</item> devuelve −9"
-
-#. Cqx7f
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id641516997837754\n"
-"help.text"
-msgid "<item type=\"item_type\">=CEILING.MATH(-10;-3;1)</item> returns -12"
-msgstr "<item type=\"item_type\">=MULTIPLO.SUPERIOR.MAT(-10;-3;1)</item> devuelve −12"
-
-#. 5eFKb
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id921516998608939\n"
-"help.text"
-msgid "<bookmark_value>CEILING.XCL function</bookmark_value>"
-msgstr "<bookmark_value>función MULTIPLO.SUPERIOR.XCL</bookmark_value>"
-
-#. 7CEZC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id411516998838823\n"
-"help.text"
-msgid "CEILING.XCL"
-msgstr "MULTIPLO.SUPERIOR.XCL"
-
-#. vYMF6
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id811516998845826\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number away from zero to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_CEIL_MS\">Redondea un número, alejándolo de cero, hasta el múltiplo de Precisión más próximo.</ahelp>"
-
-#. hh5aZ
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id251516998856873\n"
-"help.text"
-msgid "CEILING.XCL(Number; Significance)"
-msgstr "MULTIPLO.SUPERIOR.XCL(Número; Precisión)"
-
-#. cwEnK
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id671516998874263\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded."
-msgstr "<emph>Número</emph> es la cifra que se debe redondear."
-
-#. RLTcE
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id151516998882622\n"
-"help.text"
-msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded."
-msgstr "<emph>Precisión</emph> es el número a cuyo múltiplo se debe redondear el valor."
-
-#. FZWHB
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id341516998889754\n"
-"help.text"
-msgid "This function exists for interoperability with Microsoft Excel 2007 or older versions."
-msgstr "Esta función existe por motivos de interoperatividad con Microsoft Excel 2007 o versiones anteriores de este."
-
-#. UuVCG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id91516998917254\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.XCL(1;3)</item> returns 3"
-msgstr "<item type=\"input\">=MULTIPLO.SUPERIOR.XCL(1;3)</item> devuelve 3"
-
-#. mD3Gy
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id761516998929693\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.XCL(7;4)</item> returns 8"
-msgstr "<item type=\"input\">=MULTIPLO.SUPERIOR.XCL(7;4)</item> devuelve 8"
-
-#. C59zA
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id671516998958873\n"
-"help.text"
-msgid "<item type=\"item_type\">=CEILING.XCL(-10;-3)</item> returns -12"
-msgstr "<item type=\"item_type\">=MULTIPLO.SUPERIOR.XCL(-10;-3)</item> devuelve −12"
-
-#. VwPyC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id8952518\n"
-"help.text"
-msgid "<bookmark_value>ISO.CEILING function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-msgstr "<bookmark_value>función MULTIPLO.SUPERIOR.ISO</bookmark_value> <bookmark_value>redondear;al alza por múltiplos de precisión</bookmark_value>"
-
-#. DhoD5
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id8952518\n"
-"help.text"
-msgid "ISO.CEILING"
-msgstr "MULTIPLO.SUPERIOR.ISO"
-
-#. a8Z2B
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953422\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Redondea al alza un número al múltiplo más próximo de la precisión, sin importar el signo de esta</ahelp>"
-
-#. iGoz8
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953454\n"
-"help.text"
-msgid "ISO.CEILING(Number; Significance)"
-msgstr "MULTIPLO.SUPERIOR.ISO(Número; Precisión)"
-
-#. p7ssP
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953467\n"
-"help.text"
-msgid "<emph>Number</emph> (required) is the number that is to be rounded up."
-msgstr "<emph>Número</emph> (obligatorio) es el número que se redondeará al alza."
-
-#. FBHry
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8955000\n"
-"help.text"
-msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>Precisión</emph> (opcional) es el número cuyo valor de múltiplo se redondeará al alza."
-
-#. M8dYu
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8945710\n"
-"help.text"
-msgid "<item type=\"input\">=ISO.CEILING(-11;-2)</item> returns -10"
-msgstr "<item type=\"input\">=MULTIPLO.SUPERIOR.ISO(-11;-2)</item> devuelve -10"
-
#. tQjUA
#: 04060106.xhp
msgctxt ""
@@ -14171,7 +13757,7 @@ msgctxt ""
"par_id3163625\n"
"help.text"
msgid "<ahelp hid=\"HID_FUNC_SUMME\">Adds a set of numbers.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\"HID_FUNC_SUMME\">Suma un conjunto de números.</ahelp>"
#. NavGZ
#: 04060106.xhp
@@ -15037,168 +14623,6 @@ msgctxt ""
msgid "<item type=\"input\">=ODD(-3.1)</item> returns -5."
msgstr "<item type=\"input\">=REDONDEA.IMPAR(-3.1)</item> devuelve -5."
-#. CR7gG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id2957404\n"
-"help.text"
-msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value> <bookmark_value>FLOOR.XCL function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
-msgstr ""
-
-#. ticPN
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id2957404\n"
-"help.text"
-msgid "FLOOR.PRECISE"
-msgstr "MULTIPLO.INFERIOR.EXACTO"
-
-#. eZWE9
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957432\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Redondea a la baja un número al múltiplo más próximo de la precisión, sin importar el signo de esta</ahelp>"
-
-#. BKB8E
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957464\n"
-"help.text"
-msgid "FLOOR.PRECISE(Number; Significance)"
-msgstr "MULTIPLO.INFERIOR.EXACTO(Número; Precisión)"
-
-#. Mt3KY
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957478\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded down."
-msgstr "<emph>Número</emph> es la cifra que se debe redondear a la baja."
-
-#. oe3sn
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957497\n"
-"help.text"
-msgid "<emph>Significance</emph> is the value to whose multiple the number is to be rounded down."
-msgstr "<emph>Precisión</emph> es el número a cuyo valor de múltiplo se debe redondear a la baja."
-
-#. FCZhS
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2963945\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR.PRECISE( -11;-2)</item> returns -12"
-msgstr "<item type=\"input\">=MULTIPLO.INFERIOR.EXACTO( -11;-2)</item> devuelve −12"
-
-#. aDgE5
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id3157404\n"
-"help.text"
-msgid "<bookmark_value>FLOOR function</bookmark_value> <bookmark_value>FLOOR.MATH function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
-msgstr ""
-
-#. BAZE3
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3157404\n"
-"help.text"
-msgid "FLOOR"
-msgstr "MULTIPLO.INFERIOR"
-
-#. WHyYX
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157432\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number down to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Redondea un número a la baja hasta el múltiplo de Precisión más próximo.</ahelp>"
-
-#. DDbJ6
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157464\n"
-"help.text"
-msgid "FLOOR(Number; Significance; Mode)"
-msgstr "MULTIPLO.INFERIOR(Número; Precisión; Modo)"
-
-#. cEAXh
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157478\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded down."
-msgstr "<emph>Número</emph> es la cifra que se debe redondear a la baja."
-
-#. zEGez
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157497\n"
-"help.text"
-msgid "<emph>Significance</emph> is the value to whose multiple the number is to be rounded down."
-msgstr "<emph>Precisión</emph> es el número a cuyo valor de múltiplo se debe redondear a la baja."
-
-#. dDExC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157517\n"
-"help.text"
-msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero."
-msgstr "<emph>Modo</emph> es un valor opcional. Si se proporciona el valor de Modo y este difiere de cero, y si los valores de Número y Precisión son negativos, el redondeo se efectúa según el valor absoluto de Número; esto es, los números negativos se redondean aproximándose a cero. Si el valor de Modo es cero o se omite, los números negativos se redondean alejándose de cero."
-
-#. Z6Cnd
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163894\n"
-"help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero."
-msgstr "Si el libro se exporta a Microsoft Excel, la función MULTIPLO.INFERIOR se exportará como la función equivalente MULTIPLO.INFERIOR.MAT, la cual existe desde Excel 2013. Si tiene pensado utilizar el libro con versiones anteriores de Excel, elija entre emplear MÚLTIPLO.INFERIOR.EXACTO, disponible desde Excel 2010, o MULTIPLO.INFERIOR.XCL, la cual se exporta como MULTIPLO.INFERIOR, compatible con todas las versiones de Excel. Observe que MULTIPLO.INFERIOR.XCL siempre redondea aproximándose a cero."
-
-#. 4FuF8
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163945\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR( -11;-2)</item> returns -12"
-msgstr "<item type=\"input\">=MULTIPLO.INFERIOR( -11;-2)</item> devuelve −12."
-
-#. R4ppE
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163966\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR( -11;-2;0)</item> returns -12"
-msgstr "<item type=\"input\">=MULTIPLO.INFERIOR( -11;-2;0)</item> devuelve −12."
-
-#. aWzUK
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163988\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR( -11;-2;1)</item> returns -10"
-msgstr "<item type=\"input\">=MULTIPLO.INFERIOR( -11;-2;1)</item> devuelve −10."
-
#. itiAQ
#: 04060106.xhp
msgctxt ""
@@ -16585,41 +16009,41 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_MMULT\">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns."
msgstr "<ahelp hid=\"HID_FUNC_MMULT\">Calcula la matriz producto de dos matrices.</ahelp> El número de columnas de la matriz 1 debe coincidir con el número de filas de la matriz 2. La matriz cuadrada tiene el mismo número de filas y de columnas."
-#. dEKAU
+#. JUTAD
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3150798\n"
"help.text"
-msgid "MMULT(Array; Array)"
-msgstr "MMULT(Matriz; Matriz)"
+msgid "MMULT(Array 1; Array 2)"
+msgstr ""
-#. noXqv
+#. DqghH
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3150812\n"
"help.text"
-msgid "<emph>Array</emph> at first place represents the first array used in the array product."
-msgstr "La primera <emph>Matriz</emph> representa la primera matriz del producto."
+msgid "<emph>Array 1</emph> represents the first array used in the array product."
+msgstr ""
-#. 5qGeT
+#. FDfwg
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3152553\n"
"help.text"
-msgid "<emph>Array</emph> at second place represents the second array with the same number of rows."
-msgstr "La segunda <emph>Matriz</emph> representa la segunda matriz del producto, con el mismo número de filas."
+msgid "<emph>Array 2</emph> represents the second array with the same number of rows."
+msgstr ""
-#. RoWHa
+#. CuGxm
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3146826\n"
"help.text"
-msgid "Select a square range. Choose the MMULT function. Select the first <emph>Array</emph>, then select the second <emph>Array</emph>. Using <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range."
-msgstr "Seleccione un intervalo cuadrado. Elija la función MMULT. Seleccione la primera <emph>Matriz</emph> y, a continuación, la segunda <emph>Matriz</emph>. Marque la casilla de verificación <emph>Matriz</emph> en el <emph>Asistente para funciones</emph>. Pulse en <emph>Aceptar</emph>. La matriz de salida aparecerá en el intervalo seleccionado."
+msgid "Select a square range. Choose the MMULT function. Select <emph>Array 1</emph>, then select <emph>Array 2</emph>. Using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range."
+msgstr ""
#. vPBWq
#: 04060107.xhp
@@ -18313,15 +17737,6 @@ msgctxt ""
msgid "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518."
msgstr "Si la celda A1 muestra el Error:518, la función <item type=\"input\">=TIPO.DE.ERROR.OOO(A1)</item> devuelve el número 518."
-#. FWJTB
-#: 04060109.xhp
-msgctxt ""
-"04060109.xhp\n"
-"hd_id275141466817507\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_error_type.xhp#error_type_head\"/>"
-msgstr ""
-
#. mtLKD
#: 04060109.xhp
msgctxt ""
@@ -19841,7 +19256,7 @@ msgctxt ""
"par_id661585662472832\n"
"help.text"
msgid "or"
-msgstr ""
+msgstr "o"
#. QnCVY
#: 04060109.xhp
@@ -19868,7 +19283,7 @@ msgctxt ""
"hd_id431585688827982\n"
"help.text"
msgid "First Syntax"
-msgstr ""
+msgstr "Primera sintaxis"
#. xTLTZ
#: 04060109.xhp
@@ -19940,7 +19355,7 @@ msgctxt ""
"hd_id551585688835597\n"
"help.text"
msgid "Second Syntax"
-msgstr ""
+msgstr "Segunda sintaxis"
#. KETgR
#: 04060109.xhp
@@ -33784,6 +33199,15 @@ msgctxt ""
msgid "<ahelp hid=\".\">Returns the inverse of CHISQDIST.</ahelp>"
msgstr "<ahelp hid=\".\">Devuelve el valor inverso de DISTR.CUAD.CHI.</ahelp>"
+#. ELVTS
+#: 04060181.xhp
+msgctxt ""
+"04060181.xhp\n"
+"par_id21585771564740\n"
+"help.text"
+msgid "CHISQINV(Probability; Degrees of Freedom)"
+msgstr ""
+
#. KibGe
#: 04060181.xhp
msgctxt ""
@@ -35764,6 +35188,15 @@ msgctxt ""
msgid "<ahelp hid=\".\">Returns the Gamma function value.</ahelp> Note that GAMMAINV is not the inverse of GAMMA, but of GAMMADIST."
msgstr "<ahelp hid=\".\">Devuelve el valor de la función Gamma.</ahelp> DISTR.GAMMA.INV no es el inverso de GAMMA, sino de DISTR.GAMMA."
+#. WT29Z
+#: 04060182.xhp
+msgctxt ""
+"04060182.xhp\n"
+"par_id211585771824267\n"
+"help.text"
+msgid "GAMMA(Number)"
+msgstr ""
+
#. 2DdQa
#: 04060182.xhp
msgctxt ""
@@ -36637,14 +36070,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Returns the hypergeometric distribution.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Devuelve la distribución hipergeométrica.</ahelp>"
-#. fNMzN
+#. 5uQ3c
#: 04060182.xhp
msgctxt ""
"04060182.xhp\n"
"par_id3155388\n"
"help.text"
-msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation)"
-msgstr "DISTR.HIPERGEOM(X; EjemploN; Éxitos; PoblaciónN)"
+msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative])"
+msgstr ""
#. ingyW
#: 04060182.xhp
@@ -36682,6 +36115,15 @@ msgctxt ""
msgid "<emph>NPopulation </emph>is the size of the total population."
msgstr "<emph>PoblaciónN</emph> es el tamaño de la población total."
+#. oDuYV
+#: 04060182.xhp
+msgctxt ""
+"04060182.xhp\n"
+"par_id231585952506847\n"
+"help.text"
+msgid "<emph>Cumulative </emph> (optional) specifies whether to calculate the probability density function (FALSE or 0) or the cumulative distribution function (any other value). The cumulative distribution function is the default if no value is specified for this parameter."
+msgstr ""
+
#. WUiB6
#: 04060182.xhp
msgctxt ""
@@ -55987,6 +55429,528 @@ msgctxt ""
msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
msgstr "Si E2 = pan, la función devuelve 65 porque el enlace a la celda se sustituye por su contenido."
+#. s6GFW
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"tit\n"
+"help.text"
+msgid "Ceiling functions"
+msgstr ""
+
+#. EWCte
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id971586216771519\n"
+"help.text"
+msgid "Ceiling functions"
+msgstr ""
+
+#. M92qb
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id3152518\n"
+"help.text"
+msgid "<bookmark_value>CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>"
+msgstr ""
+
+#. XR3RK
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id3152518\n"
+"help.text"
+msgid "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\" name=\"CEILING\">CEILING</link></variable>"
+msgstr ""
+
+#. E9m3Y
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3153422\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of s significance value.</ahelp>"
+msgstr ""
+
+#. PfT3s
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id601586207136514\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
+msgstr ""
+
+#. s9tRF
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3163792\n"
+"help.text"
+msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
+msgstr ""
+
+#. mZwNV
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3153454\n"
+"help.text"
+msgid "CEILING(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. XHjhc
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3153467\n"
+"help.text"
+msgid "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number."
+msgstr ""
+
+#. XEqxw
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3155000\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>."
+msgstr ""
+
+#. AosjB
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3155020\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded down (away from zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded up (towards zero)."
+msgstr ""
+
+#. Ka9pC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id281586208138400\n"
+"help.text"
+msgid "<input>=CEILING(3.45)</input> returns 4."
+msgstr ""
+
+#. ztdNi
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id921586208142416\n"
+"help.text"
+msgid "<input>=CEILING(3.45, 3)</input> returns 6."
+msgstr ""
+
+#. XGfA3
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id921586208146984\n"
+"help.text"
+msgid "<input>=CEILING(-1.234)</input> returns -1."
+msgstr ""
+
+#. ss5WP
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id491586208152183\n"
+"help.text"
+msgid "<input>=CEILING(-45.67, -2, 0)</input> returns -44."
+msgstr ""
+
+#. FY9XN
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id291586208158119\n"
+"help.text"
+msgid "<input>=CEILING(-45.67, -2, 1)</input> returns -46."
+msgstr ""
+
+#. rZ78k
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id2952518\n"
+"help.text"
+msgid "<bookmark_value>CEILING.PRECISE function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>"
+msgstr ""
+
+#. 5DWRd
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id2952518\n"
+"help.text"
+msgid "<variable id=\"CEILING.PRECISEh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingprecise\" name=\"CEILING.PRECISE\">CEILING.PRECISE</link></variable>"
+msgstr ""
+
+#. aTD6P
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id2953422\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. BjuBa
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id151586642494759\n"
+"help.text"
+msgid "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored."
+msgstr ""
+
+#. EErBR
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id631586642933797\n"
+"help.text"
+msgid "This function calculates identical results to the <link href=\"#Section312\" name=\"isoceiling\">ISO.CEILING</link> function."
+msgstr ""
+
+#. yYT7X
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id2953454\n"
+"help.text"
+msgid "CEILING.PRECISE(Number[; Significance])"
+msgstr ""
+
+#. FaYeD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id2955000\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. 6Vtow
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id461586211894475\n"
+"help.text"
+msgid "This function calculates identical results to the ISO.CEILING function"
+msgstr ""
+
+#. 8WiRx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id201586213398634\n"
+"help.text"
+msgid "<input>=CEILING.PRECISE(3.45)</input> returns 4."
+msgstr ""
+
+#. kkosx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id651586213406243\n"
+"help.text"
+msgid "<input>=CEILING.PRECISE(-45.67,2)</input> returns -44."
+msgstr ""
+
+#. WV9bx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id911516997198644\n"
+"help.text"
+msgid "<bookmark_value>CEILING.MATH function</bookmark_value>"
+msgstr ""
+
+#. 7xeKu
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id91516997330445\n"
+"help.text"
+msgid "<variable id=\"CEILING.MATHh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingmath\" name=\"CEILING.MATH\">CEILING.MATH</link></variable>"
+msgstr ""
+
+#. AzJvD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id81516997342088\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. QLGe7
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id911586642319078\n"
+"help.text"
+msgid "For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored."
+msgstr ""
+
+#. Km7yb
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id841516997669932\n"
+"help.text"
+msgid "CEILING.MATH(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. EAezJ
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id491516997725772\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. EiWLa
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id451516997742909\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded down (away from zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded up (towards zero)."
+msgstr ""
+
+#. aYczG
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id291516998575663\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
+msgstr ""
+
+#. je22s
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id331586208590009\n"
+"help.text"
+msgid "<input>=CEILING.MATH(3.45)</input> returns 4."
+msgstr ""
+
+#. 6BkMe
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id481586208595809\n"
+"help.text"
+msgid "<input>=CEILING.MATH(3.45,-3)</input> returns 6."
+msgstr ""
+
+#. Eby7i
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id641586208600665\n"
+"help.text"
+msgid "<input>=CEILING.MATH(-1.234)</input> returns -1."
+msgstr ""
+
+#. fH4Yt
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id151586208604536\n"
+"help.text"
+msgid "<input>=CEILING.MATH(-45.67,-2,0)</input> returns -44."
+msgstr ""
+
+#. MGVBD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id971586208611345\n"
+"help.text"
+msgid "<input>=CEILING.MATH(-45.67,+2, 1)</input> returns -46."
+msgstr ""
+
+#. EzE9t
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id921516998608939\n"
+"help.text"
+msgid "<bookmark_value>CEILING.XCL function</bookmark_value>"
+msgstr ""
+
+#. CRMmT
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id411516998838823\n"
+"help.text"
+msgid "<variable id=\"CEILING.XCLh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingxcl\" name=\"CEILING.XCL\">CEILING.XCL</link></variable>"
+msgstr ""
+
+#. 2tuD3
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id811516998845826\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. tAyJj
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id361586213828675\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a positive significance value, the function rounds up (towards zero). For a negative number and a negative significance value, the function rounds down (away from zero). The function returns an error if the number is positive and the significance value is negative."
+msgstr ""
+
+#. 2CKjm
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id881586213934118\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s CEILING.XCL function are exported as references to Excel’s CEILING function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s CEILING function are imported as references to Calc’s CEILING.XCL function."
+msgstr ""
+
+#. GspBr
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id251516998856873\n"
+"help.text"
+msgid "CEILING.XCL(Number; Significance)"
+msgstr ""
+
+#. eTSgx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id151516998882622\n"
+"help.text"
+msgid "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded."
+msgstr ""
+
+#. 6n7qn
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id421586214128242\n"
+"help.text"
+msgid "<input>=CEILING.XCL(3.45,2)</input> returns 4."
+msgstr ""
+
+#. SZYUC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id651586214132234\n"
+"help.text"
+msgid "<input>=CEILING.XCL(-45.67,2)</input> returns -44."
+msgstr ""
+
+#. pz8Go
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id811586214136666\n"
+"help.text"
+msgid "<input>=CEILING.XCL(-45.67,-2)</input> returns -46."
+msgstr ""
+
+#. GMzhD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id8952518\n"
+"help.text"
+msgid "<bookmark_value>ISO.CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>"
+msgstr ""
+
+#. q22aC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id8952518\n"
+"help.text"
+msgid "<variable id=\"ISO.CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\" name=\"ISO.CEILING\">ISO.CEILING</link></variable>"
+msgstr ""
+
+#. 5beBC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id8953422\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. SFZNu
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id101586214229587\n"
+"help.text"
+msgid "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored."
+msgstr ""
+
+#. qu8FG
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id821586214265060\n"
+"help.text"
+msgid "This function calculates identical results to the <link href=\"#Section311\" name=\"ceilingprecise\">CEILING.PRECISE</link> function."
+msgstr ""
+
+#. LZzHU
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id8953454\n"
+"help.text"
+msgid "ISO.CEILING(Number[; Significance])"
+msgstr ""
+
+#. hwhCW
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id8955000\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. FSFdP
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id801586214431463\n"
+"help.text"
+msgid "<input>=ISO.CEILING(3.45)</input> returns 4."
+msgstr ""
+
+#. ENMYD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id181586214438808\n"
+"help.text"
+msgid "<input>=ISO.CEILING(-45.67,2)</input> returns 44."
+msgstr ""
+
#. GuEcB
#: func_color.xhp
msgctxt ""
@@ -56950,14 +56914,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_TAGE360\">Returns the difference between two dates based on the 360 day year used in interest calculations.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_TAGE360\">Devuelve la diferencia entre dos fechas basándose en el año de 360 días usado en los cálculos de intereses.</ahelp>"
-#. ow4Jg
+#. Vndiw
#: func_days360.xhp
msgctxt ""
"func_days360.xhp\n"
"par_id3155313\n"
"help.text"
-msgid "DAYS360(\"Date1\"; \"Date2\"; Type)"
-msgstr "DIAS360(\"Fecha1\"; \"Fecha2\"; Tipo)"
+msgid "DAYS360(Date1; Date2[; Type])"
+msgstr ""
#. 5qfGz
#: func_days360.xhp
@@ -57607,6 +57571,429 @@ msgctxt ""
msgid "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19."
msgstr ""
+#. aACGP
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"tit\n"
+"help.text"
+msgid "FLOOR Functions"
+msgstr ""
+
+#. RuCRw
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id391586285373874\n"
+"help.text"
+msgid "FLOOR Functions"
+msgstr ""
+
+#. hkrkw
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id3157404\n"
+"help.text"
+msgid "<bookmark_value>FLOOR function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
+msgstr ""
+
+#. KoqGL
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id3157404\n"
+"help.text"
+msgid "<variable id=\"FLOORh1\"><link href=\"text/scalc/01/func_floor.xhp#floor\" name=\"FLOOR\">FLOOR</link></variable>"
+msgstr ""
+
+#. VSV8H
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157432\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. 345Fr
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id661586285977707\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
+msgstr ""
+
+#. 2haGU
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157464\n"
+"help.text"
+msgid "FLOOR(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. ERf3D
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3153467\n"
+"help.text"
+msgid "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number."
+msgstr ""
+
+#. 8w8tL
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157497\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>."
+msgstr ""
+
+#. qCpHR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157517\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded up (towards zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded down (away from zero)."
+msgstr ""
+
+#. 5kHtR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3163894\n"
+"help.text"
+msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions."
+msgstr ""
+
+#. EU85r
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id761586287595376\n"
+"help.text"
+msgid "<input>=FLOOR(3.45)</input> returns 3."
+msgstr ""
+
+#. vuJc5
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id311586287600048\n"
+"help.text"
+msgid "<input>=FLOOR(3.45, 3)</input> returns 3."
+msgstr ""
+
+#. uTWTb
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id661586287604519\n"
+"help.text"
+msgid "<input>=FLOOR(-1.234)</input> returns -2."
+msgstr ""
+
+#. 8ZGDc
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id741586287608968\n"
+"help.text"
+msgid "<input>=FLOOR(-45.67, -2, 0)</input> returns -46."
+msgstr ""
+
+#. gXsTm
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id431586287616089\n"
+"help.text"
+msgid "<input>=FLOOR(-45.67, -2, 1)</input> returns -44."
+msgstr ""
+
+#. zzTLr
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id811586290952465\n"
+"help.text"
+msgid "<bookmark_value>FLOOR.MATH function</bookmark_value>"
+msgstr ""
+
+#. rEELD
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id1001586287279297\n"
+"help.text"
+msgid "<variable id=\"FLOOR.MATHh1\"><link href=\"text/scalc/01/func_floor.xhp#floormath\" name=\"FLOOR.MATH\">FLOOR.MATH</link></variable>"
+msgstr ""
+
+#. BBjwd
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id721586287302689\n"
+"help.text"
+msgid "Rounds a number to the nearest multiple of a significance value."
+msgstr ""
+
+#. UJLZc
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id311586287323417\n"
+"help.text"
+msgid "For a positive number the function rounds down (towards zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored."
+msgstr ""
+
+#. 4weAd
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id851586287535879\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
+msgstr ""
+
+#. 4DFyG
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id161586287421523\n"
+"help.text"
+msgid "FLOOR.MATH(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. Un6FB
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id231586287448716\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. L9MKT
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id261586287494401\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded up (towards zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded down (away from zero)."
+msgstr ""
+
+#. wCd8C
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id101586287621816\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(3.45)</input> returns 3."
+msgstr ""
+
+#. p27MD
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id771586287627784\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(3.45,-3)</input> returns 3."
+msgstr ""
+
+#. Fehfx
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id981586287632392\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(-1.234)</input> returns -2."
+msgstr ""
+
+#. eQfea
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id631586287637256\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(-45.67,-2, 0)</input> returns -46."
+msgstr ""
+
+#. XXqpS
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id371586287641888\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(-45.67,+2, 1)</input> returns -44."
+msgstr ""
+
+#. 9MJem
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id2957404\n"
+"help.text"
+msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
+msgstr ""
+
+#. niyQj
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id2957404\n"
+"help.text"
+msgid "<variable id=\"FLOOR.PRECISEh1\"><link href=\"text/scalc/01/func_floor.xhp#floorprecise\" name=\"FLOOR.PRECISE\">FLOOR.PRECISE</link></variable>"
+msgstr ""
+
+#. DgQBx
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id2957432\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. NHMnz
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id261586641501175\n"
+"help.text"
+msgid "For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored."
+msgstr ""
+
+#. ni9y2
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id2957464\n"
+"help.text"
+msgid "FLOOR.PRECISE(Number[; Significance])"
+msgstr ""
+
+#. pirHp
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id2957497\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. smFCw
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id981586291388900\n"
+"help.text"
+msgid "<input>=FLOOR.PRECISE(3.45)</input> returns 3."
+msgstr ""
+
+#. Q9vnd
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id831586291395477\n"
+"help.text"
+msgid "<input>=FLOOR.PRECISE(-45.67,2)</input> returns -46."
+msgstr ""
+
+#. HnS5F
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id171586291849333\n"
+"help.text"
+msgid "<bookmark_value>FLOOR.XCL function</bookmark_value>"
+msgstr ""
+
+#. LMEET
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id791586291468176\n"
+"help.text"
+msgid "<variable id=\"FLOOR.XCLh1\"><link href=\"text/scalc/01/func_floor.xhp#floorxcl\" name=\"FLOOR.XCL\">FLOOR.XCL</link></variable>"
+msgstr ""
+
+#. WMsAT
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id521586291476023\n"
+"help.text"
+msgid "Rounds a number to the nearest multiple of a significance value."
+msgstr ""
+
+#. jrymG
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id401586291488768\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative."
+msgstr ""
+
+#. BFXRR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id231586291503319\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function."
+msgstr ""
+
+#. WA7uC
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id491586291532177\n"
+"help.text"
+msgid "FLOOR.XCL(Number; Significance)"
+msgstr ""
+
+#. aRww7
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id761586291578755\n"
+"help.text"
+msgid "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded."
+msgstr ""
+
+#. HXuMo
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id531586291622306\n"
+"help.text"
+msgid "<input>=FLOOR.XCL(3.45,2)</input> returns 2."
+msgstr ""
+
+#. gFyGC
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id361586291628003\n"
+"help.text"
+msgid "<input>=FLOOR.XCL(-45.67,2)</input> returns -46."
+msgstr ""
+
+#. EU7xy
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id801586291641099\n"
+"help.text"
+msgid "<input>=FLOOR.XCL(-45.67,-2)</input> returns -44."
+msgstr ""
+
#. 2YcR7
#: func_forecastetsadd.xhp
msgctxt ""