diff options
Diffstat (limited to 'source/bg/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/bg/helpcontent2/source/text/scalc/01.po | 694 |
1 files changed, 459 insertions, 235 deletions
diff --git a/source/bg/helpcontent2/source/text/scalc/01.po b/source/bg/helpcontent2/source/text/scalc/01.po index 895a5a8f0f5..d64ad99458d 100644 --- a/source/bg/helpcontent2/source/text/scalc/01.po +++ b/source/bg/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2018-05-08 15:11+0200\n" +"POT-Creation-Date: 2018-07-02 00:14+0200\n" "PO-Revision-Date: 2018-05-09 10:29+0000\n" "Last-Translator: Mihail Balabanov <m.balabanov@gmail.com>\n" "Language-Team: LibreOffice на български\n" @@ -13,7 +13,7 @@ msgstr "" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=2; plural=(n != 1);\n" "X-Accelerator-Marker: ~\n" -"X-Generator: Pootle 2.8\n" +"X-Generator: LibreOffice\n" "X-Project-Style: openoffice\n" "X-POOTLE-MTIME: 1525861765.000000\n" @@ -14646,8 +14646,8 @@ msgctxt "" "04060106.xhp\n" "hd_id3163596\n" "help.text" -msgid "SUM" -msgstr "SUM" +msgid "<variable id=\"sum_head\"><link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link></variable>" +msgstr "" #: 04060106.xhp msgctxt "" @@ -14774,8 +14774,8 @@ msgctxt "" "04060106.xhp\n" "hd_id3151957\n" "help.text" -msgid "SUMIF" -msgstr "SUMIF" +msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>" +msgstr "" #: 04060106.xhp msgctxt "" @@ -19732,14 +19732,6 @@ msgstr "<item type=\"input\">=ADDRESS(1;1;2;\"Лист2\")</item> връща Л #: 04060109.xhp msgctxt "" "04060109.xhp\n" -"par_id3159260\n" -"help.text" -msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." -msgstr "Ако клетката A1 от лист 2 съдържа стойността <item type=\"input\">-6</item>, можете да я посочите непряко чрез функция в B2, като въведете <item type=\"input\">=ABS(INDIRECT(B2))</item>. Резултатът е абсолютната стойност на обръщението към клетка, зададено в B2, която в примера е 6." - -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" "bm_id3150372\n" "help.text" msgid "<bookmark_value>AREAS function</bookmark_value>" @@ -20276,6 +20268,14 @@ msgstr "<item type=\"input\">=SUM(INDIRECT(\"a1:\" & ADDRESS(1;3)))</item> су #: 04060109.xhp msgctxt "" "04060109.xhp\n" +"par_id3159260\n" +"help.text" +msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." +msgstr "Ако клетката A1 от лист 2 съдържа стойността <item type=\"input\">-6</item>, можете да я посочите непряко чрез функция в B2, като въведете <item type=\"input\">=ABS(INDIRECT(B2))</item>. Резултатът е абсолютната стойност на обръщението към клетка, зададено в B2, която в примера е 6." + +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" "bm_id3154818\n" "help.text" msgid "<bookmark_value>COLUMN function</bookmark_value>" @@ -35550,8 +35550,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3148437\n" "help.text" -msgid "COUNT" -msgstr "COUNT" +msgid "<variable id=\"count_head\"><link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -35622,8 +35622,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3149729\n" "help.text" -msgid "COUNTA" -msgstr "COUNTA" +msgid "<variable id=\"counta_head\"><link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -35694,8 +35694,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3150896\n" "help.text" -msgid "COUNTBLANK" -msgstr "COUNTBLANK" +msgid "<variable id=\"countblank_head\"><link href=\"text/scalc/01/04060181.xhp#countblank\">COUNTBLANK</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -35758,8 +35758,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3164897\n" "help.text" -msgid "COUNTIF" -msgstr "COUNTIF" +msgid "<variable id=\"countif_head\"><link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -41174,8 +41174,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3154511\n" "help.text" -msgid "MAX" -msgstr "MAX" +msgid "<variable id=\"max_head\"><link href=\"text/scalc/01/04060184.xhp#max\">MAX</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41254,8 +41254,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3166426\n" "help.text" -msgid "MAXA" -msgstr "MAXA" +msgid "<variable id=\"maxa_head\"><link href=\"text/scalc/01/04060184.xhp#maxa\">MAXA</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41334,8 +41334,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3153820\n" "help.text" -msgid "MEDIAN" -msgstr "MEDIAN" +msgid "<variable id=\"median_head\"><link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41406,8 +41406,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3154541\n" "help.text" -msgid "MIN" -msgstr "MIN" +msgid "<variable id=\"min_head\"><link href=\"text/scalc/01/04060184.xhp#min\">MIN</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41478,8 +41478,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3147504\n" "help.text" -msgid "MINA" -msgstr "MINA" +msgid "<variable id=\"mina_head\"><link href=\"text/scalc/01/04060184.xhp#mina\">MINA</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41558,8 +41558,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3166465\n" "help.text" -msgid "AVEDEV" -msgstr "AVEDEV" +msgid "<variable id=\"avedev_head\"><link href=\"text/scalc/01/04060184.xhp#avedev\">AVEDEV</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41622,8 +41622,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3145824\n" "help.text" -msgid "AVERAGE" -msgstr "AVERAGE" +msgid "<variable id=\"average_head\"><link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41686,8 +41686,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3148754\n" "help.text" -msgid "AVERAGEA" -msgstr "AVERAGEA" +msgid "<variable id=\"averagea_head\"><link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -56897,6 +56897,78 @@ msgctxt "" msgid "not" msgstr "не" +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id1191767622119\n" +"help.text" +msgid "In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id961527953004850\n" +"help.text" +msgid "<variable id=\"args\">Func_Range; Range1; Criterion1 [ ; Range2; Criterion2 [;...]])</variable>" +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id94162948227556\n" +"help.text" +msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Func_Range</emph> is taken into calculation." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id14734320631377\n" +"help.text" +msgid "<emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id23526994221948\n" +"help.text" +msgid "<emph>Criterion1</emph> – required argument. A string expression representing a logical condition or a cell reference to such string expression. The expression can contain text, numbers, regular expressions or wildcards (<link href=\"text/shared/optionen/01060500.xhp#wildcards\" name=\"Wild cards\">if enabled in calculation options</link>)." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id190621657742\n" +"help.text" +msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id317001803813193\n" +"help.text" +msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id191527781733238\n" +"help.text" +msgid "The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id175721789527973\n" +"help.text" +msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)." +msgstr "" + #: exponsmooth_embd.xhp msgctxt "" "exponsmooth_embd.xhp\n" @@ -58185,14 +58257,6 @@ msgctxt "" msgid "The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145." msgstr "Функцията търси кои стойности от диапазона B2:B6 са по-малки от стойността, зададена в E2, и изчислява средното на съответните им стойности от диапазона C2:C6. Ако E2 = 35, резултатът ще бъде 145." -#: func_averageif.xhp -msgctxt "" -"func_averageif.xhp\n" -"par_id171371269326270\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>" -msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>" - #: func_averageifs.xhp msgctxt "" "func_averageifs.xhp\n" @@ -58238,72 +58302,16 @@ msgctxt "" "func_averageifs.xhp\n" "par_id21050267713178\n" "help.text" -msgid "AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]])" -msgstr "AVERAGEIFS(Диапазон_за_усредняване; Диапазон_за_критерий1; Критерий1 [; Диапазон_за_критерий2; Критерий2 [; ...]])" +msgid "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" #: func_averageifs.xhp msgctxt "" "func_averageifs.xhp\n" "par_id165832700711773\n" "help.text" -msgid "<emph>Average_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." -msgstr "<emph>Диапазон_за_усредняване</emph> – задължителен аргумент. Диапазон от клетки, име на наименуван диапазон или заглавие на ред или колона, съдържаща числата за усредняване." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id23557225011065\n" -"help.text" -msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." -msgstr "<emph>Диапазон_за_критерий1</emph> – задължителен аргумент. Диапазон от клетки, име на наименуван диапазон или заглавие на ред или колона за проверяване на съответния критерий." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id115612745015792\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Критерий1</emph> – задължителен аргумент. Условие под формата на израз или обръщение към клетка с израз, което определя кои клетки да се използват при изчисляване на средното. Изразът може да съдържа текст, числа, регулярни изрази (ако са разрешени в настройките за изчисляване) или заместващи знаци (ако са разрешени в настройките за изчисляване)." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id249477513695\n" -"help.text" -msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." -msgstr "<emph>Диапазон_за_критерий2</emph> – незадължителен. „Диапазон_за_критерий2“ и всички следващи имат значение, аналогично на „Диапазон_за_критерий1“." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id157492744623347\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Критерий2</emph> – незадължителен. „Критерий2“ и всички следващи имат значение, аналогично на „Критерий1“." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id262061474420658\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Average_range is taken into calculation of the mean.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for it." -msgstr "Логическото отношение между критериите може да се дефинира като логическо „И“ (конюнкция). С други думи, стойността от съответната клетка на <emph>Диапазон_за_усредняване</emph> ще участва в изчисляването на средната стойност тогава и само тогава, когато са удовлетворени всички зададени критерии.<br/><emph>Критерий</emph> трябва да бъде низов израз, в частност да бъде ограден с кавички (\"Критерий\") с изключение на имената на функции, обръщенията към клетки и операцията слепване на низове (&).<br/>В аргументите с критерии могат да се използват отношенията равно (=), не равно (<>), по-голямо (>), по-голямо или равно (>=), по-малко (<) и по-малко или равно (<=) за сравняване на числа.<br/>Функцията може да има до 255 аргумента, което означава, че можете да зададете 127 диапазона за критерии и съответните им критерии." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id51531273215056\n" -"help.text" -msgid "If a cell in a range of values for calculating the mean is empty or contains text, the function AVERAGEIFS ignores this cell.<br/>If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error.<br/>If the range of values for calculating the mean and any range for finding criterion have unequal sizes, the function returns err:502." -msgstr "Ако някоя клетка в диапазон от стойности за изчисляване на средно е празна или съдържа текст, функцията AVERAGEIFS пропуска тази клетка.<br/>Стойност TRUE в клетка се третира като 1, а FALSE – като 0 (нула).<br/>Ако целият диапазон е празен, съдържа само текст или никоя стойност от него не удовлетворява условието (или съчетание от изброените), функцията поражда грешка #DIV/0!.<br/>Ако диапазонът от стойности за усредняване и който и да е от диапазоните за критерии имат различни размери, функцията връща err:502." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id151201977228038\n" -"help.text" -msgid "In all examples below, ranges for average calculation contain the row #6, but it is ignored, because it contains text." -msgstr "Във всички примери по-долу диапазонът за изчисляване на средна стойност съдържа ред №6, но той се игнорира, защото съдържа текст." +msgid "<emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." +msgstr "" #: func_averageifs.xhp msgctxt "" @@ -58417,14 +58425,6 @@ msgctxt "" msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." msgstr "Ако E2 = \"леп\", функцията връща 65, защото връзката към клетката се замества със съдържанието ѝ." -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id1279148769260\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" - #: func_color.xhp msgctxt "" "func_color.xhp\n" @@ -58542,8 +58542,8 @@ msgctxt "" "func_countifs.xhp\n" "par_id462646264626\n" "help.text" -msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of rows or columns that meet criteria in multiple ranges.</variable></ahelp>" -msgstr "<ahelp hid=\".\"><variable id=\"countifs_des\">Връща броя на редовете или колоните, които отговарят на критериите, в няколко диапазона.</variable></ahelp>" +msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" +msgstr "" #: func_countifs.xhp msgctxt "" @@ -58572,42 +58572,10 @@ msgstr "<emph>Диапазон1</emph> – задължителен аргуме #: func_countifs.xhp msgctxt "" "func_countifs.xhp\n" -"par_id23526994221948\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used for counting. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Критерий1</emph> – задължителен аргумент. Условие под формата на израз или обръщение към клетка с израз, което определя кои клетки да се използват за преброяването. Изразът може да съдържа текст, числа, регулярни изрази (ако са разрешени в настройките за изчисляване) или заместващи знаци (ако са разрешени в настройките за изчисляване)." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id190621657742\n" -"help.text" -msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." -msgstr "<emph>Диапазон2</emph> – незадължителен. „Диапазон2“ и всички следващи имат значение, аналогично на „Диапазон1“." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id317001803813193\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Критерий2</emph> – незадължителен. „Критерий2“ и всички следващи имат значение, аналогично на „Критерий1“." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id14223137501158\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a row or a column is taken into counting.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 500 arguments, meaning that you can specify 250 pairs of ranges and criteria." -msgstr "Логическото отношение между критериите може да се дефинира като логическо „И“ (конюнкция). С други думи, съответният ред или колона се преброява тогава и само тогава, когато са удовлетворени всички зададени критерии.<br/><emph>Критерий</emph> трябва да бъде низов израз, в частност да бъде ограден с кавички (\"Критерий\") с изключение на имената на функции, обръщенията към клетки и операцията слепване на низове (&).<br/>В аргументите с критерии могат да се използват отношенията равно (=), не равно (<>), по-голямо (>), по-голямо или равно (>=), по-малко (<) и по-малко или равно (<=) за сравняване на числа.<br/>Функцията може да има до 500 аргумента, което означава, че можете да зададете 250 диапазона за критерии и съответните им критерии." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id16654883224356\n" +"par_id14734320631377\n" "help.text" -msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If ranges for arguments <emph>Range</emph> and <emph>Criterion</emph> have unequal sizes, the function returns err:502." -msgstr "Стойност TRUE в клетка се третира като 1, а FALSE – като 0 (нула).<br/>Ако диапазоните за аргументите <emph>Диапазон</emph> и <emph>Критерий</emph> имат различни размери, функцията връща err:502." +msgid "<emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." +msgstr "" #: func_countifs.xhp msgctxt "" @@ -58737,14 +58705,6 @@ msgctxt "" msgid "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." msgstr "Ако E2 = \"леп\", функцията връща 1, защото връзката към клетката се замества със съдържанието ѝ и функцията работи като в предишния пример." -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id14337286612130\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" - #: func_date.xhp msgctxt "" "func_date.xhp\n" @@ -61545,6 +61505,342 @@ msgctxt "" msgid "=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04." msgstr "=ISOWEEKNUM(DATE(1995;1;1)) връща 53. Седмица 1 започва в понеделник, 04.01.1999 г." +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"tit\n" +"help.text" +msgid "MAXIFS function" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"bm_id658066580665806\n" +"help.text" +msgid "<bookmark_value>MAXIFS function</bookmark_value> <bookmark_value>maximum;satisfying conditions</bookmark_value>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id658866588665886\n" +"help.text" +msgid "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable> function" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id659756597565975\n" +"help.text" +msgid "<ahelp hid=\".\"><variable id=\"maxifs_des\">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id660246602466024\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id11655988824213\n" +"help.text" +msgid "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id59901690530236\n" +"help.text" +msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id193452436229521\n" +"help.text" +msgid "Simple usage" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id94321051525036\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id28647227259438\n" +"help.text" +msgid "Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id36952767622741\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id189772445525114\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id30455222431067\n" +"help.text" +msgid "Using regular expressions and nested functions" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id307691022525348\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id27619246864839\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id220502883332563\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id15342189586295\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id8168283329426\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id50762995519951\n" +"help.text" +msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id135761606425300\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id30574750215839\n" +"help.text" +msgid "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"tit\n" +"help.text" +msgid "MINIFS function" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"bm_id658066580665806\n" +"help.text" +msgid "<bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id658866588665886\n" +"help.text" +msgid "<variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable> function" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id659756597565975\n" +"help.text" +msgid "<ahelp hid=\".\"><variable id=\"minifs_des\">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id660246602466024\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id11655988824213\n" +"help.text" +msgid "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id59901690530236\n" +"help.text" +msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id193452436229521\n" +"help.text" +msgid "Simple usage" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id94321051525036\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id28647227259438\n" +"help.text" +msgid "Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id36952767622741\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id189772445525114\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id30455222431067\n" +"help.text" +msgid "Using regular expressions and nested functions" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id307691022525348\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id27619246864839\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and minimum. Returns 65." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id220502883332563\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\"<=\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id15342189586295\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its minimum. Returns 180." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id8168283329426\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id50762995519951\n" +"help.text" +msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id135761606425300\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id30574750215839\n" +"help.text" +msgid "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." +msgstr "" + #: func_minute.xhp msgctxt "" "func_minute.xhp\n" @@ -62582,80 +62878,16 @@ msgctxt "" "func_sumifs.xhp\n" "par_id11655988824213\n" "help.text" -msgid "SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]])" -msgstr "SUMIFS(Диапазон_за_сумиране; Диапазон_за_критерий1; Критерий1 [; Диапазон_за_критерий2; Критерий2 [; ...]])" +msgid "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" #: func_sumifs.xhp msgctxt "" "func_sumifs.xhp\n" "par_id59901690530236\n" "help.text" -msgid "<emph>Sum_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." -msgstr "<emph>Диапазон_за_сумиране</emph> – задължителен аргумент. Диапазон от клетки, име на наименуван диапазон или заглавие на ред или колона, съдържаща числата за изчисляване на сумата." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14445505532098\n" -"help.text" -msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." -msgstr "<emph>Диапазон_за_критерий1</emph> – задължителен аргумент. Диапазон от клетки, име на наименуван диапазон или заглавие на ред или колона за проверяване на съответния критерий." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id24470258022447\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the sum. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Критерий1</emph> – задължителен аргумент. Условие под формата на израз или обръщение към клетка с израз, което определя кои клетки да се използват при изчисляване на сумата. Изразът може да съдържа текст, числа, регулярни изрази (ако са разрешени в настройките за изчисляване) или заместващи знаци (ако са разрешени в настройките за изчисляване)." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id111151356820933\n" -"help.text" -msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." -msgstr "<emph>Диапазон_за_критерий2</emph> – незадължителен. „Диапазон_за_критерий2“ и всички следващи имат значение, аналогично на „Диапазон_за_критерий1“." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14734320631376\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Критерий2</emph> – незадължителен. „Критерий2“ и всички следващи имат значение, аналогично на „Критерий1“." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14734320631377\n" -"help.text" -msgid "<emph>Sum_Range</emph> and <emph>Criterion_range1, Criterion_range2...</emph> must have the same size or the function returns err:502 - Invalid argument." -msgstr "<emph>Диапазон_за_сумиране</emph> и <emph>Диапазон_за_критерий1, Диапазон_за_критерий2...</emph> трябва да имат еднакъв размер или функцията ще върне err:502 - невалиден аргумент." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id94162948227556\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Sum_Range</emph> is taken into calculation of the sum.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them." -msgstr "Логическото отношение между критериите може да се дефинира като логическо „И“ (конюнкция). С други думи, стойността от съответната клетка на <emph>Диапазон_за_сумиране</emph> ще участва в изчисляването на сумата тогава и само тогава, когато са удовлетворени всички зададени критерии.<br/><emph>Критерий</emph> трябва да бъде низов израз, в частност да бъде ограден с кавички (\"Критерий\") с изключение на имената на функции, обръщенията към клетки и операцията слепване на низове (&).<br/>В аргументите с критерии могат да се използват отношенията равно (=), не равно (<>), по-голямо (>), по-голямо или равно (>=), по-малко (<) и по-малко или равно (<=) за сравняване на числа.<br/>Функцията може да има до 255 аргумента, което означава, че можете да зададете 127 диапазона за критерии и съответните им критерии." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id175721789527973\n" -"help.text" -msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)." -msgstr "Стойност TRUE в клетка се третира като 1, а FALSE – като 0 (нула)." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id1191767622119\n" -"help.text" -msgid "In all examples below, ranges for sum calculation contain the row #6, but it is ignored, because it contains text." -msgstr "Във всички примери по-долу диапазонът за изчисляване на сума съдържа ред №6, но той се игнорира, защото съдържа текст." +msgid "<emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." +msgstr "" #: func_sumifs.xhp msgctxt "" @@ -62769,14 +63001,6 @@ msgctxt "" msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." msgstr "Ако E2 = \"леп\", функцията връща 65, защото връзката към клетката се замества със съдържанието ѝ." -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id11921178730928\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" - #: func_time.xhp msgctxt "" "func_time.xhp\n" |