{"id":3015,"date":"2023-11-17T23:31:48","date_gmt":"2023-11-17T23:31:48","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/"},"modified":"2023-12-03T13:05:36","modified_gmt":"2023-12-03T13:05:36","slug":"rechenzeichen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/","title":{"rendered":"Wie verwende ich arithmetische operatoren in excel?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1446215603\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>In Excel gibt es sechs Hauptarithmetikoperatoren, mit denen Sie Berechnungen durchf\u00fchren k\u00f6nnen.<\/p><ol type=\"1\"><li> Zusatz (+)<\/li><li> Subtraktion (-)<\/li><li> Multiplikation (*)<\/li><li> Abschnitt (\/)<\/li><li> Prozentsatz (%)<\/li><li> Exponentierung (^)<\/li><\/ol><p> Wie der Name schon sagt, kann jeder dieser Operatoren eine bestimmte Berechnung durchf\u00fchren. Und in diesem Tutorial lernen wir, wie man diese Operatoren verwendet. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84283\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-operateurs-arithmetiques.png\" sizes=\"auto, \" srcset=\"\" alt=\"Rechenzeichen\" width=\"782\" height=\"198\"><\/figure><\/div><p class=\"tip-box\"> In Excel erfordert die Durchf\u00fchrung einer Berechnung mit diesen Operatoren, dass Sie (=) verwenden, um die Formel zu starten. Und um diese Operatoren einzugeben, m\u00fcssen Sie die Tasten Ihrer Tastatur verwenden.<\/p><h2 class=\"wp-block-heading\"> 1. Addition (+)<\/h2><p> Mit dem Additionsoperator k\u00f6nnen Sie die Summe zweier oder mehrerer Werte berechnen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84284\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-operateur-daddition.png\" sizes=\"auto, \" srcset=\"\" alt=\"Additionsoperator\" width=\"451\" height=\"284\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=value1 + value2 =100 + 200<\/code><\/pre><p> Im obigen Beispiel haben wir mithilfe des (+) dazwischen eine Summe von 100 und 200 berechnet. Und auf die gleiche Weise k\u00f6nnen Sie auch Zellreferenzen verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84285\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-utilisant-loperateur-daddition.png\" sizes=\"auto, \" srcset=\"\" alt=\"sum-using-addition-operator\" width=\"554\" height=\"298\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 2. Subtraktion (-)<\/h2><p> Mit dem Subtraktionsoperator k\u00f6nnen Sie einen Wert von einem anderen subtrahieren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84286\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-operateur-de-soustraction.png\" sizes=\"auto, \" srcset=\"\" alt=\"Subtraktionsoperator\" width=\"538\" height=\"290\"><\/figure><\/div><p> Im obigen Beispiel haben Sie die Formel zum Minusieren des Werts von Zelle A1 um den Wert von Zelle A2. Sie k\u00f6nnen aber auch direkte Eingabewerte verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84287\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-soustraire-en-utilisant-loperateur-de-soustraction.png\" sizes=\"auto, \" srcset=\"\" alt=\"subtrahieren-mit-dem-subtraktionsoperator\" width=\"459\" height=\"292\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 3. Multiplikation (*)<\/h2><p> Um eine Multiplikation in Excel durchzuf\u00fchren, m\u00fcssen Sie den Sternchenoperator verwenden, den Sie mit der Taste auf Ihrer Tastatur eingeben k\u00f6nnen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84288\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-operateur-de-multiplication.png\" sizes=\"auto, \" srcset=\"\" alt=\"Multiplikationsoperator\" width=\"524\" height=\"324\"><\/figure><\/div><p> Und auch hier k\u00f6nnen Sie die Werte direkt in die Formel eingeben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84289\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-multiplier-en-utilisant-loperateur-de-multiplication.png\" sizes=\"auto, \" srcset=\"\" alt=\"Multiplizieren-mit-dem-Multiplikationsoperator\" width=\"493\" height=\"315\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=100*20<\/code><\/pre><h2 class=\"wp-block-heading\"> 4. Abschnitt (\/)<\/h2><p> Zum Teilen m\u00fcssen Sie den Schr\u00e4gstrich (\/) verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84290\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Operateur-8-divisions.png\" sizes=\"auto, \" srcset=\"\" alt=\"Divisionsbetreiber\" width=\"464\" height=\"299\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=Dividend\/Divisor<\/code><\/pre><p> Und weiter unten, wenn Sie die Werte direkt in die Formel eingeben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84291\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-diviser-en-utilisant-loperateur-de-division.png\" sizes=\"auto, \" srcset=\"\" alt=\"Division mit dem Divisionsoperator\" width=\"482\" height=\"306\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 5. Prozentsatz (%)<\/h2><p> Mit dem Prozentoperator k\u00f6nnen Sie einen numerischen Wert in einen Prozentsatz umwandeln. Wenn Sie eine Zahl in eine Zelle eingeben, geben Sie den Prozentoperator mit der Taste auf Ihrer Tastatur ein. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84292\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Operateur-10-.png\" sizes=\"auto, \" srcset=\"\" alt=\"Prozentoperator\" width=\"501\" height=\"318\"><\/figure><\/div><p> Und wenn Sie den Prozentsatz eines Werts berechnen m\u00f6chten, m\u00fcssen Sie daf\u00fcr den Sternchenoperator (Multiplikationsoperator) verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84293\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-pourcentage-a-laide-de-loperateur-de-pourcentage.png\" sizes=\"auto, \" srcset=\"\" alt=\"Prozentsatz-mit-Prozentsatz-Operator\" width=\"431\" height=\"326\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 6. Exponent (^)<\/h2><p> Damit kann man eine Zahl potenzieren. In Excel k\u00f6nnen Sie beispielsweise direkt einen Exponentenoperator eingeben und eine Zahl verwenden, um die Potenz zu erh\u00f6hen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84294\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Operateur-a-12-exposants.png\" sizes=\"auto, \" srcset=\"\" alt=\"Exponentenoperator\" width=\"459\" height=\"290\"><\/figure><\/div><p> Sie k\u00f6nnen damit <a href=\"https:\/\/exceladvisor.org\/de\/quadratwurzel\/\">Quadratwurzel<\/a> , <a href=\"https:\/\/exceladvisor.org\/de\/quadratzahl\/\">Quadrat<\/a> , Kubik usw. berechnen.<\/p>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3015","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Wie verwende ich arithmetische Operatoren in Excel?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie arithmetische Operatoren in Excel-Formeln verwenden. Lassen Sie uns das \u00fcberpr\u00fcfen...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Wie verwende ich arithmetische Operatoren in Excel?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie arithmetische Operatoren in Excel-Formeln verwenden. Lassen Sie uns das \u00fcberpr\u00fcfen...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:05:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-operateurs-arithmetiques.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/\",\"name\":\"\u25b7 Wie verwende ich arithmetische Operatoren in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-operateurs-arithmetiques.png\",\"datePublished\":\"2023-11-17T23:31:48+00:00\",\"dateModified\":\"2023-12-03T13:05:36+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie arithmetische Operatoren in Excel-Formeln verwenden. Lassen Sie uns das \u00fcberpr\u00fcfen...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-operateurs-arithmetiques.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-operateurs-arithmetiques.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich arithmetische operatoren in excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Wie verwende ich arithmetische Operatoren in Excel?","description":"In diesem Tutorial erfahren Sie, wie Sie arithmetische Operatoren in Excel-Formeln verwenden. Lassen Sie uns das \u00fcberpr\u00fcfen...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie verwende ich arithmetische Operatoren in Excel?","og_description":"In diesem Tutorial erfahren Sie, wie Sie arithmetische Operatoren in Excel-Formeln verwenden. Lassen Sie uns das \u00fcberpr\u00fcfen...","og_url":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:05:36+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-operateurs-arithmetiques.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/","url":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/","name":"\u25b7 Wie verwende ich arithmetische Operatoren in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-operateurs-arithmetiques.png","datePublished":"2023-11-17T23:31:48+00:00","dateModified":"2023-12-03T13:05:36+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie arithmetische Operatoren in Excel-Formeln verwenden. Lassen Sie uns das \u00fcberpr\u00fcfen...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/rechenzeichen\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-operateurs-arithmetiques.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-operateurs-arithmetiques.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/rechenzeichen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich arithmetische operatoren in excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3015"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3015\/revisions"}],"predecessor-version":[{"id":4225,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3015\/revisions\/4225"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}