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/de/units/?format=api&page=146
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=147", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=145", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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/de\">Wikiseite zu 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": 112010874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9c4d9349f0d81da8", "url": "https://translations.documentfoundation.org/api/units/112010874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.493503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "MAXIFS function" ], "previous_source": "", "target": [ "Funktion MAXWENNS" ], "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": 112010877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5e0036845a305d6a", "url": "https://translations.documentfoundation.org/api/units/112010877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.495439Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>MAXIFS function</bookmark_value> <bookmark_value>maximum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MAXWENNS (Funktion)</bookmark_value><bookmark_value>Maximum; hinreichende Bedingungen</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": 112010879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=51a581b7e7e4c201", "url": "https://translations.documentfoundation.org/api/units/112010879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.497012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable> function" ], "previous_source": "", "target": [ "Funktion <variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXWENNS</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": 112010884, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6da01704d4bb5b95", "url": "https://translations.documentfoundation.org/api/units/112010884/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.499145Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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\">Gibt das Maximum der Werte der Zellen in einem Bereich zurück, die mehrere Bedingungen in mehreren Bereichen erfüllen.</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": 112010888, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=1dbc278efaa40efd", "url": "https://translations.documentfoundation.org/api/units/112010888/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.502381Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "MAXWENNS(<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": 112010892, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3ed2df32e0331940", "url": "https://translations.documentfoundation.org/api/units/112010892/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.504601Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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>Funktionsbereich</emph> – erforderliches Argument. Ist ein Zellbereich, der Name eines benannten Bereichs oder eine Spalten-/Zeilenüberschrift, der/die Werte enthält, für die das Maximum berechnet wird." ], "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": 112010896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a5cf30deb370c01e", "url": "https://translations.documentfoundation.org/api/units/112010896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.506480Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Einfache Benutzung" ], "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": 112010899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=37947ba3a1e72ae6", "url": "https://translations.documentfoundation.org/api/units/112010899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.509029Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MAXWENNS(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": 112010902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=af6df16246dec479", "url": "https://translations.documentfoundation.org/api/units/112010902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.510896Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Berechnet das Maximum der Werte im Bereich B2:B6, die größer oder gleich 20 sind. Ergibt 35, da die fünfte Zeile die Bedingung nicht erfüllt." ], "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": 112010908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3a40317855bb8a79", "url": "https://translations.documentfoundation.org/api/units/112010908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.515401Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MAXWENNS(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": 112010912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3c3e313138f6cd56", "url": "https://translations.documentfoundation.org/api/units/112010912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.519640Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Berechnet das Maximum der Werte im Bereich C2:C6, die kleiner als 90 und deren entsprechende Zellwerte im Bereich B2:B6 größer oder gleich 20 sind. Gibt 85 zurück, da die vierte und fünfte Zeile je mindestens eine Bedingung nicht erfüllen." ], "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": 112010917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=2ae2de6e9ecce82f", "url": "https://translations.documentfoundation.org/api/units/112010917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.522576Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Verwendung mit regulären Ausdrücken und verschachtelten Funktionen" ], "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": 112010918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e573622fc07c78b5", "url": "https://translations.documentfoundation.org/api/units/112010918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.532317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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\">=MAXWENNS(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": 112010922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=35f3ee581beb7059", "url": "https://translations.documentfoundation.org/api/units/112010922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.535410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Berechnet das Maximum der Werte im Bereich C2:C6, die allen Werten im Bereich B2:B6, außer dem Minimum und dem Maximum, entsprechen. Ergibt 190, da nur die vierte Zeile die Bedingungen erfüllt." ], "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": 112010927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a5dc9cb8ae3cff49", "url": "https://translations.documentfoundation.org/api/units/112010927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.539691Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MAXWENNS(C2:C6;A2:A6;\".*stift\";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": 112010930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=823236afb0bd7d72", "url": "https://translations.documentfoundation.org/api/units/112010930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.541643Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Berechnet das Maximum der Werte des Bereichs C2:C6, deren zugehörige Zellen des Bereichs A2:A6 auf \"stift\" enden und mit Ausnahme der Zellen des Bereichs B2:B6, die deren Maximum enthalten. Gibt 85 zurück, da nur die dritte Zeile alle Bedingungen erfüllt." ], "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": 112010931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=48fac99f32d8064f", "url": "https://translations.documentfoundation.org/api/units/112010931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.543459Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Bezüge zu einer Zelle mit einer Bedingung" ], "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": 112010934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=8d8a935ad434c9ad", "url": "https://translations.documentfoundation.org/api/units/112010934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.545121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Falls Sie eine Bedingung einfach ändern möchten, können Sie diese in einer eigenen Zelle festlegen und einen Bezug zu dieser Zelle in der Bedingung der Funktion MAXWENNS verwenden. Beispielsweise kann die oben stehende Formel wie folgt umgeschrieben werden:" ], "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": 112010936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=cd8014cb2be01f15", "url": "https://translations.documentfoundation.org/api/units/112010936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.546288Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MAXWENNS(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": 112010939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=09a37696d2605a37", "url": "https://translations.documentfoundation.org/api/units/112010939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.547636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content." ], "previous_source": "", "target": [ "Wenn E2 = \"stift\" ist, ergibt die Funktion 65, da der Bezug zur Zelle derem Inhalt entspricht." ], "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": 112010941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=75f76418b18a3e3d", "url": "https://translations.documentfoundation.org/api/units/112010941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.549203Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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\">Wikiseite zu MAXWENNS</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": 112010946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3deadd9b7e8ebc3e", "url": "https://translations.documentfoundation.org/api/units/112010946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.551570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "MINIFS function" ], "previous_source": "", "target": [ "Funktion MINWENNS" ], "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": 112010955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ec6b7e3b5a90e965", "url": "https://translations.documentfoundation.org/api/units/112010955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.558045Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MINWENNS (Funktion)</bookmark_value> <bookmark_value>Minimum; hinreichende Bedingungen</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": 112010958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=70d2d07267138e3e", "url": "https://translations.documentfoundation.org/api/units/112010958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.560353Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable> function" ], "previous_source": "", "target": [ "Funktion <variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINWENNS</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": 112010966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=26b7f8ac94ffe12e", "url": "https://translations.documentfoundation.org/api/units/112010966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.569190Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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\">Gibt das Minimum der Werte der Zellen in einem Bereich zurück, die mehrere Bedingungen in mehreren Bereichen erfüllen.</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": 112010973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7453f9e6996d1184", "url": "https://translations.documentfoundation.org/api/units/112010973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.575737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "MINWENNS(<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": 112010977, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=faf3da061be78350", "url": "https://translations.documentfoundation.org/api/units/112010977/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.578685Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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>Funktionsbereich</emph> – erforderliches Argument. Ist ein Zellbereich, der Name eines benannten Bereichs oder eine Spalten-/Zeilenüberschrift, der/die Werte enthält, für die das Minimum berechnet wird." ], "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": 112010980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=83f3ca3284f7ce5c", "url": "https://translations.documentfoundation.org/api/units/112010980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.581862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Einfache Benutzung" ], "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": 112010983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=234590eee61c8d8f", "url": "https://translations.documentfoundation.org/api/units/112010983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.585416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MINWENNS(B2:B6;B2:B6;\"<20\")</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": 112010985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a72ee9950043c332", "url": "https://translations.documentfoundation.org/api/units/112010985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.587540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Berechnet das Minimum der Werte des Bereichs B2:B6, welche kleiner 20 sind. Gibt 17 zurück." ], "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": 112010987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f897cb733229a0a8", "url": "https://translations.documentfoundation.org/api/units/112010987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.590612Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MINWENNS(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": 112010989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f2d43262b8dd2d8e", "url": "https://translations.documentfoundation.org/api/units/112010989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.593497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Berechnet das Minimum der Werte des Bereichs C2:C6, welche größer als 90 sind und für deren entsprechende Zellen des Bereichs B2:B6 die Werte größer oder gleich 20 sind. Gibt 190 zurück." ], "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": 112010992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f5abb56a805b675f", "url": "https://translations.documentfoundation.org/api/units/112010992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.595979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Verwendung mit regulären Ausdrücken und verschachtelten Funktionen" ], "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": 112010994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=b69eccc4ffd9a373", "url": "https://translations.documentfoundation.org/api/units/112010994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.599112Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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\">=MINWENNS(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": 112010997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c636fd9fd1fddacb", "url": "https://translations.documentfoundation.org/api/units/112010997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.601784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Berechnet das Minimum der Werte des Bereichs C2:C6, die allen Werten des Bereichs B2:B6 mit Ausnahme des Minimums und Maximums entsprechen. Gibt 65 zurück." ], "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": 112010999, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=45f9cb56f8096f8d", "url": "https://translations.documentfoundation.org/api/units/112010999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.603666Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\">\"&MIN(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MINWENNS(C2:C6;A2:A6;\".*buch\";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": 112011002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a3080e19aab23bfa", "url": "https://translations.documentfoundation.org/api/units/112011002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.606332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Berechnet das Minimum der Werte des Bereichs C2:C6, die allen Zellen des Bereichs A2:A6 mit der Endung \"buch\" und allen Zellen des Bereichs B2:B6 mit Ausnahme des Minimums entsprechen. Gibt 190 zurück." ], "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": 112011004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=94f9312e33c0aa44", "url": "https://translations.documentfoundation.org/api/units/112011004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.609130Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Bezüge zu einer Zelle mit einer Bedingung" ], "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": 112011006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=87cf5cf3741ad0cd", "url": "https://translations.documentfoundation.org/api/units/112011006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.611514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": [ "Falls Sie eine Bedingung einfach ändern möchten, können Sie diese in einer eigenen Zelle festlegen und einen Bezug zu dieser Zelle in der Bedingung der Funktion MINWENNS verwenden. Beispielsweise kann die oben stehende Formel wie folgt umgeschrieben werden:" ], "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": 112011008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=1f63d59937cbba0b", "url": "https://translations.documentfoundation.org/api/units/112011008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.613599Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MINWENNS(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": 112011010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3c4b78c4bc65dc8f", "url": "https://translations.documentfoundation.org/api/units/112011010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.616395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." ], "previous_source": "", "target": [ "Wenn E2 = \"buch\" ist, ergibt die Funktion 180, da der Bezug zur Zelle derem Inhalt entspricht." ], "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": 112011013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=1d1fc9867a95886a", "url": "https://translations.documentfoundation.org/api/units/112011013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.619872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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\">Wikiseite zu MINWENNS</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": 112011014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3f920c2f587ab2d8", "url": "https://translations.documentfoundation.org/api/units/112011014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.622069Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": 112011016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=db5dd23df9fc9370", "url": "https://translations.documentfoundation.org/api/units/112011016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.626024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>MINUTE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MINUTE (Funktion)</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": 112011017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=dc9f09772b2e2ba0", "url": "https://translations.documentfoundation.org/api/units/112011017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.630830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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": 112011020, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=28df57336fe3fdc9", "url": "https://translations.documentfoundation.org/api/units/112011020/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.635140Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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\">Berechnet zu dem internen Zeitwert die Minute.</ahelp> Die Minute wird als Zahl zwischen 0 und 59 wiedergegeben." ], "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": 112011023, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=b4bf9e29d1e8d01d", "url": "https://translations.documentfoundation.org/api/units/112011023/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.638209Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "MINUTE(Number)" ], "previous_source": "", "target": [ "MINUTE(Zahl)" ], "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": 112011026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5bac568b949fe263", "url": "https://translations.documentfoundation.org/api/units/112011026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.643240Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?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>Zahl</emph> ist als Zeitwert eine Dezimalzahl, für welche die Zahl der Minute zu ermitteln ist." ], "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": 112011028, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=84645306b578d8a1", "url": "https://translations.documentfoundation.org/api/units/112011028/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.645595Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=MINUTE(8.999)</item> returns 58" ], "previous_source": "", "target": [ "<item type=\"input\">=MINUTE(8,999)</item> ergibt 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": 112011030, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=480c02d040aa5859", "url": "https://translations.documentfoundation.org/api/units/112011030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:57.648367Z" } ] }