Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/fr/units/?format=api&page=146
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/units/?format=api&page=147", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/units/?format=api&page=145", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/JIS\">JIS wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/JIS\">Page de wiki JIS</link>." ], "id_hash": 2039448152051293608, "content_hash": 2039448152051293608, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id801677015502335\nhelp.text", "note": "jqAPC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7251, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111171966/?format=api", "priority": 100, "id": 112281271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=9c4d9349f0d81da8", "url": "https://translations.documentfoundation.org/api/units/112281271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.559951Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "MAXIFS function" ], "previous_source": "", "target": [ "Fonction MAX.SI" ], "id_hash": -2449898255212847766, "content_hash": -2449898255212847766, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\ntit\nhelp.text", "note": "Cauxq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172032/?format=api", "priority": 100, "id": 112281272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=5e0036845a305d6a", "url": "https://translations.documentfoundation.org/api/units/112281272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.561291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<bookmark_value>MAXIFS function</bookmark_value> <bookmark_value>maximum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MAX.SI,fonction</bookmark_value><bookmark_value>Maximum;conditions de satisfaction</bookmark_value>" ], "id_hash": -3340120921755827711, "content_hash": -3340120921755827711, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nbm_id658066580665806\nhelp.text", "note": "8HdEW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172101/?format=api", "priority": 100, "id": 112281273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=51a581b7e7e4c201", "url": "https://translations.documentfoundation.org/api/units/112281273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.564495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable> function" ], "previous_source": "", "target": [ "Fonction <variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAX.SI</link></variable>" ], "id_hash": -1324032980930569323, "content_hash": -1324032980930569323, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id658866588665886\nhelp.text", "note": "kKHTn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7254, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172123/?format=api", "priority": 100, "id": 112281274, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=6da01704d4bb5b95", "url": "https://translations.documentfoundation.org/api/units/112281274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.566592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<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>" ], "previous_source": "", "target": [ "<ahelp hid=\".\"><variable id=\"maxifs_des\">Renvoie le maximum des valeurs des cellules d'une plage qui répondent à des critères multiples dans plusieurs plages.</variable></ahelp>" ], "id_hash": -7080741019089367299, "content_hash": -7080741019089367299, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id659756597565975\nhelp.text", "note": "DXshy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7255, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111172186/?format=api", "priority": 100, "id": 112281275, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=1dbc278efaa40efd", "url": "https://translations.documentfoundation.org/api/units/112281275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.567791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "MAX.SI(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "id_hash": -4696446051791201984, "content_hash": -4696446051791201984, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id11655988824213\nhelp.text", "note": "PKmRh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111172220/?format=api", "priority": 100, "id": 112281276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=3ed2df32e0331940", "url": "https://translations.documentfoundation.org/api/units/112281276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.569204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "<emph>plage_fonction</emph> – argument requis. C'est une plage de cellules, un nom d'une plage nommée ou une étiquette de colonne ou de ligne contenant les valeurs pour le calcul du maximum." ], "id_hash": 2724450032633823262, "content_hash": 2724450032633823262, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id59901690530236\nhelp.text", "note": "UrwgE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7257, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111172229/?format=api", "priority": 100, "id": 112281277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=a5cf30deb370c01e", "url": "https://translations.documentfoundation.org/api/units/112281277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.570489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Usage simple" ], "id_hash": -5218410125489394970, "content_hash": -5218410125489394970, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id193452436229521\nhelp.text", "note": "BUavo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172272/?format=api", "priority": 100, "id": 112281278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=37947ba3a1e72ae6", "url": "https://translations.documentfoundation.org/api/units/112281278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.571777Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MAX.SI(B2:B6;B2:B6;\"<35\")</item>" ], "id_hash": 3417653096642167929, "content_hash": 3417653096642167929, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id94321051525036\nhelp.text", "note": "8CyiM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172306/?format=api", "priority": 100, "id": 112281279, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=af6df16246dec479", "url": "https://translations.documentfoundation.org/api/units/112281279/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.572814Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "Calcule le maximum des valeurs de la plage B2:B6 qui sont supérieures ou égales à 20. Renvoie 35. La cinquième ligne ne satisfait pas le critère." ], "id_hash": -5025962791241282951, "content_hash": -5025962791241282951, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id28647227259438\nhelp.text", "note": "j2PKY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/111172330/?format=api", "priority": 100, "id": 112281280, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=3a40317855bb8a79", "url": "https://translations.documentfoundation.org/api/units/112281280/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.573971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MAX.SI(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" ], "id_hash": -4882410858544181930, "content_hash": -4882410858544181930, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id36952767622741\nhelp.text", "note": "c6yAQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172361/?format=api", "priority": 100, "id": 112281281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=3c3e313138f6cd56", "url": "https://translations.documentfoundation.org/api/units/112281281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.575284Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "Calcul le maximum des valeurs de la plage C2:C6 qui sont inférieures à 90 et correspondent au cellules de la plage B2:B6 avec des valeurs supérieures ou égales à 20. Renvoie 85, parce que la quatrième et la cinquième colonne ne correspondent pas à au moins un critère." ], "id_hash": -6133095175833196497, "content_hash": -6133095175833196497, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id189772445525114\nhelp.text", "note": "nGj4o", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7262, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/111172395/?format=api", "priority": 100, "id": 112281282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=2ae2de6e9ecce82f", "url": "https://translations.documentfoundation.org/api/units/112281282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.576471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Utilisation des expressions régulières et des fonctions imbriquées" ], "id_hash": 7310294577384814773, "content_hash": 7310294577384814773, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id30455222431067\nhelp.text", "note": "9Ayop", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111172431/?format=api", "priority": 100, "id": 112281283, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=e573622fc07c78b5", "url": "https://translations.documentfoundation.org/api/units/112281283/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.577916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MAX.SI(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -5335659071310958503, "content_hash": -5335659071310958503, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id307691022525348\nhelp.text", "note": "LNubZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172446/?format=api", "priority": 100, "id": 112281284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=35f3ee581beb7059", "url": "https://translations.documentfoundation.org/api/units/112281284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.578994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "Calcule le maximum des valeurs de la plage C2:C6 qui correspondent à toutes les valeurs de la plage B2:B6 à l'exception des minimum et maximum. Renvoie 190 parce que seule la quatrième ligne satisfait le critère." ], "id_hash": 2728227791290826569, "content_hash": 2728227791290826569, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id27619246864839\nhelp.text", "note": "CR2To", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/111172484/?format=api", "priority": 100, "id": 112281285, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=a5dc9cb8ae3cff49", "url": "https://translations.documentfoundation.org/api/units/112281285/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.580187Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MAX.SI(C2:C6;A2:A6;\"crayon.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" ], "id_hash": 158249065123773810, "content_hash": 158249065123773810, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id220502883332563\nhelp.text", "note": "xriFt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172524/?format=api", "priority": 100, "id": 112281286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=823236afb0bd7d72", "url": "https://translations.documentfoundation.org/api/units/112281286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:17.585467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "Calcule le maximum des valeurs de la plage C2:C6 qui correspondent à toutes les cellules de la plage A2:A6 finissant par \"livre\" et à toutes les cellules de la plage B2:B6 excepté son maximum. Renvoie 85 parce qu'uniquement la troisième ligne satisfait à tous les critères." ], "id_hash": -3964634836356299185, "content_hash": -3964634836356299185, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id15342189586295\nhelp.text", "note": "FQicN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7267, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111172542/?format=api", "priority": 100, "id": 112281287, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=48fac99f32d8064f", "url": "https://translations.documentfoundation.org/api/units/112281287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.483957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Référence à une cellule comme critère" ], "id_hash": 975754287595702701, "content_hash": 975754287595702701, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id8168283329426\nhelp.text", "note": "DwLDF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7268, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111172674/?format=api", "priority": 100, "id": 112281289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=8d8a935ad434c9ad", "url": "https://translations.documentfoundation.org/api/units/112281289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.490546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?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 the MAXIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Pour modifier facilement un critère, vous pouvez le spécifier dans une cellule séparée et utiliser une référence à cette cellule dans les conditions de la fonction MAX.SI. Par exemple, la fonction ci-dessus peut être écrite de la façon suivante :" ], "id_hash": 5584486400786439957, "content_hash": 5584486400786439957, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id50762995519951\nhelp.text", "note": "9BMGq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7269, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111172707/?format=api", "priority": 100, "id": 112281291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=cd8014cb2be01f15", "url": "https://translations.documentfoundation.org/api/units/112281291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.492265Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MAX.SI(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -8528842879162885577, "content_hash": -8528842879162885577, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id135761606425300\nhelp.text", "note": "gcYDr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172745/?format=api", "priority": 100, "id": 112281294, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=09a37696d2605a37", "url": "https://translations.documentfoundation.org/api/units/112281294/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.495277Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content." ], "previous_source": "", "target": [ "Si E2=\"crayon\", la fonction renvoie 65 parce que la référence à la cellule est substituée par son contenu." ], "id_hash": -722999157949055427, "content_hash": -722999157949055427, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id30574750215839\nhelp.text", "note": "wHPFq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111172771/?format=api", "priority": 100, "id": 112281297, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=75f76418b18a3e3d", "url": "https://translations.documentfoundation.org/api/units/112281297/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.497795Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MAXIFS\">MAXIFS wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MAXIFS\">Page de wiki MAX.SI</link>." ], "id_hash": -4761749996077925314, "content_hash": -4761749996077925314, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id401677015482616\nhelp.text", "note": "defwR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172786/?format=api", "priority": 100, "id": 112281299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=3deadd9b7e8ebc3e", "url": "https://translations.documentfoundation.org/api/units/112281299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.499346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "MINIFS function" ], "previous_source": "", "target": [ "Fonction MIN.SI" ], "id_hash": 7812476771991873893, "content_hash": 7812476771991873893, "location": "func_minifs.xhp", "context": "func_minifs.xhp\ntit\nhelp.text", "note": "zGQnQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172791/?format=api", "priority": 100, "id": 112281301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=ec6b7e3b5a90e965", "url": "https://translations.documentfoundation.org/api/units/112281301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.500606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MIN.SI,fonction</bookmark_value><bookmark_value>Minimum;conditions de satisfaction</bookmark_value>" ], "id_hash": -1093582569723425218, "content_hash": -1093582569723425218, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nbm_id658066580665806\nhelp.text", "note": "V8Fu7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172844/?format=api", "priority": 100, "id": 112281305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=70d2d07267138e3e", "url": "https://translations.documentfoundation.org/api/units/112281305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.503795Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable> function" ], "previous_source": "", "target": [ "Fonction <variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MIN.SI</link></variable>" ], "id_hash": -6433400122557603538, "content_hash": -6433400122557603538, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id658866588665886\nhelp.text", "note": "vnegG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172893/?format=api", "priority": 100, "id": 112281309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=26b7f8ac94ffe12e", "url": "https://translations.documentfoundation.org/api/units/112281309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.506140Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<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>" ], "previous_source": "", "target": [ "<ahelp hid=\".\"><variable id=\"minifs_des\">Renvoie le minimum des valeurs des cellules d'une plage qui répondent à des critères multiples dans plusieurs plages.</variable></ahelp>" ], "id_hash": -841053936576294524, "content_hash": -841053936576294524, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id659756597565975\nhelp.text", "note": "PmaDA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111172923/?format=api", "priority": 100, "id": 112281310, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=7453f9e6996d1184", "url": "https://translations.documentfoundation.org/api/units/112281310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.507458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "MIN.SI(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "id_hash": 8859664611740713808, "content_hash": 8859664611740713808, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id11655988824213\nhelp.text", "note": "yekSJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111172946/?format=api", "priority": 100, "id": 112281315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=faf3da061be78350", "url": "https://translations.documentfoundation.org/api/units/112281315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.511126Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "<emph>plage_fonction</emph> – argument requis. C'est une plage de cellules, un nom d'une plage nommée ou une étiquette de colonne ou de ligne contenant les valeurs pour le calcul du minimum." ], "id_hash": 284793519782481500, "content_hash": 284793519782481500, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id59901690530236\nhelp.text", "note": "Gf5P2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111172971/?format=api", "priority": 100, "id": 112281318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=83f3ca3284f7ce5c", "url": "https://translations.documentfoundation.org/api/units/112281318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.512416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Usage simple" ], "id_hash": -6681775116397015665, "content_hash": -6681775116397015665, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id193452436229521\nhelp.text", "note": "KkDwL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7279, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172976/?format=api", "priority": 100, "id": 112281320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=234590eee61c8d8f", "url": "https://translations.documentfoundation.org/api/units/112281320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.513840Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MIN.SI(B2:B6;B2:B6;\"<35\")</item>" ], "id_hash": 2823450842571719474, "content_hash": 2823450842571719474, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id94321051525036\nhelp.text", "note": "TGRCF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172977/?format=api", "priority": 100, "id": 112281322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=a72ee9950043c332", "url": "https://translations.documentfoundation.org/api/units/112281322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.514932Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17." ], "previous_source": "", "target": [ "Calcule le minimum des valeurs de la plage B2:B6 qui sont plus petites ou égales à 20. Renvoie 17." ], "id_hash": 8689637701657927848, "content_hash": 8689637701657927848, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id28647227259438\nhelp.text", "note": "eRNbh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111172978/?format=api", "priority": 100, "id": 112281323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=f897cb733229a0a8", "url": "https://translations.documentfoundation.org/api/units/112281323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.516150Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MIN.SI(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" ], "id_hash": 8274293814976130446, "content_hash": 8274293814976130446, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id36952767622741\nhelp.text", "note": "zufoC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172979/?format=api", "priority": 100, "id": 112281326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=f2d43262b8dd2d8e", "url": "https://translations.documentfoundation.org/api/units/112281326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.520049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "Calcule le minimum des valeurs de la plage C2:C6 qui sont plus petites que 90 et correspondent aux cellules de la plage B2:B6 ayant des valeurs plus grandes ou égales à 20. Renvoie 190." ], "id_hash": 8479070192479725407, "content_hash": 8479070192479725407, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id189772445525114\nhelp.text", "note": "iCk4M", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/111172980/?format=api", "priority": 100, "id": 112281328, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=f5abb56a805b675f", "url": "https://translations.documentfoundation.org/api/units/112281328/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.523103Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Utilisation des expressions régulières et des fonctions imbriquées" ], "id_hash": 3935808270846501747, "content_hash": 3935808270846501747, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id30455222431067\nhelp.text", "note": "iqFXq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111173071/?format=api", "priority": 100, "id": 112281330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=b69eccc4ffd9a373", "url": "https://translations.documentfoundation.org/api/units/112281330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.528704Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MIN.SI(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 5059510094262033099, "content_hash": 5059510094262033099, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id307691022525348\nhelp.text", "note": "CBaMz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7285, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173119/?format=api", "priority": 100, "id": 112281332, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=c636fd9fd1fddacb", "url": "https://translations.documentfoundation.org/api/units/112281332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.530445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 65." ], "previous_source": "", "target": [ "Calcule le minimum des valeurs de la plage C2:C6 qui correspondent à toutes les valeurs de la plage B2:B6 à l'exception des minimum et maximum. Renvoie 65." ], "id_hash": -4181087204647800947, "content_hash": -4181087204647800947, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id27619246864839\nhelp.text", "note": "Dp4Sx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7286, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111173174/?format=api", "priority": 100, "id": 112281335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=45f9cb56f8096f8d", "url": "https://translations.documentfoundation.org/api/units/112281335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.534753Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\">\"&MIN(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MIN.SI(C2:C6;A2:A6;\".*livre\";B2:B6;\"<=\"&MIN(B2:B6))</item>" ], "id_hash": 2524283094541941754, "content_hash": 2524283094541941754, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id220502883332563\nhelp.text", "note": "7S443", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7287, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173196/?format=api", "priority": 100, "id": 112281337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=a3080e19aab23bfa", "url": "https://translations.documentfoundation.org/api/units/112281337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.537305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with \"book\" and to all cells of the B2:B6 range except its minimum. Returns 190." ], "previous_source": "", "target": [ "Calcule le minimum des valeurs de la plage C2:C6 qui correspondent à toutes les cellules de la plage A2:A6 finissant par \"livre\" et à toutes les cellules de la plage B2:B6 excepté son minimum. Renvoie 190." ], "id_hash": 1511293224466033220, "content_hash": 1511293224466033220, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id15342189586295\nhelp.text", "note": "gNhzJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111173197/?format=api", "priority": 100, "id": 112281339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=94f9312e33c0aa44", "url": "https://translations.documentfoundation.org/api/units/112281339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.538617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Référence à une cellule comme critère" ], "id_hash": 562770679139324109, "content_hash": 562770679139324109, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id8168283329426\nhelp.text", "note": "uz4wr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111173198/?format=api", "priority": 100, "id": 112281343, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=87cf5cf3741ad0cd", "url": "https://translations.documentfoundation.org/api/units/112281343/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.542719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?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 the MINIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Pour modifier facilement un critère, vous pouvez le spécifier dans une cellule séparée et utiliser une référence à cette cellule dans les conditions de la fonction MIN.SI. Par exemple, la fonction ci-dessus peut être écrite de la façon suivante :" ], "id_hash": -6961485744941843957, "content_hash": -6961485744941843957, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id50762995519951\nhelp.text", "note": "27hDw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7290, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111173199/?format=api", "priority": 100, "id": 112281346, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=1f63d59937cbba0b", "url": "https://translations.documentfoundation.org/api/units/112281346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.544410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MIN.SI(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -4878672984956085105, "content_hash": -4878672984956085105, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id135761606425300\nhelp.text", "note": "EcoDf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7291, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173200/?format=api", "priority": 100, "id": 112281348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=3c4b78c4bc65dc8f", "url": "https://translations.documentfoundation.org/api/units/112281348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.546389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." ], "previous_source": "", "target": [ "Si E2=\"livre\", la fonction renvoie 180 parce que la référence à la cellule est substituée par son contenu." ], "id_hash": -7124754506057414550, "content_hash": -7124754506057414550, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id30574750215839\nhelp.text", "note": "cxmqK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111173201/?format=api", "priority": 100, "id": 112281351, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=1d1fc9867a95886a", "url": "https://translations.documentfoundation.org/api/units/112281351/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.548179Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS\">MINIFS wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS\">Page de wiki MIN.SI</link>." ], "id_hash": -4642634868378127656, "content_hash": -4642634868378127656, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id941677015454359\nhelp.text", "note": "zBVgq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7293, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111173202/?format=api", "priority": 100, "id": 112281352, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=3f920c2f587ab2d8", "url": "https://translations.documentfoundation.org/api/units/112281352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.549804Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "MINUTE" ], "previous_source": "", "target": [ "MINUTE" ], "id_hash": 6583649393914450800, "content_hash": 6583649393914450800, "location": "func_minute.xhp", "context": "func_minute.xhp\ntit\nhelp.text", "note": "SAxB8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111173225/?format=api", "priority": 100, "id": 112281355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=db5dd23df9fc9370", "url": "https://translations.documentfoundation.org/api/units/112281355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.553864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<bookmark_value>MINUTE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MINUTE, fonction</bookmark_value>" ], "id_hash": 6674063580216568736, "content_hash": 6674063580216568736, "location": "func_minute.xhp", "context": "func_minute.xhp\nbm_id3149803\nhelp.text", "note": "7cQwC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173282/?format=api", "priority": 100, "id": 112281356, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=dc9f09772b2e2ba0", "url": "https://translations.documentfoundation.org/api/units/112281356/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.555295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<variable id=\"minute\"><link href=\"text/scalc/01/func_minute.xhp\">MINUTE</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"minute\"><link href=\"text/scalc/01/func_minute.xhp\">MINUTE</link></variable>" ], "id_hash": -6278203477099020855, "content_hash": -6278203477099020855, "location": "func_minute.xhp", "context": "func_minute.xhp\nhd_id3149803\nhelp.text", "note": "aFbYG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7296, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111173324/?format=api", "priority": 100, "id": 112281358, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=28df57336fe3fdc9", "url": "https://translations.documentfoundation.org/api/units/112281358/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.560420Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MINUTE\">Calculates the minute for an internal time value.</ahelp> The minute is returned as a number between 0 and 59." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_MINUTE\">Calcule la minute correspondant à la valeur horaire interne</ahelp> La minute est renvoyée sous forme de nombre compris entre 0 et 59." ], "id_hash": 3800930512976531485, "content_hash": 3800930512976531485, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148988\nhelp.text", "note": "kGsA6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111173366/?format=api", "priority": 100, "id": 112281360, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=b4bf9e29d1e8d01d", "url": "https://translations.documentfoundation.org/api/units/112281360/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.561982Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "MINUTE(Number)" ], "previous_source": "", "target": [ "MINUTE(nombre)" ], "id_hash": -2617622125915151773, "content_hash": -2617622125915151773, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148660\nhelp.text", "note": "LeQE8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111173367/?format=api", "priority": 100, "id": 112281363, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=5bac568b949fe263", "url": "https://translations.documentfoundation.org/api/units/112281363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.567574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<emph>Number</emph>, as a time value, is a decimal number where the number of the minute is to be returned." ], "previous_source": "", "target": [ "<emph>nombre</emph>, comme valeur de temps, est un nombre décimal, pour lequel la minute est renvoyée." ], "id_hash": 316469162102282401, "content_hash": 316469162102282401, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3154611\nhelp.text", "note": "8eGft", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111173393/?format=api", "priority": 100, "id": 112281365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=84645306b578d8a1", "url": "https://translations.documentfoundation.org/api/units/112281365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.569226Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/fr/?format=api", "source": [ "<item type=\"input\">=MINUTE(8.999)</item> returns 58" ], "previous_source": "", "target": [ "<item type=\"input\">=MINUTE(8,999)</item> renvoie 58" ], "id_hash": -4031844472942077863, "content_hash": -4031844472942077863, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148463\nhelp.text", "note": "L77op", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111173418/?format=api", "priority": 100, "id": 112281367, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/fr/?checksum=480c02d040aa5859", "url": "https://translations.documentfoundation.org/api/units/112281367/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:16:18.570509Z" } ] }