diff options
Diffstat (limited to 'source/vi/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/vi/helpcontent2/source/text/scalc/01.po | 651 |
1 files changed, 528 insertions, 123 deletions
diff --git a/source/vi/helpcontent2/source/text/scalc/01.po b/source/vi/helpcontent2/source/text/scalc/01.po index 0639eb7407b..ce5d008d6b4 100644 --- a/source/vi/helpcontent2/source/text/scalc/01.po +++ b/source/vi/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: 2024-03-04 14:25+0100\n" +"POT-Creation-Date: 2024-04-02 12:12+0200\n" "PO-Revision-Date: 2020-12-31 12:36+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: Vietnamese <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/vi/>\n" @@ -14002,96 +14002,6 @@ msgctxt "" msgid "<item type=\"input\">=SINH(0)</item> returns 0, the hyperbolic sine of 0." msgstr "<item type=\"input\">=SINH(0)</item> trả về 0, sin hyperbol của 0." -#. LAWCJ -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id3151957\n" -"help.text" -msgid "<bookmark_value>SUMIF function</bookmark_value> <bookmark_value>adding;specified numbers</bookmark_value>" -msgstr "<bookmark_value>hàm SUMIF</bookmark_value><bookmark_value>cộng;những số đã ghi rõ</bookmark_value>" - -#. CGGGj -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3151957\n" -"help.text" -msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>" -msgstr "" - -#. p2fHt -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3151986\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criterion.</ahelp> This function is used to sum a range when you search for a certain value." -msgstr "" - -#. GKQGQ -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3152028\n" -"help.text" -msgid "SUMIF(Range; Criterion [; SumRange])" -msgstr "" - -#. wmLcE -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3152043\n" -"help.text" -msgid "<emph>Range</emph> is the range to which the criterion is to be applied." -msgstr "" - -#. FCxrw -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3152083\n" -"help.text" -msgid "<emph>SumRange</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed." -msgstr "<emph>Phạm_vi_tổng</emph> là phạm vi từ đó cộng lại các giá trị. Không đưa ra tham số này thì cộng lại các giá trị nằm trong Phạm_vi." - -#. iGKyo -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8347422\n" -"help.text" -msgid "SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given." -msgstr "" - -#. uazzL -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3152148\n" -"help.text" -msgid "To sum up only negative numbers: <item type=\"input\">=SUMIF(A1:A10;\"<0\")</item>" -msgstr "Để cộng lại chỉ những số âm: <item type=\"input\">=SUMIF(A1:A10;\"<0\")</item>" - -#. GGT9C -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id6670125\n" -"help.text" -msgid "<item type=\"input\">=SUMIF(A1:A10;\">0\";B1:B10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0." -msgstr "" - -#. G5vdm -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id6062196\n" -"help.text" -msgid "See COUNTIF() for some more syntax examples that can be used with SUMIF()." -msgstr "Xem hàm COUNTIF() để tìm thêm mẫu ví dụ cú pháp có thể dùng với hàm SUMIF()." - #. BHGzQ #: 04060106.xhp msgctxt "" @@ -56212,24 +56122,6 @@ msgctxt "" msgid "Product Name" msgstr "" -#. HZpK7 -#: ex_data_stat_func.xhp -msgctxt "" -"ex_data_stat_func.xhp\n" -"par_id2509201517433075\n" -"help.text" -msgid "Sales" -msgstr "" - -#. NEEL8 -#: ex_data_stat_func.xhp -msgctxt "" -"ex_data_stat_func.xhp\n" -"par_id2509201519383294\n" -"help.text" -msgid "Revenue" -msgstr "" - #. ZyGBE #: ex_data_stat_func.xhp msgctxt "" @@ -56266,29 +56158,29 @@ msgctxt "" msgid "book" msgstr "" -#. 48CjE +#. NTJ7A #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" -"par_id19479417931163\n" +"par_id491711556981497\n" "help.text" msgid "pencil-case" msgstr "" -#. w8ZSP +#. jwABa #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" -"par_id85353130721737\n" +"par_id981711556984697\n" "help.text" msgid "not" msgstr "" -#. EYktc +#. cAKeZ #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" -"par_id15693941827291\n" +"par_id581711556987385\n" "help.text" msgid "not" msgstr "" @@ -68092,22 +67984,211 @@ msgctxt "" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sort.xhp\">SORT</link></variable>" msgstr "" -#. 4Ky6H +#. JkEQn #: func_sort.xhp msgctxt "" "func_sort.xhp\n" "par_id771708806478128\n" "help.text" -msgid "(...)" +msgid "Sorts the contents of a range or array." msgstr "" -#. NFc8B +#. JFZRF +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id131711543270539\n" +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "" + +#. LksfE #: func_sort.xhp msgctxt "" "func_sort.xhp\n" "par_id211708281649651\n" "help.text" -msgid "SORT(...)" +msgid "SORT(Range [, SortIndex[, SortOrder[, ByCol]]])" +msgstr "" + +#. 4iAJz +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id551711457515235\n" +"help.text" +msgid "<emph>Range:</emph> Required. The range or array to sort." +msgstr "" + +#. Epf9D +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id151711457520290\n" +"help.text" +msgid "<emph>SortIndex:</emph> Optional. The number indicating the row or column to sort by." +msgstr "" + +#. 2cgDj +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id131711457525811\n" +"help.text" +msgid "<emph>SortOrder:</emph> Optional. A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order." +msgstr "" + +#. JwCYE +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id351711457531579\n" +"help.text" +msgid "<emph>ByCol:</emph> Optional. A logical value indicating the desired sort direction; <emph>FALSE</emph> to sort by row (default), <emph>TRUE</emph> to sort by column." +msgstr "" + +#. hDBib +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"hd_id751711480783220\n" +"help.text" +msgid "Example with ascending order" +msgstr "" + +#. RmqyT +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id131711466000482\n" +"help.text" +msgid "<input>{=SORT(A2:C6,2,1)}</input>" +msgstr "" + +#. MBgRu +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id471711472262161\n" +"help.text" +msgid "Sort the range A2:C6 based on the second column in ascending order (Sales)." +msgstr "" + +#. EQiyc +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id31711465709083\n" +"help.text" +msgid "book" +msgstr "" + +#. AA3th +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id861711465758906\n" +"help.text" +msgid "pencil" +msgstr "" + +#. zjCpK +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id331711465788257\n" +"help.text" +msgid "notebook" +msgstr "" + +#. GDXFf +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id821711465827777\n" +"help.text" +msgid "pen" +msgstr "" + +#. ofndu +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id11711465871342\n" +"help.text" +msgid "pencil-case" +msgstr "" + +#. pvfNi +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"hd_id51711480751179\n" +"help.text" +msgid "Example with descending order" +msgstr "" + +#. x5oDE +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id731711466320553\n" +"help.text" +msgid "<input>{=SORT(A2:C6,3,-1)}</input>" +msgstr "" + +#. FSrYH +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id401711479167509\n" +"help.text" +msgid "Sort the range A2:C6 based on the third column in descending order (Revenue)." +msgstr "" + +#. 5KSd6 +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id821711478931934\n" +"help.text" +msgid "pencil-case" +msgstr "" + +#. hHqSc +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id721711478941598\n" +"help.text" +msgid "notebook" +msgstr "" + +#. Eh74E +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id281711478950341\n" +"help.text" +msgid "book" +msgstr "" + +#. KGKEY +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id101711478960309\n" +"help.text" +msgid "pen" +msgstr "" + +#. fjhFK +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id911711478969701\n" +"help.text" +msgid "pencil" msgstr "" #. JDbrP @@ -68146,22 +68227,112 @@ msgctxt "" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sortby.xhp\">SORTBY</link></variable>" msgstr "" -#. EFPmE +#. jCSNU #: func_sortby.xhp msgctxt "" "func_sortby.xhp\n" "par_id771708806478128\n" "help.text" -msgid "(...)" +msgid "Sorts the contents of a range or array based on the values in a corresponding range or array." msgstr "" -#. 6QrpC +#. EUgaa #: func_sortby.xhp msgctxt "" "func_sortby.xhp\n" "par_id211708281649651\n" "help.text" -msgid "SORTBY(...)" +msgid "SORTBY(Range, SortByRange1, SortOrder1[, SortByRange2, SortOrder2,[...]])" +msgstr "" + +#. gifyS +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id451711544450734\n" +"help.text" +msgid "<emph>Range</emph>: The array or range to sort." +msgstr "" + +#. k3ADs +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id291711544460323\n" +"help.text" +msgid "<emph>SortByRange1, SortByRange2,... </emph>: Range 1, range 2,... are the arrays or ranges to sort on." +msgstr "" + +#. FTuBa +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id501711544465886\n" +"help.text" +msgid "<emph>SortOrder1, SortOrder2,...</emph> : Order 1, order 2,... are the orders to use for sorting. 1 for ascending, -1 for descending. Default is ascending." +msgstr "" + +#. EoHgm +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"hd_id2609201512474295\n" +"help.text" +msgid "Consider the following table" +msgstr "" + +#. XrQNH +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id2509201519371339\n" +"help.text" +msgid "5" +msgstr "" + +#. 2v5YQ +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id981711556984697\n" +"help.text" +msgid "not" +msgstr "" + +#. LBEMB +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id581711556987385\n" +"help.text" +msgid "not" +msgstr "" + +#. sbyoX +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"hd_id751711480783220\n" +"help.text" +msgid "Example with ascending order and descending order (for English locale)" +msgstr "" + +#. FA2hL +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id131711466000482\n" +"help.text" +msgid "<input>{=SORTBY(A2:C7,A2:A7,1,C2:C7,-1)}</input>" +msgstr "" + +#. q9cpQ +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id471711472262161\n" +"help.text" +msgid "Sort the range A2:C7 based on the first column in ascending order and third column in descending order." msgstr "" #. fKeqF @@ -68461,6 +68632,240 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM\">SUM wiki page</link>." msgstr "" +#. yiPhX +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"tit\n" +"help.text" +msgid "SUMIF Function" +msgstr "" + +#. c4KFv +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"bm_id3151957\n" +"help.text" +msgid "<bookmark_value>SUMIF function</bookmark_value> <bookmark_value>adding;specified numbers</bookmark_value>" +msgstr "" + +#. aJCj8 +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"hd_id3151957\n" +"help.text" +msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/func_sumif.xhp\">SUMIF</link></variable>" +msgstr "" + +#. AWAK5 +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id3151986\n" +"help.text" +msgid "<ahelp hid=\".\">Determines which values in a range of cells meet a specified criterion, then returns the sum of the matching values. Alternatively the function can determine which values in one range of cells meet a criterion, then return the sum of values in the corresponding cells in a second range of cells.</ahelp>" +msgstr "" + +#. DFaC8 +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id411711032873068\n" +"help.text" +msgid "SUMIF can only apply a single criterion to a range. Use <link href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\">SUMIFS</link> if you need to apply multiple criteria." +msgstr "" + +#. F7YsR +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id3152028\n" +"help.text" +msgid "<input>SUMIF(Range; Criterion [;SumRange])</input>" +msgstr "" + +#. D2NiD +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id3152043\n" +"help.text" +msgid "<emph>Range: </emph> The range of cells to which the criterion is applied." +msgstr "" + +#. ToLFA +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id521711134077228\n" +"help.text" +msgid "SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given." +msgstr "" + +#. BMGEn +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id3152083\n" +"help.text" +msgid "<emph>SumRange: </emph>Optional. The range of cells from which values are summed. If no SumRange is given, the values in the Range are summed." +msgstr "" + +#. oviCS +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"hd_id451710857799382\n" +"help.text" +msgid "Simple usage" +msgstr "" + +#. FsERF +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id171711049202378\n" +"help.text" +msgid "<input>=SUMIF(C2:C6,\">=100\")</input>" +msgstr "" + +#. 6mqDE +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id381711049216331\n" +"help.text" +msgid "Sums only the values from range C2:C6 that are >=100. Returns 370 because cells C2:C3 do not meet the criterion. The values from Range are summed because no SumRange is given." +msgstr "" + +#. AEAwA +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id6670125\n" +"help.text" +msgid "<input>=SUMIF(B2:B5,\">=20\",C2:C6)</input>" +msgstr "" + +#. nUdXV +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id341710857230552\n" +"help.text" +msgid "Sums values from the range B2:B6 only if the corresponding values in the range A1:A5 are >=20. Returns 340 because the fifth and sixth rows do not meet the criterion." +msgstr "" + +#. Zjs4B +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"hd_id291710867590698\n" +"help.text" +msgid "Using regular expressions" +msgstr "" + +#. 2XByE +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id911710859836541\n" +"help.text" +msgid "<input>=SUMIF(A2:A6,\"pen\",C2:C5)</input>" +msgstr "" + +#. 3ggQs +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id31710859838046\n" +"help.text" +msgid "Sums values from the range C2:C6 only if the corresponding range in A2:A6 exactly match the letters \"pen\". Returns 85 because rows A2 and A4:A6 do not meet the criterion." +msgstr "" + +#. L9Ftz +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id781710871590769\n" +"help.text" +msgid "<input>=SUMIF(A2:A6,\"pen*\",C2:C6)</input>" +msgstr "" + +#. netyd +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id431710871624405\n" +"help.text" +msgid "Sums the values from the range C2:C6 only if the corresponding cell in range A2:A6 contains the letters \"pen\". Returns the value 150 because rows A4:A5 do not meet the criterion." +msgstr "" + +#. PdFbx +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id311711128230771\n" +"help.text" +msgid "<input>=SUMIF(ProductName,\"pen*\",Revenue)</input>" +msgstr "" + +#. ZeyUD +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id741711128545751\n" +"help.text" +msgid "A named range can be given as the Range or SumRange parameter. For example, if the columns in the above table are respectively named \"ProductName\", \"Sales\", and \"Revenue\", the function returns 150. This function will only work as described if you have defined the names of the columns using the <link href=\"text/scalc/01/04070100.xhp#definenames)\">Define Names</link> dialog." +msgstr "" + +#. amnCv +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"hd_id531711029933195\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "" + +#. sGzYo +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id561711031254255\n" +"help.text" +msgid "If you need to change a criterion easily, you may specify it in a separate cell and use a reference to this cell in the condition of the SUMIFS function. For example:" +msgstr "" + +#. pAzfZ +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id331711030450765\n" +"help.text" +msgid "<input>=SUMIF(A2:A6,E2,C2:C6)</input>" +msgstr "" + +#. sFiDn +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id11711031541218\n" +"help.text" +msgid "If E2 = pen, the function returns 85 because the link to the cell is substituted with its contents." +msgstr "" + +#. gyimf +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id771677014538669\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIF\">SUMIF wiki page</link>." +msgstr "" + #. DfceH #: func_sumifs.xhp msgctxt "" |