{"id":530,"date":"2023-10-24T23:24:16","date_gmt":"2023-10-24T23:24:16","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/cuadrado\/"},"modified":"2023-12-25T10:31:07","modified_gmt":"2023-12-25T10:31:07","slug":"cuadrado","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/cuadrado\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sqr?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-968672201\"><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 funci\u00f3n VBA SQR figura en la categor\u00eda matem\u00e1tica de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>devuelve la ra\u00edz cuadrada del n\u00famero proporcionado<\/strong> . En t\u00e9rminos simples, puedes calcular la ra\u00edz cuadrada de un n\u00famero con \u00e9l.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>SQR(N\u00famero)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>N\u00famero<\/strong> : Un n\u00famero del cual desea calcular la ra\u00edz cuadrada.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA SQR, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-sqr-funci\u00f3n\" 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>\n<\/div>\n<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>\n<p> En el c\u00f3digo anterior usamos SQR para obtener la ra\u00edz cuadrada del valor que tenemos en la celda A1 (625), devolvi\u00f3 25, que es la ra\u00edz cuadrada de 625 en la celda B1.<\/p>\n<p> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/es\/raiz-cuadrada\/\">C\u00f3mo calcular la ra\u00edz cuadrada en Excel<\/a><\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si el valor especificado es un valor distinto de un n\u00famero o un n\u00famero que no puede reconocerse como un n\u00famero, VBA devolver\u00e1 el error de tiempo de ejecuci\u00f3n 13.<\/li>\n<li> Si el n\u00famero proporcionado es un n\u00famero negativo, VBA devolver\u00e1 un error de tiempo de ejecuci\u00f3n 5. <\/li>\n<\/ul>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-80\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/rnd\/\">RND-VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/redondo\/\">RONDA VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/firmar\/\">SGN-VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/pecado\/\">NAS-VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/broncearse\/\">VBA BRONCEADO<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA SQR figura en la categor\u00eda matem\u00e1tica de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve la ra\u00edz cuadrada del n\u00famero proporcionado . En t\u00e9rminos simples, puedes calcular la ra\u00edz cuadrada de un n\u00famero con \u00e9l. Sintaxis SQR(N\u00famero) Argumentos N\u00famero : Un n\u00famero del cual desea calcular la ra\u00edz cuadrada. Ejemplo Para [&hellip;]<\/p>\n","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-530","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>\u00bfc\u00f3mo utilizar la funci\u00f3n vba sqr?<\/title>\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\/es\/cuadrado\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sqr?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA SQR figura en la categor\u00eda matem\u00e1tica de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve la ra\u00edz cuadrada del n\u00famero proporcionado . En t\u00e9rminos simples, puedes calcular la ra\u00edz cuadrada de un n\u00famero con \u00e9l. Sintaxis SQR(N\u00famero) Argumentos N\u00famero : Un n\u00famero del cual desea calcular la ra\u00edz cuadrada. Ejemplo Para [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/cuadrado\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:07+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=\"Tiempo de lectura\" \/>\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\/es\/cuadrado\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/cuadrado\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sqr?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cuadrado\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cuadrado\/#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-25T10:31:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cuadrado\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/cuadrado\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/cuadrado\/#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\/es\/cuadrado\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sqr?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sqr?","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\/es\/cuadrado\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sqr?","og_description":"La funci\u00f3n VBA SQR figura en la categor\u00eda matem\u00e1tica de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve la ra\u00edz cuadrada del n\u00famero proporcionado . En t\u00e9rminos simples, puedes calcular la ra\u00edz cuadrada de un n\u00famero con \u00e9l. Sintaxis SQR(N\u00famero) Argumentos N\u00famero : Un n\u00famero del cual desea calcular la ra\u00edz cuadrada. Ejemplo Para [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/cuadrado\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:07+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":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/cuadrado\/","url":"https:\/\/exceladvisor.org\/es\/cuadrado\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sqr?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/cuadrado\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/cuadrado\/#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-25T10:31:07+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/cuadrado\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/cuadrado\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/cuadrado\/#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\/es\/cuadrado\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba sqr?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=530"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/530\/revisions"}],"predecessor-version":[{"id":1342,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/530\/revisions\/1342"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}