diff options
Diffstat (limited to 'source/ast/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/ast/helpcontent2/source/text/scalc/01.po | 1041 |
1 files changed, 588 insertions, 453 deletions
diff --git a/source/ast/helpcontent2/source/text/scalc/01.po b/source/ast/helpcontent2/source/text/scalc/01.po index afd94cc6dca..4eccf798c84 100644 --- a/source/ast/helpcontent2/source/text/scalc/01.po +++ b/source/ast/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-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-05-27 11:43+0200\n" +"POT-Creation-Date: 2020-06-10 11:34+0200\n" "PO-Revision-Date: 2020-04-14 06:16+0000\n" "Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n" "Language-Team: Asturian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/ast/>\n" @@ -5831,13 +5831,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_AMORDEGRC\">Calculates the amount of depreciation for a settlement period as degressive amortization.</ahelp> Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here." msgstr "<ahelp hid=\"HID_AAI_FUNC_AMORDEGRC\">Calcula l'importe de la depreciación nun períodu de lliquidación en forma d'amortización degresiva.</ahelp> A diferencia de AMORTIZ.LIN, nesta función utiliza un coeficiente de depreciación independiente de la vida útil depreciable." -#. DEtMa +#. G5ero #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3147427\n" "help.text" -msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])" +msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate [; Basis])" msgstr "" #. bA2pT @@ -5921,13 +5921,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_AMORLINC\">Calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_AMORLINC\">Calcula l'importe de la depreciación nun períodu de lliquidación en forma d'amortización llinial. Si l'activu fixu adquirir mientres el períodu de lliquidación, tener en cuenta l'importe proporcional de la depreciación.</ahelp>" -#. jD9JZ +#. 4PnLu #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3147363\n" "help.text" -msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])" +msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate [; Basis])" msgstr "" #. PsFjE @@ -6020,13 +6020,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">Calculates the accrued interest of a security in the case of periodic payments.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">Calcula l'interés acumuláu d'un valor nel casu de pagos periódicos d'intereses.</ahelp>" -#. yGdCf +#. XHQ2B #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3159092\n" "help.text" -msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency[; Basis])" +msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency [; Basis])" msgstr "" #. PKp6i @@ -6065,14 +6065,23 @@ msgctxt "" msgid "<emph>Rate</emph> (required) is the annual nominal rate of interest (coupon interest rate)" msgstr "<emph>Tasa</emph> ye la tasa d'interés nominal añal (tasa d'interés del cupón)" -#. E6ARG +#. cAMCT #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3156445\n" "help.text" -msgid "<emph>Par</emph> (optional) is the par value of the security." -msgstr "<emph>Nominal</emph> ye'l valor nominal de la garantía." +msgid "<emph>Par</emph> (optional) is the par value of the security. If omitted, a default value of 1000 is used." +msgstr "" + +#. Ne2tH +#: 04060103.xhp +msgctxt "" +"04060103.xhp\n" +"par_id961591171682507\n" +"help.text" +msgid "We recommend that you always specify the value that you require for ACCRINT’s <emph>Par</emph> argument, rather than allowing Calc to apply an arbitrary default. This will make your formula easier to understand and easier to maintain." +msgstr "" #. Vobjm #: 04060103.xhp @@ -6128,13 +6137,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINTM\">Calculates the accrued interest of a security in the case of one-off payment at the settlement date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ACCRINTM\">Calcula l'interés acumuláu d'un valor nel casu d'un pagu únicu na fecha de lliquidación.</ahelp>" -#. zFkiX +#. rrfir #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3147074\n" "help.text" -msgid "ACCRINTM(Issue; Settlement; Rate[; Par][; Basis])" +msgid "ACCRINTM(Issue; Settlement; Rate [; Par [; Basis]])" msgstr "" #. pTobQ @@ -6218,13 +6227,13 @@ 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 cantidá recibida que se paga por un valor a interés fixu nun momentu determináu.</ahelp>" -#. BiDCz +#. D67BM #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3145362\n" "help.text" -msgid "RECEIVED(Settlement; Maturity; Investment; Discount[; Basis])" +msgid "RECEIVED(Settlement; Maturity; Investment; Discount [; Basis])" msgstr "" #. oHAVz @@ -6335,13 +6344,13 @@ msgctxt "" msgid "Enter these values either as numbers, expressions or references. If, for example, interest is paid annually at 8%, but you want to use month as your period, enter 8%/12 under <emph>Rate</emph> and <item type=\"productname\">%PRODUCTNAME</item> Calc with automatically calculate the correct factor." msgstr "Indique los valores en forma de númberos, espresiones o referencies. Si, por exemplu, percibe intereses añales del 8% pero deseya definir como períodu'l mes, introduza 8%/12 nel campu <emph>Tasa</emph> y <item type=\"productname\">%PRODUCTNAME</item> Calc calcula automáticamente el factor correctu." -#. uiDaD +#. 4cBxj #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3150395\n" "help.text" -msgid "PV(Rate; NPer; Pmt[; FV][; Type])" +msgid "PV(Rate; NPer; Pmt [; FV [; Type]])" msgstr "" #. JrCA6 @@ -7010,13 +7019,13 @@ 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 (descuentu) d'un valor en forma de porcentaxe.</ahelp>" -#. fBGBA +#. nkAEs #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3149756\n" "help.text" -msgid "DISC(Settlement; Maturity; Price; Redemption[; Basis])" +msgid "DISC(Settlement; Maturity; Price; Redemption [; Basis])" msgstr "" #. Uyj29 @@ -7100,13 +7109,13 @@ 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, n'años, d'un valor d'interés fixu.</ahelp>" -#. 7ixum +#. voaL4 #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3153373\n" "help.text" -msgid "DURATION(Settlement; Maturity; Coupon; Yield; Frequency[; Basis])" +msgid "DURATION(Settlement; Maturity; Coupon; Yield; Frequency [; Basis])" msgstr "" #. JeeVp @@ -7361,13 +7370,13 @@ msgctxt "" msgid "Use this form of depreciation if you require a higher initial depreciation value as opposed to linear depreciation. The depreciation value gets less with each period and is usually used for assets whose value loss is higher shortly after purchase (for example, vehicles, computers). Please note that the book value will never reach zero under this calculation type." msgstr "Esta forma de depreciación ye l'afayadiza si precisa un valor más altu de depreciación inicial, a diferencia de la depreciación llinial. El valor de depreciación mengua con cada períodu; suel utilizase naquellos activos que pierden más valor pocu dempués de la so alquisición (por exemplu, automóviles o equipos informáticos). Tenga en cuenta que'l valor contable nunca va llegar a cero con esti tipu de cálculu." -#. EV3DT +#. veQBT #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3166452\n" "help.text" -msgid "DDB(Cost; Salvage; Life; Period[; Factor])" +msgid "DDB(Cost; Salvage; Life; Period [; Factor])" msgstr "" #. VKnDB @@ -7469,13 +7478,13 @@ msgctxt "" msgid "This form of depreciation is used if you want to get a higher depreciation value at the beginning of the depreciation (as opposed to linear depreciation). The depreciation value is reduced with every depreciation period by the depreciation already deducted from the initial cost." msgstr "Utilice esti mou d'amortización pa llograr, al contrariu que col mou llinial, un valor d'amortización mayor al entamu de l'amortización. Con cada períodu d'amortización, dichu valor amenorgar nes amortizaciones yá deducíes del valor de compra." -#. EDXF8 +#. ExEAy #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3153349\n" "help.text" -msgid "DB(Cost; Salvage; Life; Period[; Month])" +msgid "DB(Cost; Salvage; Life; Period [; Month])" msgstr "" #. caSta @@ -7586,13 +7595,13 @@ msgctxt "" msgid "If the payments take place at irregular intervals, use the <link href=\"text/scalc/01/04060118.xhp#xirr\" name=\"XIRR\">XIRR</link> function." msgstr "" -#. zWTAW +#. MXALn #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3155427\n" "help.text" -msgid "IRR(Values[; Guess])" +msgid "IRR(Values [; Guess])" msgstr "" #. o9R77 @@ -8342,13 +8351,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_IFERROR\">Returns the value if the cell does not contains an error value, or the alternative value if it does.</ahelp>" msgstr "" -#. ZUEHF +#. LREwJ #: 04060104.xhp msgctxt "" "04060104.xhp\n" "par_id31531551\n" "help.text" -msgid "IFERROR(Value;Alternate_value)" +msgid "IFERROR(Value; Alternate_value)" msgstr "" #. wJRYc @@ -8891,13 +8900,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_IFNA\">Returns the value if the cell does not contains the #N/A (value not available) error value, or the alternative value if it does.</ahelp>" msgstr "" -#. pykHc +#. hQbWy #: 04060104.xhp msgctxt "" "04060104.xhp\n" "par_id31537481\n" "help.text" -msgid "IFNA(Value;Alternate_value)" +msgid "IFNA(Value; Alternate_value)" msgstr "" #. 6oj7E @@ -9449,13 +9458,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZELLE\">Returns information on address, formatting or contents of a cell.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZELLE\">Devuelve información alrodiu de la direición, el formatu y el conteníu d'una caxella.</ahelp>" -#. RWBPC +#. Vwajg #: 04060104.xhp msgctxt "" "04060104.xhp\n" "par_id3147355\n" "help.text" -msgid "CELL(\"InfoType\"[; Reference])" +msgid "CELL(\"InfoType\" [; Reference])" msgstr "" #. wjBKt @@ -10196,13 +10205,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WENN\">Specifies a logical test to be performed.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_WENN\">Especifica una prueba lóxica que tien de llevase a cabu.</ahelp>" -#. qT9mo +#. ABZhn #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3154558\n" "help.text" -msgid "IF(Test[; ThenValue][; OtherwiseValue])" +msgid "IF(Test [; ThenValue [; OtherwiseValue]])" msgstr "" #. JnjcT @@ -11780,14 +11789,14 @@ msgctxt "" msgid "EXP" msgstr "EXP" -#. KCAqu +#. N7FBG #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3150592\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_EXP\">Returns e raised to the power of a number.</ahelp> The constant e has a value of approximately 2.71828182845904." -msgstr "<ahelp hid=\"HID_FUNC_EXP\">Devuelve la resultancia d'alzar un númberu a una potencia.</ahelp> La constante y tien un valor averáu de 2,71828182845904." +msgid "<ahelp hid=\"HID_FUNC_EXP\">Returns <literal>e</literal> raised to the power of a number.</ahelp> The constant <literal>e</literal> has a value of approximately 2.71828182845904." +msgstr "" #. KxMFL #: 04060106.xhp @@ -11807,14 +11816,14 @@ msgctxt "" msgid "<emph>Number</emph> is the power to which e is to be raised." msgstr "<emph>Númberu</emph> ye la potencia a la que se va alzar el númberu y." -#. b8tDe +#. LfQsb #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3156340\n" "help.text" -msgid "<item type=\"input\">=EXP(1)</item> returns 2.71828182845904, the mathematical constant e to Calc's accuracy." -msgstr "<item type=\"input\">=EXP(1)</item> devuelve 2,71828182845904, la constante matemática y cola precisión de Calc." +msgid "<item type=\"input\">=EXP(1)</item> returns 2.71828182845904, the mathematical constant <literal>e</literal> to Calc's accuracy." +msgstr "" #. MSQJQ #: 04060106.xhp @@ -12581,14 +12590,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LOG\">Returns the logarithm of a number to the specified base.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_LOG\">Devuelve'l llogaritmu d'un númberu na base especificada.</ahelp>" -#. WE376 +#. ShWCR #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3144732\n" "help.text" -msgid "LOG(Number; Base)" -msgstr "LOG(Númberu; Base)" +msgid "LOG(Number[; Base])" +msgstr "" #. Eiqiq #: 04060106.xhp @@ -12878,14 +12887,14 @@ msgctxt "" msgid "<ahelp hid=\".\">Sums the first terms of a power series.</ahelp>" msgstr "<ahelp hid=\".\">Suma'l primera termino d'una serie de potencies.</ahelp>" -#. FhwbB +#. PffuD #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3152708\n" "help.text" -msgid "SERIESSUM(x;n;m;coefficients) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m)" -msgstr "SUMA SERIES(x;n;m;coeficientes) = coeficiente_1*x^n + coeficiente_2*x^(n+m) + coeficiente_3*x^(n+2m) +...+ coeficiente_i*x^(n+(i-1)m)" +msgid "SERIESSUM(x;n;m;c) = c<sub>1</sub>x<sup>n</sup> + c<sub>2</sub>x<sup>n+m</sup> + c<sub>3</sub>x<sup>n+2m</sup> + ... + c<sub>i</sub>x<sup>n + (i-1)m</sup>." +msgstr "" #. BM5eM #: 04060106.xhp @@ -13238,14 +13247,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RUNDEN\">Rounds a number to a certain number of decimal places.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RUNDEN\">Devuelve un númberu arrondáu hasta una cantidá determinada de decimales.</ahelp>" -#. qcUKc +#. p64i9 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3158182\n" "help.text" -msgid "ROUND(Number; Count)" -msgstr "ARREDONDIAR(Númberu; Cuntar)" +msgid "ROUND(Number[; Count])" +msgstr "" #. yE5Jb #: 04060106.xhp @@ -13337,14 +13346,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Rounds a number down, toward zero, to a certain precision.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Arredondia un númberu escontra baxo, escontra cero.</ahelp>" -#. mJpd7 +#. uqe8Y #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3146051\n" "help.text" -msgid "ROUNDDOWN(Number; Count)" -msgstr "ARREDONDIAR.MENOS(Númberu; Cuntar)" +msgid "ROUNDDOWN(Number[; Count])" +msgstr "" #. EXn4P #: 04060106.xhp @@ -13427,14 +13436,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Rounds a number up, away from zero, to a certain precision.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Devuelve un númberu arrondáu escontra riba hasta'l númberu especificáu de decimales.</ahelp>" -#. yz63F +#. smgCC #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3163328\n" "help.text" -msgid "ROUNDUP(Number; Count)" -msgstr "ARREDONDIAR.MAS(Númberu; Cuntar)" +msgid "ROUNDUP(Number[; Count])" +msgstr "" #. x59Ls #: 04060106.xhp @@ -13904,14 +13913,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value." msgstr "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Amiesta les caxelles especificaes por un criteriu determináu.</ahelp> Esta función usar pa guetar nuna área un determináu valor." -#. Uy4kZ +#. PcPNo #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3152028\n" "help.text" -msgid "SUMIF(Range; Criteria; SumRange)" -msgstr "SUMAR.SI(Rangu; Criteriu; Suma de Rangu)" +msgid "SUMIF(Range; Criteria[; SumRange])" +msgstr "" #. rYzXG #: 04060106.xhp @@ -14426,14 +14435,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Converts between old European national currency and to and from Euros.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Convierte ente les monedes nacionales europees antigües y los euros.</ahelp>" -#. S3ToS +#. qh8S5 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3143748\n" "help.text" -msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\", full_precision, triangulation_precision)" -msgstr "EUROCONVERT(Valor; \"De_moneda\"; \"A_moneda\", precisión_completa, precisión_triangulación)" +msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\"[; full_precision][; triangulation_precision])" +msgstr "" #. 4KJUc #: 04060106.xhp @@ -14912,14 +14921,14 @@ msgctxt "" msgid "<item type=\"input\">=SQRTPI(2)</item> returns the squareroot of (2PI), approximately 2.506628." msgstr "<item type=\"input\">=RAIZ2PI(2)</item> devuelve'l raigañu cuadráu de (2PI), aprosimao 2,506628." -#. TvMZY +#. en4Ae #: 04060106.xhp msgctxt "" "04060106.xhp\n" "bm_id3164669\n" "help.text" -msgid "<bookmark_value>random numbers; between limits</bookmark_value> <bookmark_value>RANDBETWEEN function</bookmark_value>" -msgstr "<bookmark_value>númberos aleatorios;ente llendes</bookmark_value><bookmark_value>ALEATORIU.ENTE</bookmark_value>" +msgid "<bookmark_value>random numbers; between limits</bookmark_value><bookmark_value>RANDBETWEEN function</bookmark_value>" +msgstr "" #. vqzRX #: 04060106.xhp @@ -14984,14 +14993,77 @@ msgctxt "" msgid "<item type=\"input\">=RANDBETWEEN(20;30)</item> returns an integer of between 20 and 30." msgstr "<item type=\"input\">=ALEATORIU.ENTE(20;30)</item> devuelve un enteru ente 20 y 30." -#. CBgxC +#. Dmk3R +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"bm_id461590241346526\n" +"help.text" +msgid "<bookmark_value>random numbers non-volatile; between limits</bookmark_value><bookmark_value>RANDBETWEEN.NV function</bookmark_value>" +msgstr "" + +#. cgHiZ +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id171590240366277\n" +"help.text" +msgid "RANDBETWEEN.NV" +msgstr "" + +#. Akjyr +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id391590240473510\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_RANDBETWEEN_NV\">Returns an non-volatile integer random number in a specified range.</ahelp>" +msgstr "" + +#. GTDa4 +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id181590240522012\n" +"help.text" +msgid "RANDBETWEEN.NV(Bottom; Top)" +msgstr "" + +#. q82vw +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id91590242400917\n" +"help.text" +msgid "Returns an non-volatile integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive). A non-volatile function is not recalculated at new input events or pressing <keycode>F9</keycode>. However, the function is recalculated when pressing <keycode>F9</keycode> with the cursor on the cell containing the function, when opening the file, and when <emph>Top</emph> or <emph>Bottom</emph> are recalculated." +msgstr "" + +#. AngvN +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id151590240999839\n" +"help.text" +msgid "<input>=RANDBETWEEN.NV(20;30)</input> returns a non-volatile integer between 20 and 30." +msgstr "" + +#. cAQDh +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id1001590241005601\n" +"help.text" +msgid "<input>=RANDBETWEEN.NV(A1;30)</input> returns a non-volatile integer between the value of cell A1 and 30. The function is recalculated when the contents of cell A1 change." +msgstr "" + +#. odp65 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "bm_id3164800\n" "help.text" -msgid "<bookmark_value>RAND function</bookmark_value> <bookmark_value>random numbers;between 0 and 1</bookmark_value>" -msgstr "<bookmark_value>ALEATORIU</bookmark_value><bookmark_value>númberos aleatorios;ente 0 y 1</bookmark_value>" +msgid "<bookmark_value>RAND function</bookmark_value><bookmark_value>random numbers;between 0 and 1</bookmark_value>" +msgstr "" #. tTc7D #: 04060106.xhp @@ -15029,14 +15101,41 @@ msgctxt "" msgid "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9." msgstr "" -#. Bb7HL +#. HAWnR #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id9312417\n" "help.text" -msgid "To generate random numbers which never recalculate, copy cells each containing =RAND(), and use <item type=\"menuitem\">Edit - Paste Special</item> (with <item type=\"menuitem\">Paste All</item> and <item type=\"menuitem\">Formulas</item> not marked and <item type=\"menuitem\">Numbers</item> marked)." -msgstr "Pa xenerar númberos aleatorios que nunca recalcular, copie'l conteníu de cada caxella ALEATORIU(), y use <item type=\"menuitem\">Editar - Pegáu especial</item> (with <item type=\"menuitem\">Apegar too</item> y <item type=\"menuitem\">Fórmules</item> non marcaes y <item type=\"menuitem\">Númberos</item> marcaos)." +msgid "To generate random numbers which never recalculate, either:" +msgstr "" + +#. Ap4DT +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id451590242105253\n" +"help.text" +msgid "Copy cells each containing =RAND(), and use <menuitem>Edit - Paste Special</menuitem> (with <emph>Paste All</emph> and <emph>Formulas</emph> not marked and <emph>Numbers</emph> marked)." +msgstr "" + +#. zEFCC +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id801590242114296\n" +"help.text" +msgid "Use the Fill Cell command with random numbers (<menuitem>Sheet - Fill Cells - Fill Random Numbers</menuitem>)." +msgstr "" + +#. o9wUN +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id41590242118383\n" +"help.text" +msgid "Use the RAND.NV() function for non-volatile random numbers." +msgstr "" #. BLkte #: 04060106.xhp @@ -15047,6 +15146,60 @@ msgctxt "" msgid "<item type=\"input\">=RAND()</item> returns a random number between 0 and 1." msgstr "<item type=\"input\">=ALEATORIU()</item> da como resultáu un númberu aleatoriu ente 0 y 1." +#. CqVpJ +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"bm_id341590241488944\n" +"help.text" +msgid "<bookmark_value>random numbers non-volatile;between 0 and 1</bookmark_value><bookmark_value>RAND.NV function</bookmark_value>" +msgstr "" + +#. q9iLd +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id71590238179170\n" +"help.text" +msgid "RAND.NV" +msgstr "" + +#. Fc2hv +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id101590238875834\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_RAND_NV\">Returns a non-volatile random number between 0 and 1.</ahelp>" +msgstr "" + +#. dchBL +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id391590238945182\n" +"help.text" +msgid "RAND.NV()" +msgstr "" + +#. QARNV +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id271590239748534\n" +"help.text" +msgid "This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events. The function does not recalculate when pressing <keycode>F9</keycode>, except when the cursor is on the cell containing the function. The function is recalculated when opening the file." +msgstr "" + +#. sCwno +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id191590241215013\n" +"help.text" +msgid "<input>=RAND.NV()</input> returns a non-volatile random number between 0 and 1." +msgstr "" + #. Zsp2R #: 04060107.xhp msgctxt "" @@ -16181,14 +16334,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RGP\">Returns a table of statistics for a straight line that best fits a data set.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RGP\">Retorna una tabla d'estadístiques pa Returns a table of statistics for a una llinia recta que meyor s'axuste a un conxuntu de datos .</ahelp>" -#. VTZV4 +#. 7YFEn #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3152839\n" "help.text" -msgid "LINEST(data_Y; data_X; linearType; stats)" -msgstr "ESTIMACIÓN.LLINEAL(Datos_Y; Datos_X; tipu_llinial; estadística)" +msgid "LINEST(data_Y [; data_X [; linearType [; stats]]])" +msgstr "" #. M2QFp #: 04060107.xhp @@ -16649,14 +16802,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RKP\">This function calculates the adjustment of the entered data as an exponential regression curve (y=b*m^x).</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RKP\">Esta función calcula l'axuste de los datos introducíos como curva de regresión esponencial (y=b*m^x).</ahelp>" -#. VFJDG +#. rdZCV #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3163123\n" "help.text" -msgid "LOGEST(DataY; DataX; FunctionType; Stats)" -msgstr "ESTIMACIÓN.LOGARÍTMICA(DatosY; DatosX; TipodeFunción; Estadística)" +msgid "LOGEST(DataY [; DataX [; FunctionType [; Stats]]])" +msgstr "" #. 8jgzC #: 04060107.xhp @@ -16991,14 +17144,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_TREND\">Returns values along a linear trend.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_TREND\">Devuelve valores siguiendo un enclín llinial.</ahelp>" -#. nuyCr +#. f8Ftr #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3166122\n" "help.text" -msgid "TREND(DataY; DataX; NewDataX; LinearType)" -msgstr "ENCLÍN(DatosY; DatosX; NuevosDatosX; TipodeLinea)" +msgid "TREND(DataY [; DataX [; NewDataX [; LinearType]]])" +msgstr "" #. qeK4r #: 04060107.xhp @@ -17072,14 +17225,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIATION\">Calculates the points of an exponential trend in an array.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIATION\">Calcula los puntos d'un enclín esponencial nuna matriz.</ahelp>" -#. kbYCk +#. 8VMBq #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3166377\n" "help.text" -msgid "GROWTH(DataY; DataX; NewDataX; FunctionType)" -msgstr "CRECEDERA(DatosY; DatosX; NuevosDatosX; FunctionType)" +msgid "GROWTH(DataY [; DataX [; NewDataX [; FunctionType]]])" +msgstr "" #. CA3qD #: 04060107.xhp @@ -17342,14 +17495,14 @@ msgctxt "" msgid "The INDIRECT function is saved without conversion to ODF 1.0/1.1 format. If the second parameter was present, an older version of Calc will return an error for that function." msgstr "La función INDIRECTU guardar ensin conversión al formatu ODF 1.0/1.1 Si ta presente'l segundu parámetru, una versión antigua de Calc va retornar un fallu pa esa función ." -#. UnrfB +#. TgFFT #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3154707\n" "help.text" -msgid "ADDRESS(Row; Column; Abs; A1; \"Sheet\")" -msgstr "DIREICIÓN(Filera; Columna; Abs; \"Fueya\")" +msgid "ADDRESS(Row; Column [; Abs [; A1 [; \"Sheet\"]]])" +msgstr "" #. FyoLc #: 04060109.xhp @@ -17558,14 +17711,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_DDE\">Returns the result of a DDE-based link.</ahelp> If the contents of the linked range or section changes, the returned value will also change. You must reload the spreadsheet or choose <emph>Edit - Links</emph> to see the updated links. Cross-platform links, for example from a <item type=\"productname\">%PRODUCTNAME</item> installation running on a Windows machine to a document created on a Linux machine, are not allowed." msgstr "<ahelp hid=\"HID_FUNC_DDE\">Devuelve la resultancia d'un enllaz basáu en DDE.</ahelp> Si'l conteníu del área o seición enllazada modifícase, el valor devueltu tamién va camudar. Pa ver los enllaces anovaos tien de volvese a cargar la fueya de cálculu o escoyer <emph>Editar - Enllaces</emph>. Nun se dexa definir enllaces ente plataformes distintes, por exemplu enllazar dende una instalación de <item type=\"productname\">%PRODUCTNAME</item> nuna máquina Windows un documentu creáu nuna máquina Linux." -#. RarPk +#. JBRdm #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3148886\n" "help.text" -msgid "DDE(\"Server\"; \"File\"; \"Range\"; Mode)" -msgstr "DDE(\"Sirvidor \"Ficheru\"; \"Área\"; Mou)" +msgid "DDE(\"Server\"; \"File\"; \"Range\" [; Mode])" +msgstr "" #. qAN6x #: 04060109.xhp @@ -17783,14 +17936,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_INDEX\">INDEX returns a sub range, specified by row and column number, or an optional range index. Depending on context, INDEX returns a reference or content.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_INDEX\">ÍNDIZ devuelve un sub rangu, especificáu pol númberu de filera y columna, o por un índiz de rangu opcional. Dependiendo del contestu, ÍNDIZ devuelve una referencia o conteníu.</ahelp>" -#. GSBMC +#. T659Y #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149007\n" "help.text" -msgid "INDEX(Reference; Row; Column; Range)" -msgstr "ÍNDIZ(Referencia; Filera; Columna; Área)" +msgid "INDEX(Reference [; Row [; Column [; Range]]])" +msgstr "" #. Btvgz #: 04060109.xhp @@ -17918,14 +18071,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_INDIREKT\">Returns the <emph>reference</emph> specified by a text string.</ahelp> This function can also be used to return the area of a corresponding string." msgstr "<ahelp hid=\"HID_FUNC_INDIREKT\">Devuelve la <emph>referencia</emph> especificada por una cadena de testu.</ahelp> Esta función tamién pue utilizase pa calcular l'área de la cadena correspondiente." -#. CFFmo +#. hDCWQ #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149824\n" "help.text" -msgid "INDIRECT(Ref; A1)" -msgstr "INDIRECTU(Ref, A1)" +msgid "INDIRECT(Ref [; A1])" +msgstr "" #. cZG9F #: 04060109.xhp @@ -17999,14 +18152,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SPALTE\">Returns the column number of a cell reference.</ahelp> If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row <link href=\"text/scalc/01/04060107.xhp#wasmatrix\" name=\"array\">array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#somatrixformel\" name=\"as an array formula\">as an array formula</link>. If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined." msgstr "<ahelp hid=\"HID_FUNC_SPALTE\">Devuelve'l númberu de columna d'una referencia de caxella.</ahelp> Si la referencia ye una caxella, devuélvese'l so númberu de columna; si'l parámetru ye una área, devuélvense los númberos de columna correspondientes en forma de <link href=\"text/scalc/01/04060107.xhp#wasmatrix\" name=\"matriz\">matriz</link> d'una sola filera cuando la fórmula escríbese como <link href=\"text/scalc/01/04060107.xhp#somatrixformel\" name=\"as an array formula\">fórmula de matriz</link>. Si nuna fórmula de matriz nun s'utiliza la función COLUMNA con un parámetru de referencia d'área, namái se determina'l númberu de columna de la primer caxella del área." -#. WjjYp +#. poCRX #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149447\n" "help.text" -msgid "COLUMN(Reference)" -msgstr "COLUMNA(Referencia)" +msgid "COLUMN([Reference])" +msgstr "" #. CAB6L #: 04060109.xhp @@ -18179,13 +18332,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <item type=\"literal\">Index</item>. If the <item type=\"literal\">Sorted</item> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <item type=\"literal\">SearchCriterion</item> is not found, the last value that is smaller than the criterion will be returned. If <item type=\"literal\">Sorted</item> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." msgstr "" -#. qkLkD +#. 8FhyJ #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3150156\n" "help.text" -msgid "=VLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)" +msgid "=VLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])" msgstr "" #. 7FsgG @@ -18287,14 +18440,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula." msgstr "<ahelp hid=\"HID_FUNC_TABELLE\">Devuelve'l númberu de fueya d'una referencia o una cadena que representa un nome de fueya.</ahelp> Si nun especifica nengún parámetru, la resultancia ye'l númberu de la fueya de cálculu que contién la fórmula." -#. 4WMzx +#. KRzAZ #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3153095\n" "help.text" -msgid "SHEET(Reference)" -msgstr "FUEYA(referencia)" +msgid "SHEET([Reference])" +msgstr "" #. 9yCD8 #: 04060109.xhp @@ -18341,14 +18494,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_TABELLEN\">Determines the number of sheets in a reference.</ahelp> If you do not enter any parameters, it returns the number of sheets in the current document." msgstr "<ahelp hid=\"HID_FUNC_TABELLEN\">Determina'l númberu de fueyes d'una referencia.</ahelp> Si nun especifica nengún parámetru, devuelve'l númberu de fueyes del documentu actual." -#. EfUeE +#. j5Aps #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3150777\n" "help.text" -msgid "SHEETS(Reference)" -msgstr "FUEYES(referencia)" +msgid "SHEETS([Reference])" +msgstr "" #. 5B3KF #: 04060109.xhp @@ -18395,14 +18548,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VERGLEICH\">Returns the relative position of an item in an array that matches a specified value.</ahelp> The function returns the position of the value found in the lookup_array as a number." msgstr "<ahelp hid=\"HID_FUNC_VERGLEICH\">Devuelve la posición relativa d'un elementu d'una matriz que coincide col valor especificáu.</ahelp> La función devuelve, en forma de númberu, la posición del valor atopáu en guetar_matriz." -#. Rg5W8 +#. FsB8G #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3159152\n" "help.text" -msgid "MATCH(SearchCriterion; LookupArray; Type)" -msgstr "COINCIDIR(CriteriodeBúsqueda; GuetarMatriz; tipu_de_coincidencia)" +msgid "MATCH(SearchCriterion; LookupArray [; Type])" +msgstr "" #. BmVBr #: 04060109.xhp @@ -18485,14 +18638,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Devuelve'l valor d'una caxella movida una determinada cantidá de fileres y columnes d'un puntu de referencia concretu.</ahelp>" -#. CHJcg +#. nED4F #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3159194\n" "help.text" -msgid "OFFSET(Reference; Rows; Columns; Height; Width)" -msgstr "DESREF(Referencia; Files; Columnes; Alto; Anchu)" +msgid "OFFSET(Reference; Rows; Columns [; Height [; Width]])" +msgstr "" #. 3Q5gL #: 04060109.xhp @@ -18656,14 +18809,14 @@ msgctxt "" msgid "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." msgstr "Si LOOKUP nun pue atopar el criteriu de busca, utiliza'l valor más grande del vector de busca que seya menor o igual que criteriu de busca." -#. eqrFF +#. 4nBA6 #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3154104\n" "help.text" -msgid "LOOKUP(SearchCriterion; SearchVector; ResultVector)" -msgstr "BUSCAR(CriteriodeBúsqueda; VectordeBúsqueda; VectordeResultado)" +msgid "LOOKUP(SearchCriterion; SearchVector [; ResultVector])" +msgstr "" #. QdiFz #: 04060109.xhp @@ -18728,14 +18881,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VORLAGE\">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()>3;\"red\";\"green\")) applies the style \"red\" to the cell if the value is greater than 3, otherwise the style \"green\" is applied. Both cell formats, \"red\" and \"green\" have to be defined beforehand." msgstr "" -#. gNaP4 +#. gU3TE #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149302\n" "help.text" -msgid "STYLE(\"Style\"; Time; \"Style2\")" -msgstr "ESTILU(\"Estilu\"; Tiempu \"Estilu2\")" +msgid "STYLE(\"Style\" [; Time [; \"Style2\"]])" +msgstr "" #. Q8SMG #: 04060109.xhp @@ -18827,31 +18980,31 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_WAHL\">Utiliza un índiz pa producir un valor a partir d'una llista formada por hasta 30 valores.</ahelp>" -#. g9AE7 +#. r7bDk #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3155425\n" "help.text" -msgid "CHOOSE(Index; Value1; ...; Value30)" -msgstr "ESCOYER(Índiz; Valor1; ...; Valor30)" +msgid "CHOOSE(Index; Value1 [; Value2 [; ... [; Value254]]])" +msgstr "" -#. CNK7e +#. dt8SY #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3144755\n" "help.text" -msgid "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list." -msgstr "<emph>Índiz</emph> ye una referencia o númberu ente 1 y 30 qu'indica'l valor que se va a tomar de la llista." +msgid "<emph>Index</emph> is a reference or number between 1 and 254 indicating which value is to be taken from the list." +msgstr "" -#. jnAAs +#. nR3mX #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149939\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> is the list of values entered as a reference to a cell or as individual values." +msgid "<emph>Value1, Value2, ..., Value254</emph> is the list of values entered as a reference to a cell or as individual values." msgstr "" #. s64Du @@ -18890,13 +19043,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." msgstr "<ahelp hid=\"HID_FUNC_WVERWEIS\">Busca un valor y una referencia a les caxelles asitiaes per debaxo del área escoyida.</ahelp> Esta función comprueba si la primer filera d'una matriz contién un ciertu valor. La función devuelve'l valor asitiáu nuna filera de la matriz, indicada en <emph>Índiz</emph>, na mesma columna." -#. yxeCS +#. y6is6 #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3146070\n" "help.text" -msgid "HLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)" +msgid "HLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])" msgstr "" #. nhwwF @@ -18935,14 +19088,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZEILE\">Returns the row number of a cell reference.</ahelp> If the reference is a cell, it returns the row number of the cell. If the reference is a cell range, it returns the corresponding row numbers in a one-column <link href=\"text/scalc/01/04060107.xhp#wasmatrix\" name=\"Array\">Array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#somatrixformel\" name=\"as an array formula\">as an array formula</link>. If the ROW function with a range reference is not used in an array formula, only the row number of the first range cell will be returned." msgstr "<ahelp hid=\"HID_FUNC_ZEILE\">Devuelve'l númberu de filera d'una referencia de caxella.</ahelp> Si la referencia ye una caxella, devuelve'l númberu de filera de la caxella. Si la referencia ye una área de caxelles, devuelve los númberos de filera correspondientes nuna <link href=\"text/scalc/01/04060107.xhp#wasmatrix\" name=\"Array\">matriz</link> d'una columna, si la fórmula escríbese como <link href=\"text/scalc/01/04060107.xhp#somatrixformel\" name=\"as an array formula\">fórmula de matriz</link>. Si la función FILA con referencia d'área nun s'utiliza nuna fórmula de matriz, namái se devuelve'l númberu de filera de la primer caxella del área." -#. 2F22B +#. 97EEE #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3154916\n" "help.text" -msgid "ROW(Reference)" -msgstr "FILA(Referencia)" +msgid "ROW([Reference])" +msgstr "" #. mSqrb #: 04060109.xhp @@ -19133,14 +19286,14 @@ msgctxt "" msgid "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>." msgstr "P'abrir col tecláu una caxella con hiperenllaz, escueya la caxella, calque F2 p'aportar al mou d'edición, mueva'l cursor delantre del hiperenllaz, calque Mayús + F10 y, de siguío, escueya <emph>Abrir hiperenllaz</emph>." -#. JDWzm +#. BzM9o #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_idN1180E\n" "help.text" -msgid "HYPERLINK(\"URL\") or HYPERLINK(\"URL\"; \"CellText\")" -msgstr "HIPERVÍNCULO(\"URL\") o HIPERVÍNCULO(\"URL\"; \"TestudeCaxella\")" +msgid "HYPERLINK(\"URL\" [; \"CellText\"])" +msgstr "" #. UbAEY #: 04060109.xhp @@ -19664,14 +19817,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BASIS\">Converts a positive integer to a specified base into a text from the <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"numbering system\">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used." msgstr "<ahelp hid=\"HID_FUNC_BASIS\">Convierte un enteru positivu d'una base especificada en testu del <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"numbering system\">sistema numbéricu</link>.</ahelp> Utilícense los díxitos 0-9 y les lletres A-Z." -#. w9kd3 +#. 2cDvi #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3155743\n" "help.text" -msgid "BASE(Number; Radix; [MinimumLength])" -msgstr "BASE(Númberu; Raigañu; [LlonxitúMínima])" +msgid "BASE(Number; Radix [; MinimumLength])" +msgstr "" #. iDR7A #: 04060110.xhp @@ -20105,14 +20258,14 @@ msgctxt "" msgid "You set the currency format in your system settings." msgstr "Tien De establecer el formatu de la divisa na configuración del sistema." -#. hAiEu +#. icFpC #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3154188\n" "help.text" -msgid "DOLLAR(Value; Decimals)" -msgstr "FORGAR(Valor; Decimales)" +msgid "DOLLAR(Value [; Decimals])" +msgstr "" #. WA6bA #: 04060110.xhp @@ -20240,14 +20393,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_FINDEN\">Returns the position of a string of text within another string.</ahelp>You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive." msgstr "" -#. zQDEB +#. Kpkfu #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3083452\n" "help.text" -msgid "FIND(\"FindText\"; \"Text\"; Position)" -msgstr "ATOPAR(\"Atopar_Testu\"; \"Testu\"; Posición)" +msgid "FIND(\"FindText\"; \"Text\" [; Position])" +msgstr "" #. 3HU9t #: 04060110.xhp @@ -20312,14 +20465,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_FEST\">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_FEST\">Devuelve un númberu como testu con un númberu especificáu de decimales y separadores de miles opcionales.</ahelp>" -#. UtELQ +#. CEftz #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147567\n" "help.text" -msgid "FIXED(Number; Decimals; NoThousandsSeparators)" -msgstr "FIXU(númberu; Decimales; Nun dixebrar_millares)" +msgid "FIXED(Number; Decimals [; NoThousandsSeparators])" +msgstr "" #. 5cYW8 #: 04060110.xhp @@ -20456,14 +20609,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LINKS\">Returns the first character or characters of a text.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_LINKS\">Devuelve'l primer caráuter o los primeros caráuteres d'un testu.</ahelp>" -#. wcSFE +#. yAT6p #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3146786\n" "help.text" -msgid "LEFT(\"Text\"; Number)" -msgstr "ESQUIERDA(\"Testu\"; Númberu)" +msgid "LEFT(\"Text\" [; Number])" +msgstr "" #. PGbwK #: 04060110.xhp @@ -20519,13 +20672,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LEFTB\">Returns the first characters of a DBCS text.</ahelp>" msgstr "" -#. 2x4Vt +#. ZcHDR #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2946786\n" "help.text" -msgid "LEFTB(\"Text\"; Number_bytes)" +msgid "LEFTB(\"Text\" [; Number_bytes])" msgstr "" #. e6CdQ @@ -21077,14 +21230,14 @@ msgctxt "" msgid "<emph>Text</emph> refers to the text to be converted." msgstr "<emph>Testu</emph> fai referencia al testu que se debe convertir." -#. CHBWP +#. Nt5dD #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3155364\n" "help.text" -msgid "<item type=\"input\">=PROPER(\"open office\")</item> returns Open Office." -msgstr "<item type=\"input\">=NOMPROPIO(\"open office\")</item> devuelve Open Office." +msgid "<item type=\"input\">=PROPER(\"the document foundation\")</item> returns The Document Foundation." +msgstr "" #. MeADa #: 04060110.xhp @@ -21275,14 +21428,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RECHTS\">Returns the last character or characters of a text.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RECHTS\">Devuelve l'últimu caráuter o los últimos caráuteres d'un testu.</ahelp>" -#. STrAH +#. 3D3E9 #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3154344\n" "help.text" -msgid "RIGHT(\"Text\"; Number)" -msgstr "DERECHA(\"Testu\"; Númberu)" +msgid "RIGHT(\"Text\" [; Number])" +msgstr "" #. dveYp #: 04060110.xhp @@ -21338,13 +21491,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RIGHTB\">Returns the last character or characters of a text with double bytes characters sets (DBCS).</ahelp>" msgstr "" -#. B2AWW +#. 9kB2q #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2954344\n" "help.text" -msgid "RIGHTB(\"Text\"; Number_bytes)" +msgid "RIGHTB(\"Text\" [; Number_bytes])" msgstr "" #. jvjXS @@ -21437,14 +21590,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ROEMISCH\">Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ROEMISCH\">Convierte un númberu en númberos romanos. El valor tien de tar ente 0 y 3999, les maneres puen ser númberos enteros de 0 a 4.</ahelp>" -#. 4bqzs +#. RdCBS #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3150593\n" "help.text" -msgid "ROMAN(Number; Mode)" -msgstr "ROMANU(númberu; mou)" +msgid "ROMAN(Number [; Mode])" +msgstr "" #. 4rcTC #: 04060110.xhp @@ -21545,14 +21698,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SUCHEN\">Returns the position of a text segment within a character string.</ahelp> You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive. If the text is not found, returns error 519 (#VALUE)." msgstr "" -#. FN6o9 +#. GU5p2 #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3154671\n" "help.text" -msgid "SEARCH(\"FindText\"; \"Text\"; Position)" -msgstr "BUSQUEDA(\"FindText\"; \"Testu\"; Posición)" +msgid "SEARCH(\"FindText\"; \"Text\" [; Position])" +msgstr "" #. yP57Q #: 04060110.xhp @@ -21617,14 +21770,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WECHSELN\">Substitutes new text for old text in a string.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_WECHSELN\">Troca un fragmentu de testu por otru nuevu dientro d'una cadena de caráuteres.</ahelp>" -#. L6DKo +#. K2fp5 #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147582\n" "help.text" -msgid "SUBSTITUTE(\"Text\"; \"SearchText\"; \"NewText\"; Occurrence)" -msgstr "SUSTITUYIR(\"Testu\"; \"Guetar_testu\"; \"testu_nuevu\"; Escurrimientu)" +msgid "SUBSTITUTE(\"Text\"; \"SearchText\"; \"NewText\" [; Occurrence])" +msgstr "" #. tydqc #: 04060110.xhp @@ -24506,14 +24659,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_BIN2HEX\">The result is the hexadecimal number for the binary number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_BIN2HEX\">La resultancia ye'l númberu hexadecimal que correspuenda al númberu binariu introducíu.</ahelp>" -#. k5VGV +#. pLG3U #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3148753\n" "help.text" -msgid "BIN2HEX(Number; Places)" -msgstr "BIN2HEX(Númberu; Cifres)" +msgid "BIN2HEX(Number [; Places])" +msgstr "" #. 9ugAE #: 04060115.xhp @@ -24569,14 +24722,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_BIN2OCT\"> The result is the octal number for the binary number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_BIN2OCT\"> La resultancia ye'l númberu octal que correspuenda al númberu binariu introducíu.</ahelp>" -#. 2DBBD +#. 8pRVA #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3154508\n" "help.text" -msgid "BIN2OCT(Number; Places)" -msgstr "DEC.A.OCT(Númberu;decimales)" +msgid "BIN2OCT(Number [; Places])" +msgstr "" #. kBSNf #: 04060115.xhp @@ -24632,14 +24785,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DELTA\">The result is TRUE (1) if both numbers, which are delivered as an argument, are equal, otherwise it is FALSE (0).</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DELTA\">La resultancia ye VERDADERU (1) si ambos argumentos numbéricos son iguales; en casu contrariu, ye FALSU (0).</ahelp>" -#. 73wCN +#. 6s5yD #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3145247\n" "help.text" -msgid "DELTA(Number1; Number2)" -msgstr "DELTA(Númberu1; Númberu2)" +msgid "DELTA(Number1 [; Number2])" +msgstr "" #. PEgQC #: 04060115.xhp @@ -24677,14 +24830,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DEC2BIN\"> The result is the binary number for the decimal number entered between -512 and 511.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DEC2BIN\"> La resultancia ye'l númberu binariu que correspuenda al númberu decimal, ente -512 y 511.</ahelp>" -#. NUeb8 +#. tPFjB #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3150569\n" "help.text" -msgid "DEC2BIN(Number; Places)" -msgstr "DEC.A.BIN(Númberu; Decimales)" +msgid "DEC2BIN(Number [; Places])" +msgstr "" #. Y9mGB #: 04060115.xhp @@ -24740,14 +24893,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DEC2HEX\">The result is the hexadecimal number for the decimal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DEC2HEX\">La resultancia ye'l númberu hexadecimal que correspuenda al númberu decimal introducíu.</ahelp>" -#. 4BMnA +#. T8PpC #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3147535\n" "help.text" -msgid "DEC2HEX(Number; Places)" -msgstr "DEC.A.HEX(Númberu; Decimales)" +msgid "DEC2HEX(Number [; Places])" +msgstr "" #. SQafk #: 04060115.xhp @@ -24803,14 +24956,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DEC2OCT\">The result is the octal number for the decimal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DEC2OCT\">La resultancia ye'l númberu octal que correspuenda al númberu decimal introducíu.</ahelp>" -#. FPyVU +#. 5ecSa #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3148427\n" "help.text" -msgid "DEC2OCT(Number; Places)" -msgstr "DEC.A.OCT(Númberu;decimales)" +msgid "DEC2OCT(Number [; Places])" +msgstr "" #. Fa6gd #: 04060115.xhp @@ -24866,14 +25019,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ERF\">Returns values of the Gaussian error integral.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ERF\">Devuelve los valores del fallu de la integral de Gauss.</ahelp>" -#. nDWWi +#. KmGKW #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3163824\n" "help.text" -msgid "ERF(LowerLimit; UpperLimit)" -msgstr "FUN.ERRU(LímiteInferior; LímiteSuperior)" +msgid "ERF(LowerLimit [; UpperLimit])" +msgstr "" #. TyCGk #: 04060115.xhp @@ -25091,14 +25244,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_GESTEP\">The result is 1 if <item type=\"literal\">Number</item> is greater than or equal to <item type=\"literal\">Step</item>.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_GESTEP\">La resultancia ye 1 si el<item type=\"literal\">Númberu</item> ye mayor o igual al<item type=\"literal\">Pasu</item>.</ahelp>" -#. iE7iA +#. cDDSb #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3145212\n" "help.text" -msgid "GESTEP(Number; Step)" -msgstr "MAYOR.O.IGUAL(númberu; valor estragal)" +msgid "GESTEP(Number [; Step])" +msgstr "" #. QG8JU #: 04060115.xhp @@ -25136,14 +25289,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_HEX2BIN\">The result is the binary number for the hexadecimal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_HEX2BIN\">La resultancia ye'l númberu binariu que correspuenda al númberu hexadecimal introducíu.</ahelp>" -#. UEfgv +#. S4Zyx #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3155847\n" "help.text" -msgid "HEX2BIN(Number; Places)" -msgstr "HEX.A.BIN(Númberu; Decimales)" +msgid "HEX2BIN(Number [; Places])" +msgstr "" #. YzMa9 #: 04060115.xhp @@ -25253,14 +25406,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_HEX2OCT\">The result is the octal number for the hexadecimal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_HEX2OCT\">La resultancia ye'l númberu octal que correspuenda al númberu hexadecimal introducíu.</ahelp>" -#. 5ViJ3 +#. BoGKD #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3151170\n" "help.text" -msgid "HEX2OCT(Number; Places)" -msgstr "HEX.A.OCT(Númberu; Decimales)" +msgid "HEX2OCT(Number [; Places])" +msgstr "" #. 2Uff5 #: 04060115.xhp @@ -26135,14 +26288,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COMPLEX\">The result is a complex number which is returned from a real coefficient and an imaginary coefficient.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COMPLEX\">La resultancia ye un númberu complexu creáu a partir d'un coeficiente real y un coeficiente imaxinariu.</ahelp>" -#. ayftD +#. c2huU #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3155999\n" "help.text" -msgid "COMPLEX(RealNum; INum; Suffix)" -msgstr "COMPLEXU(NúmberuReal; INum; Sufixu)" +msgid "COMPLEX(RealNum; INum [; Suffix])" +msgstr "" #. FCxXC #: 04060116.xhp @@ -26207,14 +26360,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_OCT2BIN\">The result is the binary number for the octal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_OCT2BIN\">La resultancia ye'l númberu binariu pal númberu octal introducíu.</ahelp>" -#. KWCgD +#. BTUGA #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3154303\n" "help.text" -msgid "OCT2BIN(Number; Places)" -msgstr "OCT.A.BIN(Númberu; Decimales)" +msgid "OCT2BIN(Number [; Places])" +msgstr "" #. AbzaY #: 04060116.xhp @@ -26324,14 +26477,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_OCT2HEX\"> The result is the hexadecimal number for the octal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_OCT2HEX\"> La resultancia ye'l númberu hexadecimal que correspuenda al númberu octal introducíu.</ahelp>" -#. FJ4Jp +#. dvEBj #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3150523\n" "help.text" -msgid "OCT2HEX(Number; Places)" -msgstr "OCT.A.DEC(Númberu; Decimales)" +msgid "OCT2HEX(Number [; Places])" +msgstr "" #. XAYGj #: 04060116.xhp @@ -27323,14 +27476,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ODDFPRICE\">Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ODDFPRICE\">Calcula'l preciu de 100 unidaes monetaries por valor d'un títulu, si la fecha del primer interés ye irregular.</ahelp>" -#. SD7Pr +#. BvVwj #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3146098\n" "help.text" -msgid "ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency; Basis)" -msgstr "PRECIU.PER.IRREGULAR.1(Lliquidación; Vencimientu; Emisión; PrimerCupón; Tasa; Rendimientu; Redención; Frecuencia; Base)" +msgid "ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency [; Basis])" +msgstr "" #. kHZM8 #: 04060118.xhp @@ -27431,14 +27584,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ODDFYIELD\">Calculates the yield of a security if the first interest date falls irregularly.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ODDFYIELD\">Calcula'l rendimientu d'un títulu si la fecha del primer interés ye irregular.</ahelp>" -#. GpJqj +#. nGSvB #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3152982\n" "help.text" -msgid "ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency; Basis)" -msgstr "RENDTO.PER.IRREGULAR.1(Lliquidación; Vencimientu; Emisión; PrimerCupón; Tasa; Preciu; Redención; Frecuencia; Base)" +msgid "ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency [; Basis])" +msgstr "" #. nJXTW #: 04060118.xhp @@ -27539,14 +27692,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ODDLPRICE\">Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ODDLPRICE\">Calcula'l preciu de 100 unidaes monetaries por valor d'un títulu, si la fecha del últimu interés ye irregular.</ahelp>" -#. XAt33 +#. ozTCG #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3155262\n" "help.text" -msgid "ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency; Basis)" -msgstr "PRECIU.PER.IRREGULAR.2(Lliquidación; Vencimientu; ÚltimoInterés; Tasa; Rendimientu; Redención; Frecuencia; Base)" +msgid "ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency [; Basis])" +msgstr "" #. iTfu4 #: 04060118.xhp @@ -27665,14 +27818,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ODDLYIELD\">Calculates the yield of a security if the last interest date falls irregularly.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ODDLYIELD\">Calcula'l rendimientu d'un títulu si la fecha del últimu interés ye irregular.</ahelp>" -#. gVBSg +#. pwm9F #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3150018\n" "help.text" -msgid "ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency; Basis)" -msgstr "RENDTO.PER.IRREGULAR.1(Lliquidación; Vencimientu; ÚltimoInteres; Tasa; Preciu; Redención; Frecuencia; Base)" +msgid "ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency [; Basis])" +msgstr "" #. 4X7wa #: 04060118.xhp @@ -27791,13 +27944,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VDB\">Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VDB\">Devuelve la depreciación d'un activu nun períodu especifico o parcial según el métodu xeométricu decreciente.</ahelp>" -#. PiFjC +#. DSd3v #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3149025\n" "help.text" -msgid "VDB(Cost; Salvage; Life; S; End; Factor; NoSwitch)" +msgid "VDB(Cost; Salvage; Life; S; End [; Factor [; NoSwitch]])" msgstr "" #. zGhDb @@ -27917,14 +28070,14 @@ msgctxt "" msgid "If the payments take place at regular intervals, use the <link href=\"text/scalc/01/04060103.xhp#irr\" name=\"IRR\">IRR</link> function." msgstr "" -#. qAG6C +#. CVXB7 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3149826\n" "help.text" -msgid "XIRR(Values; Dates; Guess)" -msgstr "TIR.NON.PER(Valores; Datos; Valor_envaloráu)" +msgid "XIRR(Values; Dates [; Guess])" +msgstr "" #. GoDCv #: 04060118.xhp @@ -28340,14 +28493,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZINS\">Returns the constant interest rate per period of an annuity.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZINS\">Calcula'l tipu d'interés constante d'una añalidá.</ahelp>" -#. 6BqLB +#. wEYqD #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3158423\n" "help.text" -msgid "RATE(NPer; Pmt; PV; FV; Type; Guess)" -msgstr "TASA(NPer; Pagu; VA; VF; Tipu; Valor envaloráu)" +msgid "RATE(NPer; Pmt; PV [ ; [ FV ] [ ; [ Type ] [ ; Guess ] ] ])" +msgstr "" #. kkBfr #: 04060118.xhp @@ -28448,14 +28601,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_INTRATE\">Calculates the annual interest rate that results when a security (or other item) is purchased at an investment value and sold at a redemption value. No interest is paid.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_INTRATE\">Calcula la tasa d'interés añal que resulta cuando se merca un títulu (o otru artículu) a un valor d'inversión y viéndese a un valor d'amortización. Nun se paga interés.</ahelp>" -#. 9sGBJ +#. kFnJn #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3149800\n" "help.text" -msgid "INTRATE(Settlement; Maturity; Investment; Redemption; Basis)" -msgstr "TASA.INT(Lliquidación; Vencimientu; Inversiones; Redención; Base)" +msgid "INTRATE(Settlement; Maturity; Investment; Redemption [; Basis])" +msgstr "" #. 9szb8 #: 04060118.xhp @@ -28538,14 +28691,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPNCD\">Returns the date of the first interest date after the settlement date. Format the result as a date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPNCD\">Devuelve la fecha del primer interés dempués de la fecha de lliquidación. Asigne al resultáu formatu de fecha.</ahelp>" -#. HLdaB +#. 6sEfy #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3150423\n" "help.text" -msgid "COUPNCD(Settlement; Maturity; Frequency; Basis)" -msgstr "CUPON.FECHA.L2(Lliquidación; Vencimientu; Frecuencia; Base)" +msgid "COUPNCD(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. vGKDd #: 04060118.xhp @@ -28619,14 +28772,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPDAYS\">Returns the number of days in the current interest period in which the settlement date falls.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPDAYS\">Devuelve'l númberu de díes del períodu actual d'interés qu'inclúi la fecha de lliquidación.</ahelp>" -#. pRREv +#. ALYbR #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3149585\n" "help.text" -msgid "COUPDAYS(Settlement; Maturity; Frequency; Basis)" -msgstr "CUPON.DIAS(Lliquidación; Vencimientu; Frecuencia; Base)" +msgid "COUPDAYS(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. UuJui #: 04060118.xhp @@ -28700,14 +28853,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPDAYSNC\">Returns the number of days from the settlement date until the next interest date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPDAYSNC\">Devuelve'l númberu de díes dende la fecha de lliquidación hasta la siguiente fecha d'interés.</ahelp>" -#. UkhnP +#. 2AgvC #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3155121\n" "help.text" -msgid "COUPDAYSNC(Settlement; Maturity; Frequency; Basis)" -msgstr "CUPON.DIAS.L2(Lliquidación; Vencimientu; Frecuencia; Base)" +msgid "COUPDAYSNC(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. ECNxY #: 04060118.xhp @@ -28781,14 +28934,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPDAYBS\">Returns the number of days from the first day of interest payment on a security until the settlement date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPDAYBS\">Devuelve'l númberu de díes dende'l primer día de pagu d'intereses d'un títulu hasta la fecha de lliquidación.</ahelp>" -#. tFuDc +#. Zbdd9 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3159083\n" "help.text" -msgid "COUPDAYBS(Settlement; Maturity; Frequency; Basis)" -msgstr "CUPON.DIAS.L1(Lliquidación; Vencimientu; Frecuencia; Base)" +msgid "COUPDAYBS(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. CH3ja #: 04060118.xhp @@ -28862,14 +29015,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPPCD\">Returns the date of the interest date prior to the settlement date. Format the result as a date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPPCD\">Devuelve la fecha d'interés anterior a la fecha de lliquidación. Asigne al resultáu formatu de fecha.</ahelp>" -#. FBDqt +#. a3gA8 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3153790\n" "help.text" -msgid "COUPPCD(Settlement; Maturity; Frequency; Basis)" -msgstr "CUPON.FECHA.L1(Lliquidación; Vencimientu; Frecuencia; Base)" +msgid "COUPPCD(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. DCtJY #: 04060118.xhp @@ -28943,14 +29096,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPNUM\">Returns the number of coupons (interest payments) between the settlement date and the maturity date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPNUM\">Devuelve'l númberu de cupones (pagos d'interés) ente la fecha de lliquidación y la fecha de vencimientu.</ahelp>" -#. 4YreD +#. TbHua #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3153200\n" "help.text" -msgid "COUPNUM(Settlement; Maturity; Frequency; Basis)" -msgstr "CUPON.NUM(Lliquidación; Vencimientu; Frecuencia; Base)" +msgid "COUPNUM(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. 7oq6X #: 04060118.xhp @@ -29024,14 +29177,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZINSZ\">Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZINSZ\">Calcula l'amortización periódica d'una inversión con pagos regulares y un interés constante.</ahelp>" -#. fWFAi +#. DPv99 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3151283\n" "help.text" -msgid "IPMT(Rate; Period; NPer; PV; FV; Type)" -msgstr "PAGOINT(Tasa; Periodu; NPer; VP; VF; Tipu)" +msgid "IPMT(Rate; Period; NPer; PV [; FV [; Type]])" +msgstr "" #. WpENP #: 04060118.xhp @@ -29132,14 +29285,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZW\">Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZW\">Calcula'l valor final d'una inversión con pagos regulares y un tipu d'interés constante (valor futuru).</ahelp>" -#. SbUo7 +#. Gnz7u #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3145215\n" "help.text" -msgid "FV(Rate; NPer; Pmt; PV; Type)" -msgstr "VA(Tasa; NPer; Pagu; VA; Tipu)" +msgid "FV(Rate; NPer; Pmt [ ; [ PV ] [ ; Type ] ])" +msgstr "" #. Y9GP8 #: 04060118.xhp @@ -29303,14 +29456,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZZR\">Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZZR\">Calcula'l númberu de períodos de pagu d'una inversión con pagos regulares y una tasa d'interés constante.</ahelp>" -#. EBZYF +#. Fopz2 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3155934\n" "help.text" -msgid "NPER(Rate; Pmt; PV; FV; Type)" -msgstr "NPER(Tasa; Pagu; VA; VF; Tipu)" +msgid "NPER(Rate; Pmt; PV [ ; [ FV ] [ ; Type ] ])" +msgstr "" #. X44J9 #: 04060118.xhp @@ -29456,14 +29609,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_KAPZ\">Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_KAPZ\">Devuelve pa un períodu dáu'l pagu sobre la cantidá principal d'una inversión basada en pagos constantes y periódicos y nun interés constante.</ahelp>" -#. B6Kor +#. gxWF2 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3146878\n" "help.text" -msgid "PPMT(Rate; Period; NPer; PV; FV; Type)" -msgstr "PAGOPRIN(Tasa; Períodu; NPer; VA; VF; Tipu)" +msgid "PPMT(Rate; Period; NPer; PV [ ; FV [ ; Type ] ])" +msgstr "" #. t4fJk #: 04060119.xhp @@ -30068,14 +30221,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_PRICE\">Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_PRICE\">Calcula'l valor de mercáu d'un títulu d'interés fixu con un valor nominal de 100 unidaes monetaries como función del rendimientu previstu.</ahelp>" -#. M699C +#. k7qtv #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3152804\n" "help.text" -msgid "PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency; Basis)" -msgstr "PRECIU(Constitución; Vencimientu; Tasa; Réditu; Rendimientu; Frecuencia; Base)" +msgid "PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency [; Basis])" +msgstr "" #. FUP24 #: 04060119.xhp @@ -30176,14 +30329,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_PRICEDISC\">Calculates the price per 100 currency units of par value of a non-interest- bearing security.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_PRICEDISC\">Calcula'l preciu por 100 unidaes monetaries de valor nominal d'un títulu ensin interés asociáu.</ahelp>" -#. RwdWe +#. 6dK5H #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3146084\n" "help.text" -msgid "PRICEDISC(Settlement; Maturity; Discount; Redemption; Basis)" -msgstr "PRECIU.DESCUENTU(Lliquidación; Vencimientu; Descuentu; Redención; Base)" +msgid "PRICEDISC(Settlement; Maturity; Discount; Redemption [; Basis])" +msgstr "" #. WBvCG #: 04060119.xhp @@ -30266,14 +30419,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_PRICEMAT\">Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_PRICEMAT\">Calcula'l preciu de 100 unidaes monetaries por valor d'un títulu, la fecha de pagu d'interés ye la fecha de vencimientu.</ahelp>" -#. rYQMJ +#. h6UDj #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3155393\n" "help.text" -msgid "PRICEMAT(Settlement; Maturity; Issue; Rate; Yield; Basis)" -msgstr "PRECIU.VENCIMIENTU(Constitución; Vencimientu; Emisión; Tasa; Réditu; Base)" +msgid "PRICEMAT(Settlement; Maturity; Issue; Rate; Yield [; Basis])" +msgstr "" #. tG4zg #: 04060119.xhp @@ -30527,14 +30680,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_MDURATION\">Calculates the modified Macauley duration of a fixed interest security in years.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_MDURATION\">Calcula la duración Macauley modificada, n'años, d'un títulu d'interés fixu.</ahelp>" -#. AUGt7 +#. tGit8 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3148987\n" "help.text" -msgid "MDURATION(Settlement; Maturity; Coupon; Yield; Frequency; Basis)" -msgstr "DURACION.MODIF(\"Lliquidación\"; \"Vencimientu\"; Cupón; Rendimientu; Frecuencia; Bases)" +msgid "MDURATION(Settlement; Maturity; Coupon; Yield; Frequency [; Basis])" +msgstr "" #. xTn69 #: 04060119.xhp @@ -31058,14 +31211,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_YIELD\">Calculates the yield of a security.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_YIELD\">Calcula'l rendimientu d'un títulu.</ahelp>" -#. QYCYQ +#. iZ8rB #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3149744\n" "help.text" -msgid "YIELD(Settlement; Maturity; Rate; Price; Redemption; Frequency; Basis)" -msgstr "RENDTO(Lliquidación; Vencimientu; Tasa; Cotización; Rendimientu; Frecuencia; Base)" +msgid "YIELD(Settlement; Maturity; Rate; Price; Redemption; Frequency [; Basis])" +msgstr "" #. C68Mv #: 04060119.xhp @@ -31166,14 +31319,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_YIELDDISC\">Calculates the annual yield of a non-interest-bearing security.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_YIELDDISC\">Calcula'l rendimientu añal d'un títulu ensin interés asociáu.</ahelp>" -#. DhjQo +#. z5sGa #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3159191\n" "help.text" -msgid "YIELDDISC(Settlement; Maturity; Price; Redemption; Basis)" -msgstr "RENDTO.DESC(\"Lliquidación\"; \"Vencimientu\"; Preciu; Redención; Bases)" +msgid "YIELDDISC(Settlement; Maturity; Price; Redemption [; Basis])" +msgstr "" #. fFG4g #: 04060119.xhp @@ -31256,14 +31409,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_YIELDMAT\">Calculates the annual yield of a security, the interest of which is paid on the date of maturity.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_YIELDMAT\">Calcula'l rendimientu añal d'un títulu que'l so interés pagar na fecha de vencimientu.</ahelp>" -#. auKJi +#. 63YEW #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3159113\n" "help.text" -msgid "YIELDMAT(Settlement; Maturity; Issue; Rate; Price; Basis)" -msgstr "RENDTO.VENCTO(Lliquidación; Vencimientu; Emisión; Tasa; Preciu; Base)" +msgid "YIELDMAT(Settlement; Maturity; Issue; Rate; Price [; Basis])" +msgstr "" #. db9jM #: 04060119.xhp @@ -31355,14 +31508,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RMZ\">Returns the periodic payment for an annuity with constant interest rates.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RMZ\">Calcula los pagos regulares (añalidaes) d'una inversión con un tipu d'interés constante.</ahelp>" -#. QNdx7 +#. 94VHK #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3147278\n" "help.text" -msgid "PMT(Rate; NPer; PV; FV; Type)" -msgstr "PAGU(Tasa; NPer; Pagu; VF; Tipu)" +msgid "PMT(Rate; NPer; PV [ ; [ FV ] [ ; Type ] ])" +msgstr "" #. fGg3G #: 04060119.xhp @@ -32426,14 +32579,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_B\">Returns the probability of a sample with binomial distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_B\">Devuelve la probabilidá d'una amuesa con distribución binomial.</ahelp>" -#. K7JLA +#. tYKH6 #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3148392\n" "help.text" -msgid "B(Trials; SP; T1; T2)" -msgstr "B(Ensayos; SP; T1; T2)" +msgid "B(Trials; SP; T1 [; T2])" +msgstr "" #. 5gx3q #: 04060181.xhp @@ -32579,14 +32732,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BETAINV\">Returns the inverse of the cumulative beta probability density function.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_BETAINV\">Devuelve l'inversu de la función de densidá de probabilidá beta acumulada.</ahelp>" -#. GuWiC +#. 9kR89 #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3156300\n" "help.text" -msgid "BETAINV(Number; Alpha; Beta; Start; End)" -msgstr "DISTR.BETA.INV(Númberu; Alpha; Beta; Entamu; Fin)" +msgid "BETAINV(Number; Alpha; Beta [; Start [; End]])" +msgstr "" #. nrAdm #: 04060181.xhp @@ -32669,14 +32822,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BETAINV_MS\">Returns the inverse of the cumulative beta probability density function.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_BETAINV\">Devuelve l'inversu de la función de densidá de probabilidá beta acumulada.</ahelp>" -#. vUjKp +#. xtGcA #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id2956300\n" "help.text" -msgid "BETA.INV(Number; Alpha; Beta; Start; End)" -msgstr "DISTR.BETA.INV(Númberu; Alpha; Beta; Entamu; Fin)" +msgid "BETA.INV(Number; Alpha; Beta [; Start [; End]])" +msgstr "" #. 2fKqs #: 04060181.xhp @@ -32759,14 +32912,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BETAVERT\">Returns the beta function.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_BETAVERT\">Devuelve la función beta.</ahelp>" -#. hzgeo +#. AKfrR #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3147571\n" "help.text" -msgid "BETADIST(Number; Alpha; Beta; Start; End; Cumulative)" -msgstr "DISTR.BETA(Númberu; Alfa; Beta; Entamu; Fin;Acumulativa)" +msgid "BETADIST(Number; Alpha; Beta [; Start [; End [; Cumulative]]])" +msgstr "" #. jfrX3 #: 04060181.xhp @@ -32858,13 +33011,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BETADIST_MS\">Returns the beta function.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_BETAVERT\">Devuelve la función beta.</ahelp>" -#. vBbC8 +#. qpb3A #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id2947571\n" "help.text" -msgid "BETA.DIST(Number; Alpha; Beta; Cumulative; Start; End)" +msgid "BETA.DIST(Number; Alpha; Beta; Cumulative [; Start [; End]])" msgstr "" #. VV9bt @@ -34298,14 +34451,14 @@ msgctxt "" msgid "<ahelp hid=\".\">Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution.</ahelp>" msgstr "<ahelp hid=\".\">Devuelve'l valor de la función de densidá de probabilidá o la función de distribución acumulativa pa la distribución del cuadráu de chi.</ahelp>" -#. yG245 +#. 9t3Cb #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id0119200902395679\n" "help.text" -msgid "CHISQDIST(Number; Degrees Of Freedom; Cumulative)" -msgstr "DISTR.CUAD.CHI(Númberu; Graos de llibertá; Acumulativa)" +msgid "CHISQDIST(Number; Degrees Of Freedom [; Cumulative])" +msgstr "" #. nLEaF #: 04060181.xhp @@ -35045,14 +35198,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_F_DIST_LT\">Calculates the values of the left tail of the F distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_TINV\">Calcula l'inversu de la distribución t.</ahelp>" -#. CxzQP +#. kNsgP #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id2945826\n" "help.text" -msgid "F.DIST(Number; DegreesFreedom1; DegreesFreedom2; Cumulative)" -msgstr "DISTR.F(Númberu; GradosdeLibertad1; GradosdeLibertad2)" +msgid "F.DIST(Number; DegreesFreedom1; DegreesFreedom2 [; Cumulative])" +msgstr "" #. TeZSu #: 04060182.xhp @@ -35522,14 +35675,14 @@ msgctxt "" msgid "The inverse function is GAMMAINV." msgstr "La función inversa ye DISTR.GAMMA.INV." -#. 5bF6b +#. ER624 #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3155436\n" "help.text" -msgid "GAMMADIST(Number; Alpha; Beta; C)" -msgstr "DISTR.GAMMA(x; alfa; beta; acum)" +msgid "GAMMADIST(Number; Alpha; Beta [; C])" +msgstr "" #. erGE4 #: 04060182.xhp @@ -35774,22 +35927,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_GEOMITTEL\">Returns the geometric mean of a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_GEOMITTEL\">Calcula la media xeométrica d'una amuesa.</ahelp>" -#. T8r4b +#. YBnZG #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3153720\n" "help.text" -msgid "GEOMEAN(Number1; Number2; ...; Number30)" -msgstr "" - -#. UhYAQ -#: 04060182.xhp -msgctxt "" -"04060182.xhp\n" -"par_id3152585\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges that represent a random sample." +msgid "GEOMEAN(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. EGwom @@ -35891,14 +36035,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_GTEST\">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_GTEST\">Calcula la probabilidá de reparar un estadísticu z mayor que'l calculáu basáu nuna amuesa.</ahelp>" -#. Wi4MG +#. GeqDU #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3153274\n" "help.text" -msgid "ZTEST(Data; mu; Sigma)" -msgstr "PRUEBA.Z(Datos; mu; Sigma)" +msgid "ZTEST(Data; mu [; Sigma])" +msgstr "" #. RKyE7 #: 04060182.xhp @@ -35963,14 +36107,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_Z_TEST_MS\">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_GTEST\">Calcula la probabilidá de reparar un estadísticu z mayor que'l calculáu basáu nuna amuesa.</ahelp>" -#. efbeG +#. Ug83K #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id2953274\n" "help.text" -msgid "Z.TEST(Data; mu; Sigma)" -msgstr "PRUEBA.Z(Datos; mu; Sigma)" +msgid "Z.TEST(Data; mu [; Sigma])" +msgstr "" #. 2peSH #: 04060182.xhp @@ -36035,22 +36179,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_HARMITTEL\">Returns the harmonic mean of a data set.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_HARMITTEL\">Calcula la media harmonizada d'un grupu de datos.</ahelp>" -#. xroLU +#. EKBXf #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3149287\n" "help.text" -msgid "HARMEAN(Number1; Number2; ...; Number30)" -msgstr "" - -#. gT7zX -#: 04060182.xhp -msgctxt "" -"04060182.xhp\n" -"par_id3154303\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean." +msgid "HARMEAN(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. DMCH7 @@ -36089,13 +36224,13 @@ 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>" -#. 5uQ3c +#. BEUMD #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3155388\n" "help.text" -msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative])" +msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation [; Cumulative])" msgstr "" #. ingyW @@ -37034,14 +37169,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LOGINV\">Returns the inverse of the lognormal distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_LOGINV\">Calcula l'inversu de la distribución normal logarítmica.</ahelp>" -#. D9Eg5 +#. kK6DB #: 04060183.xhp msgctxt "" "04060183.xhp\n" "par_id3153049\n" "help.text" -msgid "LOGINV(Number; Mean; StDev)" -msgstr "INV.LOG(Númberu; Media; Esviación Estandar)" +msgid "LOGINV(Number [; Mean [; StDev]])" +msgstr "" #. uqfDA #: 04060183.xhp @@ -37187,14 +37322,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LOGNORMVERT\">Returns the values of a lognormal distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_GAMMAVERT\">Devuelve'l valor d'una distribución gamma.</ahelp>" -#. FB6kb +#. r4obV #: 04060183.xhp msgctxt "" "04060183.xhp\n" "par_id3150686\n" "help.text" -msgid "LOGNORMDIST(Number; Mean; StDev; Cumulative)" -msgstr "DISTR.LOG.NORM(Númberu; Media; Desv_estándar; Acumulativa)" +msgid "LOGNORMDIST(Number [; Mean [; StDev [; Cumulative]]])" +msgstr "" #. BiGC6 #: 04060183.xhp @@ -38276,14 +38411,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_NORMVERT\">Returns the density function or the normal cumulative distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_NORMVERT\">Devuelve la función de densidá o la distribución acumulativa normal.</ahelp>" -#. vgosP +#. Mogit #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3150613\n" "help.text" -msgid "NORMDIST(Number; Mean; StDev; C)" -msgstr "DISTR.NORM(Númberu; Media; Desv_estándar; C)" +msgid "NORMDIST(Number; Mean; StDev [; C])" +msgstr "" #. CoXtp #: 04060184.xhp @@ -38591,14 +38726,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_POISSON\">Returns the Poisson distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_POISSON\">Devuelve la distribución de Poisson.</ahelp>" -#. hdmir +#. SH95D #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3146093\n" "help.text" -msgid "POISSON(Number; Mean; C)" -msgstr "POISSON(x; media; acumuláu)" +msgid "POISSON(Number; Mean [; C])" +msgstr "" #. mZnNF #: 04060184.xhp @@ -38663,14 +38798,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_POISSON_DIST_MS\">Returns the Poisson distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_POISSON\">Devuelve la distribución de Poisson.</ahelp>" -#. MCzFk +#. JHGHg #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2946093\n" "help.text" -msgid "POISSON.DIST(Number; Mean; C)" -msgstr "POISSON(x; media; acumuláu)" +msgid "POISSON.DIST(Number; Mean [; C])" +msgstr "" #. jnjk7 #: 04060184.xhp @@ -38951,13 +39086,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_QUANTILSRANG\">Returns the percentage rank of a value in a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_QUANTILSRANG\">Calcula'l rangu porcentual d'un valor nuna amuesa.</ahelp>" -#. 43275 +#. AAjBU #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3147238\n" "help.text" -msgid "PERCENTRANK(Data; Value; Significance)" +msgid "PERCENTRANK(Data; Value [; Significance])" msgstr "" #. hPEyS @@ -39032,13 +39167,13 @@ msgctxt "" msgid "The difference between <item type=\"input\">PERCENTRANK.INC</item> and <item type=\"input\">PERCENTRANK.EXC</item> is that <item type=\"input\">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type=\"input\">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive." msgstr "" -#. 7KcdX +#. FFw3f #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2847238\n" "help.text" -msgid "PERCENTRANK.EXC(Data; Value; Significance)" +msgid "PERCENTRANK.EXC(Data; Value [; Significance])" msgstr "" #. paUED @@ -39113,13 +39248,13 @@ msgctxt "" msgid "The difference between <item type=\"input\">PERCENTRANK.INC</item> and <item type=\"input\">PERCENTRANK.EXC</item> is that <item type=\"input\">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type=\"input\">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive." msgstr "" -#. GHbGk +#. YfPDe #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2947238\n" "help.text" -msgid "PERCENTRANK.INC(Data; Value; Significance)" +msgid "PERCENTRANK.INC(Data; Value [; Significance])" msgstr "" #. QmR4b @@ -39410,14 +39545,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RANG\">Returns the rank of a number in a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RANG\">Devuelve la xerarquía d'un númberu nuna amuesa.</ahelp>" -#. EUgG4 +#. oVk4F #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3153250\n" "help.text" -msgid "RANK(Value; Data; Type)" -msgstr "XERARQUÍA(Númberu; Datos; Orde)" +msgid "RANK(Value; Data [; Type])" +msgstr "" #. AzAQx #: 04060185.xhp @@ -39509,14 +39644,14 @@ msgctxt "" msgid "The difference between <item type=\"input\">RANK.AVG</item> and <item type=\"input\">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type=\"input\">RANK.EQ</item> function returns the lower rank, whereas the <item type=\"input\">RANK.AVG</item> function returns the average rank." msgstr "" -#. aqAAg +#. f8zpD #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2953250\n" "help.text" -msgid "RANK.AVG(Value; Data; Type)" -msgstr "XERARQUÍA(Númberu; Datos; Orde)" +msgid "RANK.AVG(Value; Data [; Type])" +msgstr "" #. 9jn8F #: 04060185.xhp @@ -39608,14 +39743,14 @@ msgctxt "" msgid "The difference between <item type=\"input\">RANK.AVG</item> and <item type=\"input\">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type=\"input\">RANK.EQ</item> function returns the lower rank, whereas the <item type=\"input\">RANK.AVG</item> function returns the average rank." msgstr "" -#. gTjX5 +#. bGAcu #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2853250\n" "help.text" -msgid "RANK.EQ(Value; Data; Type)" -msgstr "XERARQUÍA(Númberu; Datos; Orde)" +msgid "RANK.EQ(Value; Data [; Type])" +msgstr "" #. mncnk #: 04060185.xhp @@ -41750,14 +41885,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WAHRSCHBEREICH\">Returns the probability that values in a range are between two limits.</ahelp> If there is no <item type=\"literal\">End</item> value, this function calculates the probability based on the principle that the Data values are equal to the value of <item type=\"literal\">Start</item>." msgstr "<ahelp hid=\"HID_FUNC_WAHRSCHBEREICH\">Devuelve la probabilidá de que los valores tán nun rangu ente dos llindes.</ahelp> Si nun hai un valor <item type=\"literal\">Fin</item>, esta función calcula la probabilidá basada nel principiu de que los valores de datos son iguales al valor de <item type=\"literal\">Entamu</item>" -#. Ffebs +#. GhGG7 #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3147330\n" "help.text" -msgid "PROB(Data; Probability; Start; End)" -msgstr "PROBABILIDÁ(Datos; Probabilidá; Entamu; Fin)" +msgid "PROB(Data; Probability; Start [; End])" +msgstr "" #. Reoxn #: 04060185.xhp @@ -54251,130 +54386,130 @@ msgctxt "" msgid "The result is presented in the string format and has the character \"i\" or \"j\" as an imaginary unit." msgstr "" -#. 3yZht +#. CT9jZ #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id71584446760037\n" "help.text" -msgid "<variable id=\"string255_1\">String 1[; String 2][; … ;[String 255]]</variable>" +msgid "<variable id=\"string255_1\">String 1 [; String 2 [; … [; String 255]]]</variable>" msgstr "" -#. aZAJy +#. 2UTGE #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id631556228516997\n" "help.text" -msgid "<emph>String 1[; String 2][; … ;[String 255]]</emph> are strings, references to cells or to cell ranges of strings." +msgid "<emph>String 1, String 2, … , String 255</emph> are strings, references to cells or to cell ranges of strings." msgstr "" -#. Gx7GF +#. MFitb #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id401584447957914\n" "help.text" -msgid "<variable id=\"integer255_1\">Integer 1[; Integer 2][; … ;[Integer 255]]</variable>" +msgid "<variable id=\"integer255_1\">Integer 1 [; Integer 2 [; … [; Integer 255]]]</variable>" msgstr "" -#. sCxFS +#. yUDDY #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id1001584395844941\n" "help.text" -msgid "<emph>Integer 1[; Integer 2][; … ;[Integer 255]]</emph> are integers, references to cells or to cell ranges of integers." +msgid "<emph>Integer 1, Integer 2, … , Integer 255</emph> are integers, references to cells or to cell ranges of integers." msgstr "" -#. KJbXQ +#. B6MF9 #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id101584447971004\n" "help.text" -msgid "<variable id=\"number254_1\">Number 1[; Number 2][; … ;[Number 254]]</variable>" +msgid "<variable id=\"number254_1\">Number 1 [; Number 2 [; … [; Number 254]]]</variable>" msgstr "" -#. JPXDA +#. b96Za #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id931584305947010\n" "help.text" -msgid "<emph>Number 1[; Number 2][; … ;[Number 254]]</emph> are numbers, references to cells or to cell ranges of numbers." +msgid "<emph>Number 1, Number 2, … , Number 254</emph> are numbers, references to cells or to cell ranges of numbers." msgstr "" -#. y6bDp +#. kEEQr #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id101584447970004\n" "help.text" -msgid "<variable id=\"number255_1\">Number 1[; Number 2][; … ;[Number 255]]</variable>" +msgid "<variable id=\"number255_1\">Number 1 [; Number 2 [; … [; Number 255]]]</variable>" msgstr "" -#. BXZo8 +#. QKcwi #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id931584395947010\n" "help.text" -msgid "<emph>Number 1[; Number 2][; … ;[Number 255]]</emph> are numbers, references to cells or to cell ranges of numbers." +msgid "<emph>Number 1, Number 2, … , Number 255</emph> are numbers, references to cells or to cell ranges of numbers." msgstr "" -#. AWCP7 +#. RLXz8 #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id291584447988879\n" "help.text" -msgid "<variable id=\"logical255_1\">Logical 1[; Logical 2][; … ;[Logical 255]]</variable>" +msgid "<variable id=\"logical255_1\">Logical 1 [; Logical 2 [; … [; Logical 255]]]</variable>" msgstr "" -#. CzEmY +#. JTdAs #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id931584395957010\n" "help.text" -msgid "<emph>Logical 1[; Logical 2][; … ;[Logical 255]]</emph> are boolean values, references to cells or to cell ranges of logical values." +msgid "<emph>Logical 1, Logical 2, … , Logical 255</emph> are boolean values, references to cells or to cell ranges of logical values." msgstr "" -#. cjCCW +#. unnEF #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id91584448008632\n" "help.text" -msgid "<variable id=\"complex255_1\">Complex 1[; Complex 2][; … ;[Complex 255]]</variable>" +msgid "<variable id=\"complex255_1\">Complex 1 [; Complex 2 [; … [; Complex 255]]]</variable>" msgstr "" -#. AfffT +#. NuCbV #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id931584335947010\n" "help.text" -msgid "<emph>Complex 1[; Complex 2][; … ;[Complex 255]]</emph> are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form \"x+yi\" or \"x+yj\"." +msgid "<emph>Complex 1, Complex 2, … ,Complex 255</emph> are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form \"x+yi\" or \"x+yj\"." msgstr "" -#. SDfoG +#. jWF7Y #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id61584448028298\n" "help.text" -msgid "<variable id=\"reference255_1\">Reference 1[; Reference 2][; … ;[Reference 255]]</variable>" +msgid "<variable id=\"reference255_1\">Reference 1 [; Reference 2 [; … [; Reference 255]]]</variable>" msgstr "" -#. NwpZa +#. dxwtx #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id431584335947010\n" "help.text" -msgid "<emph>Reference 1[; Reference 2][; … ;[Reference 255]]</emph> are references to cells." +msgid "<emph>Reference 1, Reference 2, … ,Reference 255</emph> are references to cells." msgstr "" #. 8DbP2 @@ -55511,13 +55646,13 @@ msgctxt "" msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that has existed since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions." msgstr "" -#. mZwNV +#. 3DwLL #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id3153454\n" "help.text" -msgid "CEILING(Number[; Significance[; Mode]])" +msgid "CEILING(Number [; Significance [; Mode]])" msgstr "" #. XHjhc @@ -55556,13 +55691,13 @@ msgctxt "" msgid "<input>=CEILING(3.45)</input> returns 4." msgstr "" -#. ztdNi +#. UTtFZ #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id921586208142416\n" "help.text" -msgid "<input>=CEILING(3.45, 3)</input> returns 6." +msgid "<input>=CEILING(3.45; 3)</input> returns 6." msgstr "" #. XGfA3 @@ -55574,22 +55709,22 @@ msgctxt "" msgid "<input>=CEILING(-1.234)</input> returns -1." msgstr "" -#. ss5WP +#. ZWjxy #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id491586208152183\n" "help.text" -msgid "<input>=CEILING(-45.67, -2, 0)</input> returns -44." +msgid "<input>=CEILING(-45.67; -2; 0)</input> returns -44." msgstr "" -#. FY9XN +#. Auwyx #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id291586208158119\n" "help.text" -msgid "<input>=CEILING(-45.67, -2, 1)</input> returns -46." +msgid "<input>=CEILING(-45.67; -2; 1)</input> returns -46." msgstr "" #. rZ78k @@ -55637,13 +55772,13 @@ msgctxt "" msgid "This function calculates identical results to the <link href=\"#Section312\" name=\"isoceiling\">ISO.CEILING</link> function." msgstr "" -#. yYT7X +#. BASfr #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id2953454\n" "help.text" -msgid "CEILING.PRECISE(Number[; Significance])" +msgid "CEILING.PRECISE(Number [; Significance])" msgstr "" #. FaYeD @@ -55664,13 +55799,13 @@ msgctxt "" msgid "<input>=CEILING.PRECISE(3.45)</input> returns 4." msgstr "" -#. kkosx +#. KxeUC #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id651586213406243\n" "help.text" -msgid "<input>=CEILING.PRECISE(-45.67,2)</input> returns -44." +msgid "<input>=CEILING.PRECISE(-45.67; 2)</input> returns -44." msgstr "" #. WV9bx @@ -55718,13 +55853,13 @@ msgctxt "" msgid "This function exists for interoperability with Microsoft Excel 2013 or newer." msgstr "" -#. Km7yb +#. pcXnS #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id841516997669932\n" "help.text" -msgid "CEILING.MATH(Number[; Significance[; Mode]])" +msgid "CEILING.MATH(Number [; Significance [; Mode]])" msgstr "" #. EAezJ @@ -55754,13 +55889,13 @@ msgctxt "" msgid "<input>=CEILING.MATH(3.45)</input> returns 4." msgstr "" -#. 6BkMe +#. g5xAQ #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id481586208595809\n" "help.text" -msgid "<input>=CEILING.MATH(3.45,-3)</input> returns 6." +msgid "<input>=CEILING.MATH(3.45; -3)</input> returns 6." msgstr "" #. Eby7i @@ -55772,22 +55907,22 @@ msgctxt "" msgid "<input>=CEILING.MATH(-1.234)</input> returns -1." msgstr "" -#. fH4Yt +#. T4orc #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id151586208604536\n" "help.text" -msgid "<input>=CEILING.MATH(-45.67,-2,0)</input> returns -44." +msgid "<input>=CEILING.MATH(-45.67; -2; 0)</input> returns -44." msgstr "" -#. MGVBD +#. opt6B #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id971586208611345\n" "help.text" -msgid "<input>=CEILING.MATH(-45.67,+2, 1)</input> returns -46." +msgid "<input>=CEILING.MATH(-45.67; +2; 1)</input> returns -46." msgstr "" #. EzE9t @@ -55862,22 +55997,22 @@ msgctxt "" msgid "<input>=CEILING.XCL(3.45,2)</input> returns 4." msgstr "" -#. SZYUC +#. nU46D #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id651586214132234\n" "help.text" -msgid "<input>=CEILING.XCL(-45.67,2)</input> returns -44." +msgid "<input>=CEILING.XCL(-45.67; 2)</input> returns -44." msgstr "" -#. pz8Go +#. nbB96 #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id811586214136666\n" "help.text" -msgid "<input>=CEILING.XCL(-45.67,-2)</input> returns -46." +msgid "<input>=CEILING.XCL(-45.67; -2)</input> returns -46." msgstr "" #. GMzhD @@ -55925,13 +56060,13 @@ msgctxt "" msgid "This function calculates identical results to the <link href=\"#Section311\" name=\"ceilingprecise\">CEILING.PRECISE</link> function." msgstr "" -#. LZzHU +#. GRocX #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id8953454\n" "help.text" -msgid "ISO.CEILING(Number[; Significance])" +msgid "ISO.CEILING(Number [; Significance])" msgstr "" #. hwhCW @@ -55952,13 +56087,13 @@ msgctxt "" msgid "<input>=ISO.CEILING(3.45)</input> returns 4." msgstr "" -#. xS2zM +#. QHpJp #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id181586214438808\n" "help.text" -msgid "<input>=ISO.CEILING(-45.67,2)</input> returns -44." +msgid "<input>=ISO.CEILING(-45.67; 2)</input> returns -44." msgstr "" #. GuEcB @@ -55997,13 +56132,13 @@ msgctxt "" msgid "<ahelp hid=\".\">Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system.</ahelp> The result depends on the color system used by your computer." msgstr "" -#. wRAHQ +#. 3ubzF #: func_color.xhp msgctxt "" "func_color.xhp\n" "par_id27421466710275\n" "help.text" -msgid "COLOR(Red; Green; Blue; Alpha)" +msgid "COLOR(Red; Green; Blue [; Alpha])" msgstr "" #. ASLWJ @@ -57536,13 +57671,13 @@ msgctxt "" msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the starting position of a given text, using byte positions. FINDB is case sensitive.</ahelp></variable>" msgstr "" -#. yA9fg +#. 4ztby #: func_findb.xhp msgctxt "" "func_findb.xhp\n" "par_id221573517641172\n" "help.text" -msgid "FINDB( Find Text ; Text ; Position )" +msgid "FINDB(Find Text ; Text [; Position])" msgstr "" #. puQAw @@ -58769,13 +58904,13 @@ msgctxt "" msgid "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Computes the Discrete Fourier Transform [DFT] of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp></variable> The function is an <link href=\"text/scalc/01/04060107.xhp\" name=\"array formula\">array formula</link>." msgstr "" -#. 467q3 +#. xGHaG #: func_fourier.xhp msgctxt "" "func_fourier.xhp\n" "par_id541556228253979\n" "help.text" -msgid "FOURIER(Array, GroupedByColumns, Inverse, Polar, MinimumMagnitude)" +msgid "FOURIER(Array; GroupedByColumns [; Inverse [; Polar [; MinimumMagnitude]]])" msgstr "" #. ELSK7 @@ -60488,13 +60623,13 @@ msgctxt "" msgid "<ahelp hid=\".\">Returns the number of workdays between a start date and an end date. There are options to define weekend days and holidays. The optional weekend parameter (or a string) can be used to define the weekend days (or the non-working days in each week). Also, optionally, the user can define a holiday list. The weekend days and user-defined holidays are not counted as working days.</ahelp>" msgstr "" -#. GB88f +#. 53kNC #: func_networkdays.intl.xhp msgctxt "" "func_networkdays.intl.xhp\n" "par_id231020162249539143\n" "help.text" -msgid "NETWORKDAYS.INTL(StartDate; EndDate; Weekend; Holidays)" +msgid "NETWORKDAYS.INTL(StartDate; EndDate [; [ Weekend ] [; Holidays ] ])" msgstr "" #. D8jig @@ -60614,13 +60749,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_NETWORKDAYS\">Returns the number of workdays between a <emph>start date</emph> and an <emph>end date</emph>. Holidays can be deducted.</ahelp>" msgstr "" -#. shbHi +#. AME9S #: func_networkdays.xhp msgctxt "" "func_networkdays.xhp\n" "par_id3145775\n" "help.text" -msgid "NETWORKDAYS(StartDate; EndDate; Holidays; Workdays)" +msgid "NETWORKDAYS(StartDate; EndDate [; [ Holidays ] [; Workdays ] ])" msgstr "" #. BEtbU @@ -60803,13 +60938,13 @@ msgctxt "" msgid "Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator" msgstr "" -#. xQzLz +#. 2uppP #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "par_id3149268\n" "help.text" -msgid "NUMBERVALUE(\"Text\";decimal_separator;group_separator)" +msgid "NUMBERVALUE(\"Text\" [;decimal_separator [;group_separator]])" msgstr "" #. ytM82 @@ -60884,13 +61019,13 @@ msgctxt "" msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the pricing for a barrier option, calculated using the Black-Scholes option pricing model.</ahelp></variable>" msgstr "" -#. FxbGq +#. 3ky3t #: func_opt_barrier.xhp msgctxt "" "func_opt_barrier.xhp\n" "par_id371575067051846\n" "help.text" -msgid "OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; LowerBarrier; UpperBarrier; Rebate; PutCall; InOut; BarrierMonitoring; Greek)" +msgid "OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; LowerBarrier; UpperBarrier; Rebate; PutCall; InOut; BarrierMonitoring [; Greek])" msgstr "" #. XEMff @@ -61127,13 +61262,13 @@ msgctxt "" msgid "The function ignores the possibility of knock-out before maturity." msgstr "" -#. XTh5Y +#. DHFtE #: func_opt_prob_inmoney.xhp msgctxt "" "func_opt_prob_inmoney.xhp\n" "par_id761575075027094\n" "help.text" -msgid "OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier; Strike; PutCall)" +msgid "OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier [; Strike [; PutCall]])" msgstr "" #. mE6CG @@ -61208,13 +61343,13 @@ msgctxt "" msgid "Further information about touch / no-touch options may be found on many financial websites." msgstr "" -#. pyway +#. V3nnz #: func_opt_touch.xhp msgctxt "" "func_opt_touch.xhp\n" "par_id151575063296819\n" "help.text" -msgid "OPT_TOUCH(Spot; Volatility; Rate; ForeignRate; Maturity; LowerBarrier; UpperBarrier; ForeignDomestic; InOut; BarrierMonitoring; Greek)" +msgid "OPT_TOUCH(Spot; Volatility; Rate; ForeignRate; Maturity; LowerBarrier; UpperBarrier; ForeignDomestic; InOut; BarrierMonitoring [; Greek])" msgstr "" #. 6rD5u @@ -61919,13 +62054,13 @@ msgctxt "" msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the starting position of a given text, using byte positions (not case sensitive).</ahelp></variable>" msgstr "" -#. jADhb +#. zQHHs #: func_searchb.xhp msgctxt "" "func_searchb.xhp\n" "par_id531573516878780\n" "help.text" -msgid "SEARCHB( Find text ; Text ; Position)" +msgid "SEARCHB(Find Text; Text [; Position])" msgstr "" #. 6Pmbf @@ -63062,13 +63197,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WOCHENTAG\">Returns the day of the week for the given date value.</ahelp> The day is returned as an integer between 1 (Sunday) and 7 (Saturday) if no type or type=1 is specified. For other types, see the table below." msgstr "" -#. EDmeN +#. SaqiJ #: func_weekday.xhp msgctxt "" "func_weekday.xhp\n" "par_id3149033\n" "help.text" -msgid "WEEKDAY(Number[; Type])" +msgid "WEEKDAY(Number [; Type])" msgstr "" #. mcF52 @@ -63809,13 +63944,13 @@ msgctxt "" msgid "<ahelp hid=\".\">Returns the date calculated from a start date with a specific number of work days, before or after the start date. The calculation can include week-ends and holidays as non-working days.</ahelp>" msgstr "" -#. ZFLiY +#. 9r2Ns #: func_workday.intl.xhp msgctxt "" "func_workday.intl.xhp\n" "par_id241020160008306838\n" "help.text" -msgid "WORKDAY.INTL(StartDate; Days[; Weekend][; Holidays])" +msgid "WORKDAY.INTL(StartDate; Days [; Weekend [; Holidays]])" msgstr "" #. gJg5G @@ -63980,13 +64115,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_WORKDAY\"> The result is a date number that can be formatted as a date. You then see the date of a day that is a certain number of <emph>workdays</emph> away from the <emph>start date</emph>.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_WORKDAY\"> La resultancia ye un númberu que la fecha pue ser en formatu de fecha. Asina, pue ver la fecha d'un día que ye un ciertu númberu de <emph>díes llaborales</emph> llueñe de la <emph>fecha d'entamu</emph>.</ahelp>" -#. fo6sg +#. NDtoU #: func_workday.xhp msgctxt "" "func_workday.xhp\n" "par_id3154844\n" "help.text" -msgid "WORKDAY(StartDate; Days[; Holidays])" +msgid "WORKDAY(StartDate; Days [; Holidays])" msgstr "" #. 35EG5 @@ -64169,13 +64304,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_YEARFRAC\">The result is the number of the years (including fractional part) between <emph>StartDate</emph> and <emph>EndDate</emph>.</ahelp>" msgstr "" -#. AASCJ +#. DBBsL #: func_yearfrac.xhp msgctxt "" "func_yearfrac.xhp\n" "par_id3155823\n" "help.text" -msgid "YEARFRAC(StartDate; EndDate[; Basis])" +msgid "YEARFRAC(StartDate; EndDate [; Basis])" msgstr "" #. JAA8u |