{"id":1204,"date":"2015-01-05T15:07:06","date_gmt":"2015-01-05T14:07:06","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=1204"},"modified":"2022-08-15T15:24:09","modified_gmt":"2022-08-15T13:24:09","slug":"excel-aerer-les-formules-de-calcul","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2015\/01\/excel-aerer-les-formules-de-calcul\/","title":{"rendered":"Excel &#8211; A\u00e9rer les formules de calcul"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous avez ouvert un tableau Excel et certaines formules de calcul vous semblent difficile \u00e0 d\u00e9chiffrer (surtout si elles ont \u00e9t\u00e9 faites par quelqu&rsquo;un d&rsquo;autre). Vous aimeriez simplement rendre ces formules plus lisibles en s\u00e9parant les \u00e9l\u00e9ments qui les constituent.<\/p>\n<h4><strong>Solution : a\u00e9rez vos formules<br \/>\n<\/strong><\/h4>\n<ul>\n<li>Tout d&rsquo;abord, agrandissez la zone d\u00e9di\u00e9e \u00e0 la barre de formule (n\u00e9cessaire seulement sur Mac)<\/li>\n<li>Placez votre curseur dans la formule \u00e0 l&rsquo;endroit souhait\u00e9<\/li>\n<li>Appuyez sur les touches Cmd + Ctrl + Enter (Mac) ou sur les touches Alt + Enter (PC); vous obtenez alors un saut de ligne<\/li>\n<li>Poursuivez ainsi en ins\u00e9rant des\u00a0saut de ligne aux endroits souhait\u00e9s<\/li>\n<li>Ins\u00e9rez\u00a0\u00e9ventuellement des espaces blancs pour s\u00e9parer les parenth\u00e8ses :<\/li>\n<\/ul>\n<p>La formule :<\/p>\n<p>=SI(SOMME(D23-C23;F23-E23;H23-G23)=0;\u201d\u201d;SOMME(D23-C23;F23-E23;H23-G23))<\/p>\n<p>devient :<\/p>\n<p>=SI(<br \/>\nSOMME(D23-C23;F23-E23;H23-G23)<br \/>\n=0;\u201d\u201d;<br \/>\nSOMME(D23-C23;F23-E23;H23-G23)\u00a0\u00a0 )<\/p>\n<p><em>Les sauts de ligne et les espaces blancs sont sans effets secondaires ind\u00e9sirables sur le r\u00e9sultat de la formule.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez ouvert un tableau Excel et certaines formules de calcul vous semblent difficile \u00e0 d\u00e9chiffrer (surtout si elles ont \u00e9t\u00e9 faites par quelqu&rsquo;un d&rsquo;autre). Vous aimeriez&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3789,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[43],"class_list":{"0":"post-1204","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-fonction"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=1204"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1204\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3789"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=1204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=1204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=1204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}