{"id":64,"date":"2013-10-07T12:19:47","date_gmt":"2013-10-07T11:19:47","guid":{"rendered":"http:\/\/tech-tipps.de\/?p=64"},"modified":"2013-10-07T12:19:47","modified_gmt":"2013-10-07T11:19:47","slug":"excel-felder-mit-wertausblenden","status":"publish","type":"post","link":"https:\/\/tech-tipps.de\/?p=64","title":{"rendered":"Excel-Felder mit &#8222;#WERT&#8220;ausblenden"},"content":{"rendered":"<div class=\"pntrst_main_before_after\"><\/div><p>Manchmal kommt es vor, dass in einer Excel-Zelle der Eintrag <strong>&#8222;#WERT<\/strong>&#8220; steht, weil die Funktion die dieses Zelle beinhaltet nicht ausgef\u00fchrt werden kann.<!--more--><\/p>\n<p>Um diesen Wert auszublenden verwendet man am besten eine Wenn()-Funktion in Verbindung mit der ISTFEHLER-Funktion:<\/p>\n<pre><span style=\"color: #008000;\">=WENN(ISTFEHLER(Deine_Formel);\"\";Deine_Formel)<\/span><\/pre>\n<p>Somit wir das Ergebnis der Formel (Deine_Formel) nur dann angezeigt, wenn sie keinen Fehler ergibt; sont wird eben &#8222;&#8220; (also nichts) angezeigt!\u00a0<img decoding=\"async\" title=\"Wink\" alt=\";)\" src=\"http:\/\/alt.tech-tipps.de\/images\/smilies\/icon_e_wink.gif\" \/><\/p>\n<div class=\"pntrst_main_before_after\"><\/div><div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/tech-tipps.de\/?p=64\" action=\"like\" colorscheme=\"light\" layout=\"standard\"  width=\"450px\" size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/tech-tipps.de\/?p=64\" data-type=\"button_count\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Manchmal kommt es vor, dass in einer Excel-Zelle der Eintrag &#8222;#WERT&#8220; steht, weil die Funktion die dieses Zelle beinhaltet nicht ausgef\u00fchrt werden kann.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[7,10],"tags":[63,101],"class_list":["post-64","post","type-post","status-publish","format-standard","hentry","category-microsoft-office","category-programmierung","tag-excel","tag-microsoft-office"],"_links":{"self":[{"href":"https:\/\/tech-tipps.de\/index.php?rest_route=\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech-tipps.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech-tipps.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech-tipps.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tech-tipps.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=64"}],"version-history":[{"count":0,"href":"https:\/\/tech-tipps.de\/index.php?rest_route=\/wp\/v2\/posts\/64\/revisions"}],"wp:attachment":[{"href":"https:\/\/tech-tipps.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech-tipps.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech-tipps.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}