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

Dans cet article, nous allons explorer le fonctionnement de la fonction TAN dans Microsoft Excel et Google Sheets. Cette fonction calcule la tangente d’un angle donn\u00e9, un outil tr\u00e8s utile dans divers contextes, particuli\u00e8rement en trigonom\u00e9trie, ing\u00e9nierie ou m\u00eame en finance.<\/p>\n

Syntaxe et exemple d’utilisation<\/h2>\n

La syntaxe pour la fonction TAN est relativement simple :<\/p>\n

TAN(angle)<\/code><\/pre>\n
O\u00f9 angle<\/code> d\u00e9signe l’angle en radians pour lequel vous souhaitez calculer la tangente. Pour convertir des degr\u00e9s en radians, vous pouvez utiliser la fonction RADIANS(degrees)<\/code> ou multiplier les degr\u00e9s par PI()\/180<\/code>.<\/p>\n
Exemple:<\/p>\n
=TAN(RADIANS(45)) \/\/ Renvoie 1, la tangente de 45 degr\u00e9s.<\/code><\/pre>\n
Notez que dans Google Sheets et Microsoft Excel, la m\u00eame formule peut \u00eatre utilis\u00e9e sans modification.<\/p>\n
Applications pratiques<\/h2>\n
La fonction TAN est fr\u00e9quemment utilis\u00e9e dans de nombreux sc\u00e9narios pratiques. Voici quelques exemples illustrant son utilit\u00e9 :<\/p>\n
Calcul de la pente d’une rampe<\/h2>\n
Probl\u00e8me :<\/strong> Vous devez construire une rampe pour un b\u00e2timent et la pente maximale autoris\u00e9e par les normes est de 5 degr\u00e9s. Quelle est la tangente de cette pente, qui exprime le rapport entre le gain de hauteur et la longueur de la rampe?<\/p>\n
Solution :<\/strong><\/p>\n
=TAN(RADIANS(5))<\/code><\/pre>\n
Ce calcul vous donne la tangente de 5 degr\u00e9s, indiquant le rapport hauteur\/longueur de la rampe. Par exemple, une tangente d’environ 0.0875 signifie que pour chaque m\u00e8tre de longueur, la rampe monte de 0.0875 m\u00e8tres.<\/p>\n
Analyse de r\u00e9sultats dans des exp\u00e9riences scientifiques<\/h2>\n
Probl\u00e8me :<\/strong> Dans une exp\u00e9rience scientifique mesurant des angles de r\u00e9fraction, un angle de 33 degr\u00e9s est obtenu. Pour analyser ces donn\u00e9es en relation avec certaines th\u00e9ories, vous devez calculer la tangente de cet angle.<\/p>\n
Solution :<\/strong><\/p>\n
=TAN(RADIANS(33))<\/code><\/pre>\n
Cette formule vous permet d’obtenir la tangente de l’angle de r\u00e9fraction, n\u00e9cessaire pour comparer les r\u00e9sultats exp\u00e9rimentaux \u00e0 des mod\u00e8les th\u00e9oriques ou \u00e0 d’autres mesures.<\/p>\n
En conclusion, TAN est une fonction essentielle pour quiconque travaille avec des mesures d’angles, s’\u00e9tendant au-del\u00e0 de l’ing\u00e9nierie ou de la science \u00e0 des domaines tels que l’architecture ou la finance.<\/p>\n","protected":false},"excerpt":{"rendered":"
Renvoie la tangente d\u2019un nombRe<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[310],"tags":[],"class_list":["post-6799","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction TAN dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TAN 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\/tan\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TAN dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TAN d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/tan\/\" \/>\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:14:51+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TAN 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\/tan\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/tan\/\",\"name\":\"Fonction TAN 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:14:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TAN d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/tan\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/tan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/tan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math\u00e9matiques et trigonom\u00e9trie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TAN\"}]},{\"@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 TAN dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TAN 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\/tan\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TAN dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TAN d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/tan\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TAN 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\/tan\/","url":"https:\/\/functiontranslator.com\/fr\/tan\/","name":"Fonction TAN 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:14:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TAN d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/tan\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/tan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/tan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Math\u00e9matiques et trigonom\u00e9trie","item":"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"TAN"}]},{"@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\/6799","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=6799"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6799\/revisions"}],"predecessor-version":[{"id":29808,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6799\/revisions\/29808"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}