{"id":6678,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/na\/"},"modified":"2021-02-26T08:10:48","modified_gmt":"2021-02-26T08:10:48","slug":"na","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/na\/","title":{"rendered":"NA"},"content":{"rendered":"

Description et syntaxe de la fonction<\/h2>\n

La fonction NA()<\/code> dans Microsoft Excel et Google Sheets est utilis\u00e9e pour g\u00e9n\u00e9rer l’erreur #N\/A<\/code>, qui signifie \u00ab Non disponible \u00bb. Cette erreur est couramment utilis\u00e9e pour signaler qu’une donn\u00e9e ou une valeur n’est pas disponible. L’un des principaux avantages de cette fonction est qu’elle permet de diff\u00e9rencier les donn\u00e9es manquantes intentionnelles des erreurs survenues par accident.<\/p>\n

Syntaxe de la fonction :<\/p>\n

=NA()<\/code><\/pre>\n
Cette fonction ne n\u00e9cessite aucun argument, ce qui la rend extr\u00eamement simple \u00e0 utiliser.<\/p>\n
Exemples d’utilisation<\/h2>\n
Voici quelques cas o\u00f9 l’utilisation de la fonction NA()<\/code> peut s’av\u00e9rer utile :<\/p>\n
    \n
  • Dans un tableau r\u00e9capitulatif des ventes par r\u00e9gion, si les donn\u00e9es de certaines r\u00e9gions ne sont pas encore disponibles, vous pouvez ins\u00e9rer =NA()<\/code> pour indiquer explicitement ces manques.<\/li>\n
  • Lorsque vous cr\u00e9ez des graphiques, utiliser =NA()<\/code> peut pr\u00e9venir l’affichage de segments incorrects ou trompeurs dus \u00e0 des lacunes dans les donn\u00e9es.<\/li>\n<\/ul>\n
    Sc\u00e9narios pratiques<\/h2>\n
    Sc\u00e9nario 1 : Cr\u00e9ation d’une liste de ventes mensuelles<\/p>\n\n\n\n\n\n
    Mois<\/th>\nVentes<\/th>\n<\/tr>\n
    Janvier<\/td>\n250<\/td>\n<\/tr>\n
    F\u00e9vrier<\/td>\n=NA()<\/td>\n<\/tr>\n
    Mars<\/td>\n300<\/td>\n<\/tr>\n<\/table>\n
    Dans cet exemple, les donn\u00e9es de vente pour f\u00e9vrier ne sont pas disponibles. Plut\u00f4t que de laisser cette cellule vide ou d’utiliser la valeur 0 – qui pourrait \u00eatre interpr\u00e9t\u00e9e comme l’indication de ventes inexistantes – l’utilisation de =NA()<\/code> signale clairement l’absence de donn\u00e9es pour ce mois.<\/p>\n
    Sc\u00e9nario 2 : Application dans les graphiques<\/p>\n
    Imaginez que vous poss\u00e9dez un ensemble de donn\u00e9es de ventes mensuelles et que vous cr\u00e9ez un graphique lin\u00e9aire. En ins\u00e9rant =NA()<\/code> pour les mois sans donn\u00e9es, la ligne du graphique sera interrompue \u00e0 ces endroits, ce qui \u00e9vite de relier directement les mois avec des donn\u00e9es disponibles et aide \u00e0 pr\u00e9venir toute interpr\u00e9tation erron\u00e9e.<\/p>\n
    Mois | Ventes Janvier | 300 F\u00e9vrier | #N\/A Mars | 150<\/code><\/pre>\n
    Dans le graphique r\u00e9sultant, la ligne s’arr\u00eatera \u00e0 janvier et reprendra en mars, montrant clairement l’absence de donn\u00e9es pour f\u00e9vrier.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeuR d\u2019eRReuR #N\/A<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[319],"tags":[],"class_list":["post-6678","post","type-post","status-publish","format-standard","hentry","category-informations"],"acf":[],"yoast_head":"\nFonction NA dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NA 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\/na\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NA dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/na\/\" \/>\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:10:48+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NA 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\/na\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/na\/\",\"name\":\"Fonction NA 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:10:48+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/na\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/na\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/na\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Informations\",\"item\":\"https:\/\/functiontranslator.com\/fr\/informations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NA\"}]},{\"@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 NA dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NA 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\/na\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NA dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/na\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:48+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NA 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\/na\/","url":"https:\/\/functiontranslator.com\/fr\/na\/","name":"Fonction NA 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:10:48+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/na\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/na\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/na\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Informations","item":"https:\/\/functiontranslator.com\/fr\/informations\/"},{"@type":"ListItem","position":3,"name":"NA"}]},{"@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\/6678","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=6678"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6678\/revisions"}],"predecessor-version":[{"id":29689,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6678\/revisions\/29689"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}