{"id":15269,"date":"2024-01-23T11:20:53","date_gmt":"2024-01-23T14:20:53","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=15269"},"modified":"2024-01-24T11:21:49","modified_gmt":"2024-01-24T14:21:49","slug":"errores-en-formulas-nulo","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/","title":{"rendered":"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #136e42;\"><strong><u>ENTENDIENDO ERRORES EN F\u00d3RMULAS DE EXCEL: #\u00a1NULO! POR QU\u00c9 OCURRE Y C\u00d3MO RESOLVERLO<\/u><\/strong><\/span><\/p><div id=\"excel-4225082711\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>En Excel, nos encontramos con diversos desaf\u00edos, y uno de los mensajes de error m\u00e1s frecuentes es el misterioso<strong> #\u00a1NULO!<\/strong>. Este peque\u00f1o inconveniente puede surgir por diversas razones, desde referencias a celdas vac\u00edas hasta la utilizaci\u00f3n incorrecta de ciertos operadores. En este art\u00edculo, exploraremos a fondo qu\u00e9 significa este error, las situaciones en las que suele manifestarse y, lo m\u00e1s importante, c\u00f3mo puedes superarlo con soluciones pr\u00e1cticas.<\/p>\n<h2>\u00bfCU\u00c1NDO EXCEL MUESTRA EL ERROR #\u00a1NULO!?<\/h2>\n<p>El error <strong>#\u00a1NULO!<\/strong> en Excel se genera cuando se usa un operador de rango incorrecto en una f\u00f3rmula. Esto significa que Excel no puede realizar la operaci\u00f3n solicitada ya que no puede determinar el rango de la f\u00f3rmula debido a que se topa con un valor vac\u00edo. Es un error poco frecuente que habitualmente se genera debido a un error de tipeo donde un espacio ocupa el lugar de un car\u00e1cter.<\/p>\n<h2>SITUACIONES COMUNES QUE GENERAN EL ERROR #\u00a1NULO!<\/h2>\n<h3>1. FALTA DE DOS PUNTOS EN UN RANGO:<\/h3>\n<p style=\"padding-left: 40px;\">Si no has colocado <strong>dos puntos (:)<\/strong> para separar la primera celda de la \u00faltima al hacer referencia a un rango continuo de celdas de una f\u00f3rmula.<\/p>\n<p style=\"padding-left: 40px;\">Por ejemplo, si estamos intentando sumar los valores desde la celda <strong>A2<\/strong> hasta la celda <strong>A8<\/strong>, al omitir los dos puntos, (un operador de uni\u00f3n) Excel no comprender\u00e1 la extensi\u00f3n del rango y arrojar\u00e1 el error<strong> #\u00a1NULO!<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15270 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/Nulo-1.png\" alt=\"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!\" width=\"368\" height=\"264\" \/><\/p>\n<h3>2. AUSENCIA DE PUNTO Y COMA EN FUNCIONES<\/h3>\n<p style=\"padding-left: 40px;\">Si falta una punto y coma <strong>(;)<\/strong> como operador de uni\u00f3n para separar argumentos de una funci\u00f3n.<\/p>\n<p style=\"padding-left: 40px;\">En este ejemplo, al escribir <strong>=PROMEDIO(A2 B2 C2)<\/strong>, estamos tratando de calcular el promedio de los valores en las celdas A2, B2 y C2. Sin embargo, al no utilizar punto y comas, Excel interpreta la f\u00f3rmula de manera incorrecta.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15271 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/Nulo-2.png\" alt=\"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!\" width=\"448\" height=\"130\" \/><\/p>\n<h2>C\u00d3MO CORREGIR EL ERROR #\u00a1NULO!<\/h2>\n<p style=\"padding-left: 40px;\">Como el error #\u00a1NULO! suele aparecer cuando existe una indeterminaci\u00f3n en un rango, para solucionarlo debemos controlar que los rangos definidos dentro de la funci\u00f3n o f\u00f3rmula contengan todos los datos necesarios para ser v\u00e1lidos.<\/p>\n<p style=\"padding-left: 40px;\">Por ejemplo, podemos haber ingresado la siguiente funci\u00f3n <strong>=SUMA(A2 A8)<\/strong> donde no colocamos el s\u00edmbolo <strong>\u201c:\u201d<\/strong> entre las dos celdas de referencia, y la sintaxis correcta deber\u00eda ser<strong> =SUMA(A2:A8)<\/strong>.<\/p>\n<p style=\"padding-left: 40px;\">Cuando utilizamos una funci\u00f3n y declaramos una o m\u00e1s celdas espec\u00edficas con espacio en vez de punto y coma, habitualmente por errores de tipeo o mal escrito, como <strong>=PROMEDIO(A1 B1 C1)<\/strong>, donde deber\u00eda ser <strong>=PROMEDIO(A1;B1;C1)<\/strong><\/p>\n<p>Comprender y abordar los errores en f\u00f3rmulas de tipo <strong>#\u00a1NULO!<\/strong> es esencial para todos los entusiastas de las hojas de c\u00e1lculo. Al identificar las causas comunes y aplicar las soluciones proporcionadas, estar\u00e1s mejor equipado para mantener la integridad de tus datos y f\u00f3rmulas. Recuerda, en Excel, los desaf\u00edos son oportunidades de aprendizaje, y dominar la resoluci\u00f3n de errores te acerca un paso m\u00e1s a la excelencia en tus habilidades con esta poderosa herramienta. <strong><span style=\"color: #136e42;\">\u00a1Adelante, enfrenta el #\u00a1NULO! con confianza y eleva tus habilidades en Excel!<\/span><\/strong><\/p>\n<hr \/>\n<blockquote><p><strong><span style=\"color: #136e42;\">\u00bb<\/span> Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\">Facebook<\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\">Instagram<\/a>.<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\">Curso de Excel Online<\/a><\/strong><\/p>\n<hr \/>\n<p>&nbsp;<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; ENTENDIENDO ERRORES EN F\u00d3RMULAS &#8230; <a title=\"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/\" aria-label=\"Leer m\u00e1s sobre ERRORES EN F\u00d3RMULAS: #\u00a1NULO!\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":15275,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[778,328,346,519],"tags":[779],"class_list":["post-15269","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-errores","category-excel","category-excel-basico","category-formulas-y-funciones","tag-error-en-excel","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ERRORES EN F\u00d3RMULAS: #\u00a1NULO! - Excelfull.com<\/title>\n<meta name=\"description\" content=\"Los errores en f\u00f3rmulas #\u00a1NULO! se generan cuando se usa un operador de rango incorrecto. Habitualmente se genera debido a un error de tipeo.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ERRORES EN F\u00d3RMULAS: #\u00a1NULO! - Excelfull.com\" \/>\n<meta property=\"og:description\" content=\"Los errores en f\u00f3rmulas #\u00a1NULO! se generan cuando se usa un operador de rango incorrecto. Habitualmente se genera debido a un error de tipeo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-23T14:20:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-24T14:21:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!\",\"datePublished\":\"2024-01-23T14:20:53+00:00\",\"dateModified\":\"2024-01-24T14:21:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/\"},\"wordCount\":578,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png\",\"keywords\":[\"error en excel\"],\"articleSection\":[\"Errores\",\"Excel\",\"Excel B\u00e1sico\",\"F\u00f3rmulas y Funciones\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/\",\"url\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/\",\"name\":\"ERRORES EN F\u00d3RMULAS: #\u00a1NULO! - Excelfull.com\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png\",\"datePublished\":\"2024-01-23T14:20:53+00:00\",\"dateModified\":\"2024-01-24T14:21:49+00:00\",\"description\":\"Los errores en f\u00f3rmulas #\u00a1NULO! se generan cuando se usa un operador de rango incorrecto. Habitualmente se genera debido a un error de tipeo.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png\",\"width\":1280,\"height\":720,\"caption\":\"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel B\u00e1sico\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/curso-de-excel\/excel-basico\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"F\u00f3rmulas y Funciones\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/curso-de-excel\/excel-basico\/formulas-y-funciones\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Errores\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/excel-basico\/formulas-y-funciones\/errores\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ERRORES EN F\u00d3RMULAS: #\u00a1NULO! - Excelfull.com","description":"Los errores en f\u00f3rmulas #\u00a1NULO! se generan cuando se usa un operador de rango incorrecto. Habitualmente se genera debido a un error de tipeo.","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:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/","og_locale":"es_ES","og_type":"article","og_title":"ERRORES EN F\u00d3RMULAS: #\u00a1NULO! - Excelfull.com","og_description":"Los errores en f\u00f3rmulas #\u00a1NULO! se generan cuando se usa un operador de rango incorrecto. Habitualmente se genera debido a un error de tipeo.","og_url":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2024-01-23T14:20:53+00:00","article_modified_time":"2024-01-24T14:21:49+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!","datePublished":"2024-01-23T14:20:53+00:00","dateModified":"2024-01-24T14:21:49+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/"},"wordCount":578,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png","keywords":["error en excel"],"articleSection":["Errores","Excel","Excel B\u00e1sico","F\u00f3rmulas y Funciones"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/","url":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/","name":"ERRORES EN F\u00d3RMULAS: #\u00a1NULO! - Excelfull.com","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png","datePublished":"2024-01-23T14:20:53+00:00","dateModified":"2024-01-24T14:21:49+00:00","description":"Los errores en f\u00f3rmulas #\u00a1NULO! se generan cuando se usa un operador de rango incorrecto. Habitualmente se genera debido a un error de tipeo.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2024\/01\/ERRORES-EN-FORMULAS-\u00a1NULO.png","width":1280,"height":720,"caption":"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/errores-en-formulas-nulo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"Excel B\u00e1sico","item":"https:\/\/excelfull.com\/excel\/excel\/curso-de-excel\/excel-basico\/"},{"@type":"ListItem","position":4,"name":"F\u00f3rmulas y Funciones","item":"https:\/\/excelfull.com\/excel\/excel\/curso-de-excel\/excel-basico\/formulas-y-funciones\/"},{"@type":"ListItem","position":5,"name":"Errores","item":"https:\/\/excelfull.com\/excel\/excel\/excel-basico\/formulas-y-funciones\/errores\/"},{"@type":"ListItem","position":6,"name":"ERRORES EN F\u00d3RMULAS: #\u00a1NULO!"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/15269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=15269"}],"version-history":[{"count":3,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/15269\/revisions"}],"predecessor-version":[{"id":15276,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/15269\/revisions\/15276"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/15275"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=15269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=15269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=15269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}