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

Introduction \u00e0 la fonction sp\u00e9cifique<\/h2>\n

La fonctionnalit\u00e9 en question dans MS Excel permet de calculer la fonction de Bessel de type Y, qui est l’une des solutions de l’\u00e9quation diff\u00e9rentielle de Bessel, largement utilis\u00e9e dans les probl\u00e8mes de physique appliqu\u00e9e tels que les ondes thermiques et \u00e9lectromagn\u00e9tiques. Cette fonction n\u00e9cessite deux param\u00e8tres : l’ordre de la fonction de Bessel et la valeur \u00e0 laquelle la fonction doit \u00eatre \u00e9valu\u00e9e.<\/p>\n

Dans Google Sheets, cette fonction sp\u00e9cifique de Bessel n’est pas directement accessible, mais peut \u00eatre approxim\u00e9e en utilisant d’autres m\u00e9thodes ou scripts Google Apps.<\/p>\n

Syntaxe et exemples<\/h2>\n

Dans MS Excel, la syntaxe est :<\/p>\n

BESSELY(n, x)<\/code><\/pre>\n
    \n
  • n<\/strong> : L’ordre de la fonction de Bessel de type Y. Il doit \u00eatre un nombre entier.<\/li>\n
  • x<\/strong> : La valeur r\u00e9elle pour laquelle la fonction Bessel de type Y est calcul\u00e9e.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    =BESSELY(2, 3)<\/code><\/pre>\n
    Ce calcul retournera la valeur de la fonction Bessel de type Y de second ordre pour x=3.<\/p>\n
    Applications pratiques<\/h2>\n
    Calcul des distributions d’ondes<\/h2>\n
    La fonction de Bessel est couramment utilis\u00e9e pour analyser les ondelettes transversant diff\u00e9rents milieux en physique. Par exemple, elle peut \u00eatre employ\u00e9e pour d\u00e9terminer la distribution de la pression dans un r\u00e9servoir acoustique circulaire.<\/p>\n
    Imaginez qu’une onde frappe un r\u00e9servoir circulaire \u00e0 une certaine fr\u00e9quence et que nous souhaitions conna\u00eetre la distribution de pression \u00e0 un rayon de 5 m\u00e8tres du centre, pour un mode de vibration de 0 (n=0). La formule \u00e0 utiliser dans Excel serait :<\/p>\n
    =BESSELY(0, 5)<\/code><\/pre>\n
    Cela donnerait la valeur proportionnelle \u00e0 la pression de base \u00e0 ce rayon, facilitant la visualisation de la distribution de pression dans le r\u00e9servoir.<\/p>\n
    Analyse vibrationnelle dans les structures m\u00e9caniques<\/h2>\n
    Les fonctions de Bessel sont \u00e9galement utilis\u00e9es pour \u00e9tudier les vibrations radiales dans les structures cylindriques tels que les arbres dans les moteurs ou machines. Supposons l’analyse d’un arbre qui vibre en mode radial 1 (n=1) \u00e0 un point situ\u00e9 \u00e0 10 cm du centre de l’arbre.<\/p>\n
    La formule pour d\u00e9terminer l’amplitude de cette vibration \u00e0 ce point serait :<\/p>\n
    =BESSELY(1, 10)<\/code><\/pre>\n
    Les r\u00e9sultats aideront les ing\u00e9nieurs \u00e0 mieux comprendre l’amplitude de la vibration et \u00e0 envisager des mesures pour l’att\u00e9nuer si n\u00e9cessaire.<\/p>\n
    Notez que la pr\u00e9cision des valeurs ‘x’ et ‘n’ est cruciale; des erreurs dans ces valeurs peuvent entra\u00eener des r\u00e9sultats incorrects ou mal interpr\u00e9t\u00e9s, surtout dans des applications critiques comme l’ing\u00e9nierie et la physique.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la fonction Bessel Yn(x)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[316],"tags":[],"class_list":["post-6408","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction BESSELY dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction BESSELY 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\/bessely\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction BESSELY dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction BESSELY d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/bessely\/\" \/>\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:02:19+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction BESSELY 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\/bessely\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/bessely\/\",\"name\":\"Fonction BESSELY 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:02:19+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction BESSELY d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/bessely\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/bessely\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/bessely\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ing\u00e9nierie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/ingenierie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BESSELY\"}]},{\"@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 BESSELY dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction BESSELY 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\/bessely\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction BESSELY dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction BESSELY d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/bessely\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:19+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction BESSELY 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\/bessely\/","url":"https:\/\/functiontranslator.com\/fr\/bessely\/","name":"Fonction BESSELY 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:02:19+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction BESSELY d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/bessely\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/bessely\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/bessely\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Ing\u00e9nierie","item":"https:\/\/functiontranslator.com\/fr\/ingenierie\/"},{"@type":"ListItem","position":3,"name":"BESSELY"}]},{"@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\/6408","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=6408"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6408\/revisions"}],"predecessor-version":[{"id":29420,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6408\/revisions\/29420"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}