{"id":1038,"date":"2014-12-03T11:01:42","date_gmt":"2014-12-03T10:01:42","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=1038"},"modified":"2022-08-15T15:36:46","modified_gmt":"2022-08-15T13:36:46","slug":"excel-utiliser-la-fonction-siestvide","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/12\/excel-utiliser-la-fonction-siestvide\/","title":{"rendered":"Excel &#8211; Utiliser la fonction SI(ESTVIDE)"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous disposez d&rsquo;un fichier Excel contenant par exemple des adresses de contacts internes (facult\u00e9s, services, unit\u00e9s&#8230;). Dans votre tableau, une colonne est pr\u00e9vue pour contenir les URL des contacts (colonne B). Or, pour certains d&rsquo;entre eux, les URL sont inconnues et vous aimeriez, dans ce cas, qu&rsquo;une URL \u00ab\u00a0g\u00e9n\u00e9rique\u00a0\u00bb soit utilis\u00e9e (par ex. www.unil.ch). Il faut donc ins\u00e9rer dans une nouvelle colonne (colonne C), une fonction qui compl\u00e8terait automatiquement les URL inexistantes par l&rsquo;URL g\u00e9n\u00e9rique laquelle a \u00e9t\u00e9 saisie en A1.<\/p>\n<h4><strong>Solution : utiliser la fonction SI(ESTVIDE)<\/strong><\/h4>\n<ul>\n<li>Cr\u00e9ez une colonne suppl\u00e9mentaire par ex. URL_calcul\u00e9e<\/li>\n<li>En C3, saisissez la fonction suivante : =SI(ESTVIDE(B3);T($A$1);T(B3)) autrement dit si B3 est vide, alors ins\u00e9rer le texte se trouvant en A1, sinon ins\u00e9rer le texte se trouvant en B3. Dans la formule de calcul, remarquez que j&rsquo;ai transform\u00e9 A1 en une adresse absolue (gr\u00e2ce aux touches fn + F4 permettant d&rsquo;ins\u00e9rer des $)<\/li>\n<li>Recopiez cette formule de calcul sur les autres cellules de la colonne C<\/li>\n<\/ul>\n<p><img alt=\"\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3794\" src=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/12\/Capture-de\u0301cran-2022-08-15-a\u0300-15.33.56.png\" alt=\"\" width=\"841\" height=\"279\" srcset=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/12\/Capture-de\u0301cran-2022-08-15-a\u0300-15.33.56.png 841w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/12\/Capture-de\u0301cran-2022-08-15-a\u0300-15.33.56-300x100.png 300w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/12\/Capture-de\u0301cran-2022-08-15-a\u0300-15.33.56-768x255.png 768w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/12\/Capture-de\u0301cran-2022-08-15-a\u0300-15.33.56-540x179.png 540w\" sizes=\"auto, (max-width: 841px) 100vw, 841px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous disposez d&rsquo;un fichier Excel contenant par exemple des adresses de contacts internes (facult\u00e9s, services, unit\u00e9s&#8230;). Dans votre tableau, une colonne est pr\u00e9vue pour contenir les URL&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3792,"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-1038","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\/1038","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=1038"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1038\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3792"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=1038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=1038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=1038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}