{"id":2002,"date":"2023-10-24T23:24:16","date_gmt":"2023-10-24T23:24:16","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/mq\/"},"modified":"2023-12-10T06:25:24","modified_gmt":"2023-12-10T06:25:24","slug":"mq","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/mq\/","title":{"rendered":"Come utilizzare la funzione sqr vba?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-410463082\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>La funzione VBA SQR \u00e8 elencata nella categoria matematica delle funzioni VBA. Quando lo usi nel codice VBA, <strong>restituisce la radice quadrata del numero fornito<\/strong> . In termini semplici, con esso puoi calcolare la radice quadrata di un numero.<\/p><h2 class=\"wp-block-heading\"> Sintassi<\/h2><p> <strong>SQR(Numero)<\/strong><\/p><h2 class=\"wp-block-heading\"> argomenti<\/h2><ul><li> <strong>Numero<\/strong> : un numero di cui si desidera calcolare la radice quadrata.<\/li><\/ul><h2 class=\"wp-block-heading\"> Esempio<\/h2><p> Per capire praticamente come utilizzare la funzione SQR di VBA \u00e8 necessario seguire l&#8217;esempio seguente in cui abbiamo scritto un codice vba utilizzandola: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"funzione-vba-sqr-esempio\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sqr.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-sqr-function\" width=\"627\" height=\"345\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_SQR() Range(\"B1\").Value = Sqr(Range(\"A1\")) End Sub<\/code><\/pre><p> Nel codice sopra abbiamo utilizzato SQR per ottenere la radice quadrata del valore che abbiamo nella cella A1 (625), ha restituito 25 che \u00e8 la radice quadrata di 625 nella cella B1.<\/p><p> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/it\/radice-quadrata\/\">Come calcolare la radice quadrata in Excel<\/a><\/p><h2 class=\"wp-block-heading\"> Commenti<\/h2><ul><li> Se il valore specificato \u00e8 un valore diverso da un numero o un numero che non pu\u00f2 essere riconosciuto come numero, VBA restituir\u00e0 l&#8217;errore di runtime 13.<\/li><li> Se il numero fornito \u00e8 un numero negativo, VBA restituir\u00e0 un errore di runtime 5. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Altri tutorial <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-80\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/it\/rnd\/\">RND VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/girare\/\">VBA TONDO<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/segno\/\">SGN VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/peccato\/\">NAS VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/abbronzatura\/\">VBA TAN<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2002","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Come utilizzare la funzione SQR VBA? (sintassi + esempio)<\/title>\n<meta name=\"description\" content=\"Scopri come utilizzare la funzione SQR VBA con sintassi, argomenti ed esempio con codice di esempio.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/it\/mq\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come utilizzare la funzione SQR VBA? (sintassi + esempio)\" \/>\n<meta property=\"og:description\" content=\"Scopri come utilizzare la funzione SQR VBA con sintassi, argomenti ed esempio con codice di esempio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/mq\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:25:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sqr.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/mq\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/mq\/\",\"name\":\"Come utilizzare la funzione SQR VBA? (sintassi + esempio)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/mq\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/mq\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sqr.png\",\"datePublished\":\"2023-10-24T23:24:16+00:00\",\"dateModified\":\"2023-12-10T06:25:24+00:00\",\"description\":\"Scopri come utilizzare la funzione SQR VBA con sintassi, argomenti ed esempio con codice di esempio.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/mq\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/mq\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/mq\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sqr.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sqr.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/mq\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come utilizzare la funzione sqr vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come utilizzare la funzione SQR VBA? (sintassi + esempio)","description":"Scopri come utilizzare la funzione SQR VBA con sintassi, argomenti ed esempio con codice di esempio.","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:\/\/exceladvisor.org\/it\/mq\/","og_locale":"it_IT","og_type":"article","og_title":"Come utilizzare la funzione SQR VBA? (sintassi + esempio)","og_description":"Scopri come utilizzare la funzione SQR VBA con sintassi, argomenti ed esempio con codice di esempio.","og_url":"https:\/\/exceladvisor.org\/it\/mq\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:25:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sqr.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/mq\/","url":"https:\/\/exceladvisor.org\/it\/mq\/","name":"Come utilizzare la funzione SQR VBA? (sintassi + esempio)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/mq\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/mq\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sqr.png","datePublished":"2023-10-24T23:24:16+00:00","dateModified":"2023-12-10T06:25:24+00:00","description":"Scopri come utilizzare la funzione SQR VBA con sintassi, argomenti ed esempio con codice di esempio.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/mq\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/mq\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/mq\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sqr.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-sqr.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/mq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come utilizzare la funzione sqr vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=2002"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2002\/revisions"}],"predecessor-version":[{"id":2669,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2002\/revisions\/2669"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=2002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}