Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=128
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=129", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=127", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=ARABIC(\"\")</input> returns 0." ], "previous_source": "", "target": [ "" ], "id_hash": 2149052753531567360, "content_hash": 2149052753531567360, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id101628778036134\nhelp.text", "note": "XAwC8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6351, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99294934/?format=api", "priority": 100, "id": 99525543, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9dd2f817d9d2fd00", "url": "https://translations.documentfoundation.org/api/units/99525543/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.631543Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ARABIC\">ARABIC wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -5167763158430399129, "content_hash": -5167763158430399129, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id721677017247207\nhelp.text", "note": "RiAmq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6352, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99295023/?format=api", "priority": 100, "id": 99525552, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=38486ac99267c567", "url": "https://translations.documentfoundation.org/api/units/99525552/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.635807Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "ASC Function" ], "previous_source": "", "target": [ "" ], "id_hash": -8652401929046431600, "content_hash": -8652401929046431600, "location": "func_asc.xhp", "context": "func_asc.xhp\ntit\nhelp.text", "note": "yugTC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6353, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99295034/?format=api", "priority": 100, "id": 99525558, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=07ec7e49b5486890", "url": "https://translations.documentfoundation.org/api/units/99525558/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.638788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>ASC function</bookmark_value> <bookmark_value>text functions;katakana characters</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2033509273286519076, "content_hash": 2033509273286519076, "location": "func_asc.xhp", "context": "func_asc.xhp\nbm_id831542233029549\nhelp.text", "note": "H3kmF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6354, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99295072/?format=api", "priority": 100, "id": 99525570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9c3879e8f9b4a924", "url": "https://translations.documentfoundation.org/api/units/99525570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.644410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"Asc_h1\"><link href=\"text/scalc/01/func_asc.xhp\">ASC</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4674716539090233647, "content_hash": 4674716539090233647, "location": "func_asc.xhp", "context": "func_asc.xhp\nhd_id881628776094597\nhelp.text", "note": "4QDi7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6355, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99295103/?format=api", "priority": 100, "id": 99525576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c0dfedecb21de92f", "url": "https://translations.documentfoundation.org/api/units/99525576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.648369Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"func_asc_desc\"><ahelp hid=\".\">Converts double-byte (full-width) characters to single-byte (half-width) ASCII and katakana characters.</ahelp></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4764700226986414585, "content_hash": 4764700226986414585, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id541542230672101\nhelp.text", "note": "gtGVG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6356, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99295165/?format=api", "priority": 100, "id": 99525582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c21f9d9caabf91f9", "url": "https://translations.documentfoundation.org/api/units/99525582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.652223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table." ], "previous_source": "", "target": [ "" ], "id_hash": -2248704534092048979, "content_hash": -2248704534092048979, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id151634221012221\nhelp.text", "note": "XLLvR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6357, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99295231/?format=api", "priority": 100, "id": 99525588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=60caff23f0a215ad", "url": "https://translations.documentfoundation.org/api/units/99525588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.656017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>ASC(Text)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 1984221053926592892, "content_hash": 1984221053926592892, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id701542231253817\nhelp.text", "note": "nWQan", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6358, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99295271/?format=api", "priority": 100, "id": 99525594, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9b895e892325517c", "url": "https://translations.documentfoundation.org/api/units/99525594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.659768Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Text</emph>: the text string that contains characters to be converted." ], "previous_source": "", "target": [ "" ], "id_hash": 1069580224952227621, "content_hash": 1069580224952227621, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id621542232197446\nhelp.text", "note": "npFEH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6359, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99295290/?format=api", "priority": 100, "id": 99525609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8ed7e98c370f5725", "url": "https://translations.documentfoundation.org/api/units/99525609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.663726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Applying the ASC function to a string composed of single-byte characters will return the input string without any modifications." ], "previous_source": "", "target": [ "" ], "id_hash": 1269744216934721748, "content_hash": 1269744216934721748, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id481637763523789\nhelp.text", "note": "d9fM4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6360, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99295320/?format=api", "priority": 100, "id": 99525612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=919f09a34e0028d4", "url": "https://translations.documentfoundation.org/api/units/99525612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.670789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=ASC(\"LibreOffice\")</input> returns the string \"LibreOffice\". No modifications were made because all characters are single-byte characters." ], "previous_source": "", "target": [ "" ], "id_hash": 3319135713135655068, "content_hash": 3319135713135655068, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id451628776707264\nhelp.text", "note": "QXBHB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6361, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99295345/?format=api", "priority": 100, "id": 99525616, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ae0ff05876c3789c", "url": "https://translations.documentfoundation.org/api/units/99525616/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.672628Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=ASC(\"ライト\")</input> returns the string \"ライト\", which is composed of single-byte characters." ], "previous_source": "", "target": [ "" ], "id_hash": 890746019328749070, "content_hash": 890746019328749070, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id101628778036375\nhelp.text", "note": "f8rff", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6362, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99295371/?format=api", "priority": 100, "id": 99525621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8c5c90c9032eee0e", "url": "https://translations.documentfoundation.org/api/units/99525621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.674453Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ASC\">ASC wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 7027448374366038921, "content_hash": 7027448374366038921, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id931677017229646\nhelp.text", "note": "tRpRD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6363, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99295394/?format=api", "priority": 100, "id": 99525627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e18683103f7beb89", "url": "https://translations.documentfoundation.org/api/units/99525627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.676051Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "AVERAGEIF function" ], "previous_source": "", "target": [ "Función PERMEDIUSI" ], "id_hash": 7906118277027848232, "content_hash": 7906118277027848232, "location": "func_averageif.xhp", "context": "func_averageif.xhp\ntit\nhelp.text", "note": "y9q7t", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6364, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99295420/?format=api", "priority": 100, "id": 99525631, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=edb82caf3e77e028", "url": "https://translations.documentfoundation.org/api/units/99525631/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.678556Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>AVERAGEIF function</bookmark_value> <bookmark_value>arithmetic mean;satisfying condition</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función PERMEDIUSI</bookmark_value><bookmark_value>media aritmética;condición satisfactoria</bookmark_value>" ], "id_hash": 3420912059300929210, "content_hash": 3420912059300929210, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nbm_id237812197829662\nhelp.text", "note": "Xqih3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6365, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99295465/?format=api", "priority": 100, "id": 99525653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=af798564a67b5eba", "url": "https://translations.documentfoundation.org/api/units/99525653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.696238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"averageif_head\"><link href=\"text/scalc/01/func_averageif.xhp\">AVERAGEIF</link></variable> function" ], "previous_source": "", "target": [ "<variable id=\"time\"><link href=\"text/scalc/01/func_time.xhp\">HORA</link></variable>" ], "id_hash": -5363749350071768942, "content_hash": -5363749350071768942, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id16852304621982\nhelp.text", "note": "c5oJz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6366, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99295493/?format=api", "priority": 100, "id": 99525660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=359022626cbd6892", "url": "https://translations.documentfoundation.org/api/units/99525660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.699019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"averageif_des\">Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -6622583741804826371, "content_hash": -6622583741804826371, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id7281266615152\nhelp.text", "note": "DFigD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6367, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/99295518/?format=api", "priority": 100, "id": 99525674, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2417db2cbe7230fd", "url": "https://translations.documentfoundation.org/api/units/99525674/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.705861Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "AVERAGEIF(Range; Criterion [; Average_Range ])" ], "previous_source": "", "target": [ "" ], "id_hash": -993686738782804889, "content_hash": -993686738782804889, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id200801176228491\nhelp.text", "note": "jto8p", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6368, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99295548/?format=api", "priority": 100, "id": 99525685, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7235b72d04d5a467", "url": "https://translations.documentfoundation.org/api/units/99525685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.710553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition." ], "previous_source": "", "target": [ "" ], "id_hash": -2017124283082570331, "content_hash": -2017124283082570331, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id15226321619829\nhelp.text", "note": "CCW4A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6369, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/99295567/?format=api", "priority": 100, "id": 99525690, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6401bc26d70c85a5", "url": "https://translations.documentfoundation.org/api/units/99525690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.864334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Average_Range</emph> – optional. It is a range of values for calculating the mean." ], "previous_source": "", "target": [ "" ], "id_hash": -98089280091714849, "content_hash": -98089280091714849, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id174711913219765\nhelp.text", "note": "sDeiD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6370, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99295600/?format=api", "priority": 100, "id": 99525693, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7ea38451c7dc0adf", "url": "https://translations.documentfoundation.org/api/units/99525693/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.866781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If the <emph>Average_Range</emph> is not specified, <emph>Range</emph> is used for both, the calculation of the mean and the search according to the condition. If <emph>Average_Range</emph> is specified, the <emph>Range</emph> is used only for the condition test, while <emph>Average_Range</emph> is used for the average calculation." ], "previous_source": "", "target": [ "" ], "id_hash": 6961079785819230629, "content_hash": 6961079785819230629, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id45123108916423\nhelp.text", "note": "kCbPD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6371, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/99295623/?format=api", "priority": 100, "id": 99525699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e09ab92f0ee851a5", "url": "https://translations.documentfoundation.org/api/units/99525699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.868617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<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." ], "previous_source": "", "target": [ "" ], "id_hash": -3871217538132935641, "content_hash": -3871217538132935641, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id278275053653\nhelp.text", "note": "8v8Zv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6372, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/99295631/?format=api", "priority": 100, "id": 99525703, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4a46ac28df52fc27", "url": "https://translations.documentfoundation.org/api/units/99525703/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.870883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": 2753884199285647846, "content_hash": 2753884199285647846, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id229513120314273\nhelp.text", "note": "u7E4B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6373, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99295664/?format=api", "priority": 100, "id": 99525712, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a637c316aafb69e6", "url": "https://translations.documentfoundation.org/api/units/99525712/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.874708Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PERMEDIUSI(B2:B6;\"<35\")</item>" ], "id_hash": 7978380300095268972, "content_hash": 7978380300095268972, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519225446\nhelp.text", "note": "CqBc8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6374, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99295700/?format=api", "priority": 100, "id": 99525721, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=eeb8e69c9627286c", "url": "https://translations.documentfoundation.org/api/units/99525721/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.878856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculates the average for values of the range B2:B6 that are less than 35. Returns 19, because the second row does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -5817879000436386063, "content_hash": -5817879000436386063, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id11322891219251\nhelp.text", "note": "DFAzM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6375, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99295752/?format=api", "priority": 100, "id": 99525724, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2f42bddfa0c8d6f1", "url": "https://translations.documentfoundation.org/api/units/99525724/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.880771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": -8874281900013346317, "content_hash": -8874281900013346317, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id250920151922590\nhelp.text", "note": "qcBmp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6376, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99295779/?format=api", "priority": 100, "id": 99525731, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=04d837a14106a1f3", "url": "https://translations.documentfoundation.org/api/units/99525731/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.884792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculates the average for values of the same range that are less than the maximum value of this range. Returns 19, because the largest value (the second row) does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -2185649765359564296, "content_hash": -2185649765359564296, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id3813266131474\nhelp.text", "note": "DqwCP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6377, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99295875/?format=api", "priority": 100, "id": 99525736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=61ab031e5453c9f8", "url": "https://translations.documentfoundation.org/api/units/99525736/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.894390Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&SMALL(B2:B6;1))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PERMEDIUSI(B2:B6;\">\"&PEQUEÑU(B2:B6;1))</item>" ], "id_hash": 2972934131274319266, "content_hash": 2972934131274319266, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519230832\nhelp.text", "note": "oFhok", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6378, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296005/?format=api", "priority": 100, "id": 99525740, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a941fbd7533d85a2", "url": "https://translations.documentfoundation.org/api/units/99525740/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.896074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculates the average for values of the same range that are greater than the first smallest value of this range. Returns 25, because the first smallest value (the fourth row) does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -5935274051802001896, "content_hash": -5935274051802001896, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id243522732832394\nhelp.text", "note": "6MArD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6379, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/99296047/?format=api", "priority": 100, "id": 99525753, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2da1abb241bf8e18", "url": "https://translations.documentfoundation.org/api/units/99525753/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.900426Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Using the Average_Range" ], "previous_source": "", "target": [ "" ], "id_hash": -8799472871613920817, "content_hash": -8799472871613920817, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id2101254257133\nhelp.text", "note": "gxAAH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6380, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99296073/?format=api", "priority": 100, "id": 99525759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=05e1fe0b7cc409cf", "url": "https://translations.documentfoundation.org/api/units/99525759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.902315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\";C2:C6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": 1778804898648709030, "content_hash": 1778804898648709030, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519315584\nhelp.text", "note": "4oRE4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6381, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296094/?format=api", "priority": 100, "id": 99525763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=98af95a17cae57a6", "url": "https://translations.documentfoundation.org/api/units/99525763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.904014Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The function searches what values are less than 35 in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 145, because the second row does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": 1759337501942295314, "content_hash": 1759337501942295314, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id148222637631350\nhelp.text", "note": "AGDaT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6382, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/99296150/?format=api", "priority": 100, "id": 99525769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=986a6c22fb4b2b12", "url": "https://translations.documentfoundation.org/api/units/99525769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.906031Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&MIN(B2:B6);C2:C6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": 7990476685659041340, "content_hash": 7990476685659041340, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519315535\nhelp.text", "note": "crnMW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6383, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296192/?format=api", "priority": 100, "id": 99525774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=eee3e035d2bf6e3c", "url": "https://translations.documentfoundation.org/api/units/99525774/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.907499Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The function searches what values from the range B2:B6 are greater than the least value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 113.3, because the fourth row (where there is the least value in the range B2:B6) does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -4619371184654671204, "content_hash": -4619371184654671204, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2412836525208\nhelp.text", "note": "tiu8M", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6384, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/99296229/?format=api", "priority": 100, "id": 99525777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3fe4b261ccfba29c", "url": "https://translations.documentfoundation.org/api/units/99525777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.909309Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&LARGE(B2:B6;2);C2:C6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PERMEDIUSI(B2:B6;\"<\"&GRANDE(B2:B6;2);C2:C6)</item>" ], "id_hash": 4882444317738799733, "content_hash": 4882444317738799733, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519315547\nhelp.text", "note": "HAi7e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6385, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296257/?format=api", "priority": 100, "id": 99525781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c3c1ed3d1a721275", "url": "https://translations.documentfoundation.org/api/units/99525781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.910893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The function searches what values from the range B2:B6 are less than the second large value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 180, because only the fourth row participates in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": 6249045149062265141, "content_hash": 6249045149062265141, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id173931101529497\nhelp.text", "note": "T6LU3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6386, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99296269/?format=api", "priority": 100, "id": 99525787, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d6b91174473bf935", "url": "https://translations.documentfoundation.org/api/units/99525787/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.912759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Using regular expressions" ], "previous_source": "", "target": [ "" ], "id_hash": -6511700013815696116, "content_hash": -6511700013815696116, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id30054471316969\nhelp.text", "note": "Naigm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6387, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99296304/?format=api", "priority": 100, "id": 99525790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=25a1cb56809bf50c", "url": "https://translations.documentfoundation.org/api/units/99525790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.914196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen\";B2:B6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": 4799956928460139135, "content_hash": 4799956928460139135, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519360514\nhelp.text", "note": "rJEzm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6388, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296328/?format=api", "priority": 100, "id": 99525792, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c29cdf652a0aaa7f", "url": "https://translations.documentfoundation.org/api/units/99525792/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.915675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The function searches what cells from the range A2:A6 contain only the word “pen”, and calculates the average of corresponding values from the B2:B6 range. Returns 35, because only the second row participates in the calculation. The search is performed in the A2:A6 range, but the values are returned from the B2:B6 range." ], "previous_source": "", "target": [ "" ], "id_hash": -3763770976287304356, "content_hash": -3763770976287304356, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id14714860719948\nhelp.text", "note": "pFhEN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6389, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://translations.documentfoundation.org/api/units/99296345/?format=api", "priority": 100, "id": 99525797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4bc4663d0678555c", "url": "https://translations.documentfoundation.org/api/units/99525797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.917553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen.*\";B2:B6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": -8355210824882972227, "content_hash": -8355210824882972227, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id250920151936096\nhelp.text", "note": "g76se", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6390, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296358/?format=api", "priority": 100, "id": 99525801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0c0c5405c75a19bd", "url": "https://translations.documentfoundation.org/api/units/99525801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.919032Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The function searches what cells from the range A2:A6 begin with “pen” ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 27.5, because now also “pencil” satisfies the condition, and both, first and second rows participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -8996681651405615576, "content_hash": -8996681651405615576, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id26959239098104\nhelp.text", "note": "QX275", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6391, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/99296371/?format=api", "priority": 100, "id": 99525806, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=03255db45ab18e28", "url": "https://translations.documentfoundation.org/api/units/99525806/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.920785Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\".*book.*\";B2:B6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": -5422157762202301127, "content_hash": -5422157762202301127, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519361352\nhelp.text", "note": "L3vXX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6392, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296420/?format=api", "priority": 100, "id": 99525811, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=34c0a03e3bce0d39", "url": "https://translations.documentfoundation.org/api/units/99525811/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.922299Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The function searches what cells from the range A2:A6 contain “book” starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 18.5, because only third and fourth rows participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": 3000864586355334547, "content_hash": 3000864586355334547, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id227041304619482\nhelp.text", "note": "pSESy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6393, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/99296438/?format=api", "priority": 100, "id": 99525821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a9a5367128c25d93", "url": "https://translations.documentfoundation.org/api/units/99525821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.924160Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 5169793171942831839, "content_hash": 5169793171942831839, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id251309885188\nhelp.text", "note": "SGMWy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6394, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99296463/?format=api", "priority": 100, "id": 99525828, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c7becb7fc7e476df", "url": "https://translations.documentfoundation.org/api/units/99525828/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.929241Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "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 AVERAGEIF function." ], "previous_source": "", "target": [ "" ], "id_hash": -1938851708135682050, "content_hash": -1938851708135682050, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id177972099720424\nhelp.text", "note": "CnVcF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6395, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/99296494/?format=api", "priority": 100, "id": 99525834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6517d0a4d869cffe", "url": "https://translations.documentfoundation.org/api/units/99525834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.931630Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": 8721990768323701577, "content_hash": 8721990768323701577, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id134941261230060\nhelp.text", "note": "3i7KZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6396, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296513/?format=api", "priority": 100, "id": 99525841, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f90abc64882bab49", "url": "https://translations.documentfoundation.org/api/units/99525841/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.935246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The function searches what cells from the range A2:A6 contain a combination of characters specified in E2 starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. If E2 = book, the function returns 18.5." ], "previous_source": "", "target": [ "" ], "id_hash": -3962518927411692650, "content_hash": -3962518927411692650, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id172572288310247\nhelp.text", "note": "vTFAk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6397, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/99296540/?format=api", "priority": 100, "id": 99525847, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=49024e07a3dd3b96", "url": "https://translations.documentfoundation.org/api/units/99525847/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.937822Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&E2;C2:C6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": 7641095132828542682, "content_hash": 7641095132828542682, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id316901523627285\nhelp.text", "note": "2W6Qv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6398, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296573/?format=api", "priority": 100, "id": 99525851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ea0a9f89ff3626da", "url": "https://translations.documentfoundation.org/api/units/99525851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.940344Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "" ], "id_hash": -5537168185278317268, "content_hash": -5537168185278317268, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id302181300528607\nhelp.text", "note": "5Mfay", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6399, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/99296595/?format=api", "priority": 100, "id": 99525854, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=332806df66e43d2c", "url": "https://translations.documentfoundation.org/api/units/99525854/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.942527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF\">AVERAGEIF wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -468781967966032362, "content_hash": -468781967966032362, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id421677017213184\nhelp.text", "note": "ExJ9o", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6400, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99296613/?format=api", "priority": 100, "id": 99525855, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=797e8d48aa46ae16", "url": "https://translations.documentfoundation.org/api/units/99525855/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.944208Z" } ] }{ "count": 8352, "next": "