{"id":8758,"date":"2020-03-16T22:51:32","date_gmt":"2020-03-16T21:51:32","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=8758"},"modified":"2020-03-14T14:52:42","modified_gmt":"2020-03-14T13:52:42","slug":"personnaliser-ou-contourner-les-messages-derreur-excel-avec-la-fonction-sierreur","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=8758","title":{"rendered":"Personnaliser ou contourner les messages d&#8217;erreur Excel avec la fonction SIERREUR"},"content":{"rendered":"<p style=\"text-align: justify;\">Les formules de calcul d&#8217;Excel peuvent renvoyer des <a href=\"https:\/\/www.auditsi.eu\/?p=8748\">messages d&#8217;erreur<\/a> si la formule comprend une fonction inconnue ou mal orthographi\u00e9e (faute de frappe), si la syntaxe d&#8217;une fonction n&#8217;est pas respect\u00e9e (param\u00e8tre manquant ou surnum\u00e9raire) ou encore si le r\u00e9sultat est impossible \u00e0 obtenir (par exemple division par z\u00e9ro).<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=7571\" rel=\"attachment wp-att-7571\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7571\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/09\/connector-excel-logo1.png\" alt=\"Logo Excel\" width=\"580\" height=\"210\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/09\/connector-excel-logo1.png 580w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/09\/connector-excel-logo1-300x109.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><em>#NOM?, #REF!, #N\/A<\/em>&#8230; Ces messages ne sont pas tr\u00e8s parlants. Il peut \u00eatre souhaitable de les remplacer par un message moins sibyllin voire par un autre calcul.<\/p>\n<p style=\"text-align: justify;\">La fonction <em>SIERREUR<\/em> remplit parfaitement cette mission.<\/p>\n<p style=\"text-align: justify;\">Cette fonction s&#8217;utilise ainsi :<\/p>\n<p style=\"text-align: center;\">SIERREUR(valeur;valeur_si_erreur)<\/p>\n<p style=\"text-align: justify;\">Le param\u00e8tre <em>valeur<\/em> correspond \u00e0 la formule \u00e0 \u00e9valuer.<\/p>\n<p style=\"text-align: justify;\">Le param\u00e8tre <em>valeur_si_erreur<\/em> correspond au message ou \u00e0 la formule de calcul alternative si le param\u00e8tre valeur renvoie une erreur de type <em>#N\/A, #VALEUR!, #REF!, #DIV\/0!, #NOMBRE!, #NOM?, ou #NUL!<\/em>.<\/p>\n<p>Par exemple :<\/p>\n<p style=\"text-align: center;\">=SIERREUR(B5\/C5;&#8221;Rev\u00e9rifiez vos crit\u00e8res, C5 doit \u00eatre diff\u00e9rent de z\u00e9ro&#8221;)<\/p>\n<p style=\"text-align: justify;\">Dans ce cas, si la formule <em>B5\/C5<\/em> renvoie un message d&#8217;erreur alors Excel renvoie les message entre guillemets au lieu du message d&#8217;erreur.<\/p>\n<p style=\"text-align: center;\">=SIERREUR(B5\/C5;B5\/D5)<\/p>\n<p style=\"text-align: justify;\">Dans ce cas, si la formule <em>B5\/C5<\/em> renvoie un message d&#8217;erreur alors Excel ex\u00e9cute le calcul <em>B5\/D5<\/em>.<\/p>\n<p style=\"text-align: justify;\">Il est possible d&#8217;encha\u00eener des fonctions <em>SIERREUR<\/em> de la m\u00eame mani\u00e8re de la fonction <em>SI<\/em> afin de valider successivement les formules \u00e0 \u00e9valuer.<\/p>\n<p style=\"text-align: justify;\">Par exemple :<\/p>\n<p style=\"text-align: center;\">=SIERREUR(B5\/C5;SIERREUR(B5\/D5;&#8221;Rev\u00e9rifiez vos crit\u00e8res, D5 doit \u00eatre diff\u00e9rent de z\u00e9ro&#8221;))<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a> \/ <a href=\"https:\/\/www.auditsi.eu\/?p=8748\">Les messages d&#8217;erreur d&#8217;Excel<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Personnaliser%20ou%20contourner%20les%20messages%20d%27erreur%20Excel%20avec%20la%20fonction%20SIERREUR\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les formules de calcul d&#8217;Excel peuvent renvoyer des messages d&#8217;erreur si la formule comprend une fonction inconnue ou mal orthographi\u00e9e (faute de frappe), si la syntaxe d&#8217;une fonction n&#8217;est pas respect\u00e9e (param\u00e8tre manquant ou surnum\u00e9raire) ou encore si le r\u00e9sultat est impossible \u00e0 obtenir (par exemple division par z\u00e9ro). #NOM?, #REF!, #N\/A&#8230; Ces messages ne &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=8758\" class=\"more-link\">Continue reading &lsquo;Personnaliser ou contourner les messages d&#8217;erreur Excel avec la fonction SIERREUR&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Personnaliser%20ou%20contourner%20les%20messages%20d%27erreur%20Excel%20avec%20la%20fonction%20SIERREUR\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48,1326],"tags":[2170,1144,2188,2168,1392,2187],"class_list":["post-8758","post","type-post","status-publish","format-standard","hentry","category-excel","category-maitriser-excel","tag-division-par-zero","tag-formule-de-calcul","tag-imbrication","tag-message-derreur","tag-si","tag-sierreur"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8758"}],"version-history":[{"count":4,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8758\/revisions"}],"predecessor-version":[{"id":8762,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8758\/revisions\/8762"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}