{"id":6267,"date":"2024-10-16T11:25:23","date_gmt":"2024-10-16T09:25:23","guid":{"rendered":"http:\/\/www.ramses.de\/?p=6267"},"modified":"2024-10-16T11:25:35","modified_gmt":"2024-10-16T09:25:35","slug":"excel-funktionen-arbeitstag-2-3-3","status":"publish","type":"post","link":"https:\/\/www.ramses.de\/?p=6267","title":{"rendered":"Excel Funktionen &#8211; WENN"},"content":{"rendered":"<h2>WENNS [IFS]<\/h2>\n<p>Die Funktion WENNS geh\u00f6rt in die Gruppe der logischen Funktionen.<\/p>\n<p>Die Funktion kann bis zu 127 Bedingungen pr\u00fcfen und gibt den Wert zur\u00fcck der f\u00fcr den Fall WAHR vorgesehen ist. Sie ist eine Alternative zur Schachtelung von Wenn Funktionen<\/p>\n<p>=WENNS(PR\u00dcFUNG1;DANN1;PR\u00dcFUNG2;DANN2)<\/p>\n<p><a href=\"https:\/\/www.ramses.de\/wp-content\/uploads\/WENNS.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6268\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/WENNS.jpg\" alt=\"\" width=\"497\" height=\"152\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/WENNS.jpg 497w, https:\/\/www.ramses.de\/wp-content\/uploads\/WENNS-300x92.jpg 300w\" sizes=\"auto, (max-width: 497px) 100vw, 497px\" \/><\/a><\/p>\n<p>In diesem Fall soll angezeigt werden, um welchen Wochentag es sich handelt.<\/p>\n<div class=\"ewa-rteLine\">=WENNS(<span class=\"formula-highlight-1\">E2<\/span>=1;&#8220;Sonntag&#8220;;<\/div>\n<div class=\"ewa-rteLine\"><span class=\"formula-highlight-1\">E2<\/span>=2;&#8220;Montag&#8220;;<\/div>\n<div class=\"ewa-rteLine\"><span class=\"formula-highlight-1\">E2<\/span>=3;&#8220;Dienstag&#8220;;<\/div>\n<div class=\"ewa-rteLine\"><span class=\"formula-highlight-1\">E2<\/span>=4;&#8220;Mittwoch&#8220;;<\/div>\n<div class=\"ewa-rteLine\"><span class=\"formula-highlight-1\">E2<\/span>=5;&#8220;Donnerstag&#8220;;<\/div>\n<div class=\"ewa-rteLine\"><span class=\"formula-highlight-1\">E2<\/span>=6;&#8220;Freitag&#8220;;<\/div>\n<div class=\"ewa-rteLine\"><span class=\"formula-highlight-1\">E2<\/span>=7;&#8220;Samstag&#8220;)<\/div>\n<h3><strong>Verwandte Funktionen <\/strong><\/h3>\n<ul>\n<li><a href=\"https:\/\/www.ramses.de\/?p=4999\">UND<\/a><\/li>\n<li><a href=\"https:\/\/www.ramses.de\/?p=5004\">ODER<\/a><\/li>\n<li><a href=\"https:\/\/www.ramses.de\/?p=5016\">WENN<\/a><\/li>\n<li><a href=\"https:\/\/www.ramses.de\/?p=5110\">WENNFEHLER<\/a><\/li>\n<\/ul>\n<h3>\u00a0Beispieldateien<\/h3>\n<ul>\n<li>Keine Beispieldatei vorhanden<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>WENNS [IFS] Die Funktion WENNS geh\u00f6rt in die Gruppe der logischen Funktionen. Die Funktion kann bis zu 127 Bedingungen pr\u00fcfen und gibt den Wert zur\u00fcck &#8230; <a title=\"Excel Funktionen &#8211; WENN\" class=\"read-more\" href=\"https:\/\/www.ramses.de\/?p=6267\" aria-label=\"Mehr Informationen \u00fcber Excel Funktionen &#8211; WENN\">Weiterlesen &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[101,90],"class_list":["post-6267","post","type-post","status-publish","format-standard","hentry","category-excel","tag-excel","tag-funktion"],"_links":{"self":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/6267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6267"}],"version-history":[{"count":2,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/6267\/revisions"}],"predecessor-version":[{"id":6270,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/6267\/revisions\/6270"}],"wp:attachment":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}