{"id":6586,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/si-non-disp\/"},"modified":"2021-02-26T08:07:37","modified_gmt":"2021-02-26T08:07:37","slug":"ifna","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/ifna\/","title":{"rendered":"SI.NON.DISP"},"content":{"rendered":"

La fonction SI.NON.DISP dans MS Excel et Google Sheets est une extension de la fonction SI, con\u00e7ue pour g\u00e9rer sp\u00e9cifiquement les erreurs #N\/A (non disponible). Elle trouve son utilit\u00e9 dans le traitement des donn\u00e9es manquantes ou non disponibles dans vos feuilles de calcul.<\/p>\n

Syntaxe et Utilisation<\/h2>\n

Voici la syntaxe de la fonction SI.NON.DISP :<\/p>\n

SI.NON.DISP(valeur, valeur_si_na)<\/code><\/pre>\n
    \n
  • valeur<\/code> : Repr\u00e9sente l’expression ou la formule \u00e9valu\u00e9e.<\/li>\n
  • valeur_si_na<\/code> : Sp\u00e9cifie la valeur \u00e0 retourner en cas de r\u00e9sultat #N\/A.<\/li>\n<\/ul>\n
    Illustrons cette fonction par un exemple concret :<\/p>\n
    =SI.NON.DISP(RECHERCHEV(\"Pomme\", A1:B10, 2, FAUX), \"Non trouv\u00e9\")<\/code><\/pre>\n
    Dans cet exemple, RECHERCHEV essaie de localiser \u00ab\u00a0Pomme\u00a0\u00bb dans la plage A1:B10. Si \u00ab\u00a0Pomme\u00a0\u00bb n’est pas trouv\u00e9e et que RECHERCHEV renvoie #N\/A, SI.NON.DISP retournera \u00ab\u00a0Non trouv\u00e9\u00a0\u00bb.<\/p>\n
    Cas Pratiques<\/h2>\n
    Examinons deux sc\u00e9narios o\u00f9 SI.NON.DISP s’av\u00e8re particuli\u00e8rement b\u00e9n\u00e9fique.<\/p>\n
    Cas 1: Gestion des donn\u00e9es manquantes dans un inventaire de produits<\/h3>\n
    Supposons que vous disposiez d’une liste de codes produits en colonne A et de quantit\u00e9s correspondantes en colonne B, o\u00f9 certaines quantit\u00e9s sont manquantes, signal\u00e9es par #N\/A.<\/p>\n
    La formule suivante remplace #N\/A par 0, facilitant ainsi le calcul du total :<\/p>\n
    =SI.NON.DISP(B2, 0)<\/code><\/pre>\n
    En appliquant cette formule dans une nouvelle colonne C pour chaque ligne produit, #N\/A est remplac\u00e9 par 0, simplifiant la somme totale des quantit\u00e9s.<\/p>\n
    Cas 2: Int\u00e9gration de donn\u00e9es entre deux feuilles de calcul<\/h3>\n
    Imaginez que vous disposiez de deux feuilles : l’une avec les noms et ID des employ\u00e9s et l’autre avec les ID et e-mails. Certains e-mails peuvent manquer.<\/p>\n
    Pour cr\u00e9er une liste unifi\u00e9e dans une troisi\u00e8me feuille, utilisez RECHERCHEV pour associer chaque ID \u00e0 un e-mail et employez SI.NON.DISP pour traiter les cas o\u00f9 un ID ne correspond \u00e0 aucun e-mail :<\/p>\n
    =SI.NON.DISP(RECHERCHEV(ID, Feuille2!A2:B100, 2, FAUX), \"Email non disponible\")<\/code><\/pre>\n
    Cette approche pr\u00e9vient les erreurs #N\/A, affichant \u00ab\u00a0Email non disponible\u00a0\u00bb \u00e0 la place, ce qui rend les donn\u00e9es finales plus nettes et plus compr\u00e9hensibles.<\/p>\n
    En somme, la fonction SI.NON.DISP est extr\u00eamement pr\u00e9cieuse pour assurer l’int\u00e9grit\u00e9 et la clart\u00e9 des donn\u00e9es dans vos feuilles de calcul, surtout lors du traitement de grandes bases de donn\u00e9es ou de donn\u00e9es import\u00e9es de sources externes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeur que vous sp\u00e9cifiez si l\u2019expression est r\u00e9solue \u00e0 #N\/A\u00a0; autrement, renvoie le r\u00e9sultat de l\u2019expression<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[313],"tags":[],"class_list":["post-6586","post","type-post","status-publish","format-standard","hentry","category-logique"],"acf":[],"yoast_head":"\nFonction IFNA (SI.NON.DISP) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction IFNA (SI.NON.DISP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/ifna\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction IFNA (SI.NON.DISP) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction IFNA (SI.NON.DISP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/ifna\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:07:37+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction IFNA (SI.NON.DISP) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ifna\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/ifna\/\",\"name\":\"Fonction IFNA (SI.NON.DISP) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:07:37+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction IFNA (SI.NON.DISP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/ifna\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/ifna\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ifna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Logique\",\"item\":\"https:\/\/functiontranslator.com\/fr\/logique\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SI.NON.DISP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction IFNA (SI.NON.DISP) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction IFNA (SI.NON.DISP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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:\/\/functiontranslator.com\/fr\/ifna\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction IFNA (SI.NON.DISP) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction IFNA (SI.NON.DISP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/ifna\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:07:37+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction IFNA (SI.NON.DISP) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/ifna\/","url":"https:\/\/functiontranslator.com\/fr\/ifna\/","name":"Fonction IFNA (SI.NON.DISP) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:07:37+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction IFNA (SI.NON.DISP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/ifna\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/ifna\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/ifna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Logique","item":"https:\/\/functiontranslator.com\/fr\/logique\/"},{"@type":"ListItem","position":3,"name":"SI.NON.DISP"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6586"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6586\/revisions"}],"predecessor-version":[{"id":29597,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6586\/revisions\/29597"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}