{"id":27106,"date":"2017-11-29T10:41:51","date_gmt":"2017-11-29T16:41:51","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=27106"},"modified":"2024-12-30T17:15:09","modified_gmt":"2024-12-30T23:15:09","slug":"ocultar-errores-de-formula","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/ocultar-errores-de-formula.html","title":{"rendered":"Ocultar errores de formula"},"content":{"rendered":"<h1 style=\"text-align: center;\">Como ocultar errores de Formula en Excel<\/h1>\n<p>Te gustar\u00eda aprender los pasos de&nbsp;<strong>Como ocultar errores de formula<\/strong>&nbsp;en Excel?<\/p>\n<p>A menudo nos encontramos en excel con errores de formula generados por celdas sin valores.<\/p>\n<p>Por ejemplo, se genera por que a un el&nbsp;<strong>c\u00f3digo del producto no esta seleccionado<\/strong>&nbsp;o bien por que el cliente no esta seleccionado.<\/p>\n<p>Entonces, hay casos muy especiales en la que necesitamos ocultar estos errores de formula:<\/p>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Ocultar errores de formula\" width=\"440\" height=\"224\" title=\"6cc080ea89d838db2e73a2f8dc251c90.gif\" src=\"\/\/i.pinimg.com\/originals\/6c\/c0\/80\/6cc080ea89d838db2e73a2f8dc251c90.gif\" data-width=\"440\" data-height=\"224\" data-init-width=\"440\" data-init-height=\"224\" style=\"aspect-ratio: auto 440 \/ 224;\"><\/span><\/p>\n<p style=\"\">Hola Soy Roger P\u00e9rez y en este articulo voy a compartirte los pasos de como utilizar formato condicional para ocultar errores de formula.<\/p>\n<p style=\"\">Estas listo para ver este nuevo truco?<\/p>\n<p style=\"\">Comencemos:<\/p>\n<h2 style=\"text-align: center;\"><strong>Ocultar errores de Formula con formato condicional<\/strong><\/h2>\n<p style=\"\">Como primer paso, vamos abrir el archivo de pr\u00e1ctica, si a un no lo tienes, te invito a que lo descargues, te lo he dejado justo debajo de este video.<\/p>\n<p>Ya lo descargaste?<\/p>\n<p>Veamos el segundo paso:<\/p>\n<p>Dentro de este puedes notar que al seleccionar el segundo nombre de la lista desplegable se muestra un error de formula en la celda C10.<\/p>\n<p>Este error se genera por que no existe o no se encontr\u00f3 el cuarto elemento, en este caso el numero de tel\u00e9fono.<\/p>\n<p>Como no existe deseamos mostrar la celda en blanco y no mostrar errores .<\/p>\n<p>Para eso sigamos los siguientes pasos:<\/p>\n<h2><strong>Aplicando Formato Condicional para Ocultar errores de Formula<\/strong><\/h2>\n<ul>\n<li style=\"text-align: justify;\">En primer lugar, seleccionamos de la C7 hasta la C10 y nos ubicamos en formato condicional.<\/li>\n<li style=\"text-align: justify;\">Dentro de este seleccionamos nueva regla.<\/li>\n<li style=\"text-align: justify;\">Seleccionamos la opci\u00f3n: \u201c Utilice una formula que determine las celdas para aplicar formato\u201d.<\/li>\n<li style=\"text-align: justify;\">Dentro del cuadro de texto escribimos la siguiente formula: =ESERROR(C10).<\/li>\n<li style=\"text-align: justify;\">En seguida pulsamos clic en formato y nos ubicamos en la secci\u00f3n fuente.<\/li>\n<li style=\"text-align: justify;\">Dentro de este seleccionamos el color de fuente blanco.<\/li>\n<li style=\"text-align: justify;\">Ahora, pulsamos aceptar y nuevamente aceptar.<\/li>\n<\/ul>\n<p>Listo, puedes notar que el error ya no se muestra:<\/p>\n<p><span><img loading=\"lazy\" decoding=\"async\" alt=\"Ocultar errores de formula en excel\" width=\"596\" height=\"324\" title=\"a3cdf2de8733e300afecffa719c2fc47.gif\" src=\"\/\/i.pinimg.com\/originals\/a3\/cd\/f2\/a3cdf2de8733e300afecffa719c2fc47.gif\" data-width=\"596\" data-height=\"324\" data-init-width=\"596\" data-init-height=\"324\" style=\"aspect-ratio: auto 596 \/ 324;\"><\/span><\/p>\n<p style=\"text-align: justify;\">Que tal te pareci\u00f3 el articulo de hoy? te gusto?<\/p>\n<p style=\"text-align: justify;\">No olvides dejarme tu comentario al final de esta pagina, tambi\u00e9n te invito a compartir este contenido con tus amigo, para eso pulsa clic en el bot\u00f3n <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" rel=\"noopener\">compartir<\/a>:<\/p>\n<p>Para finalizar, no olvides visitar nuestra pagina de facebook&nbsp;<a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" rel=\"noopener\"><strong>pulsando clic&nbsp;<\/strong><\/a><b>aqu\u00ed<\/b>.<\/p>\n<p>Te recomendamos ver el articulo: \u00ab<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/resumir-datos-con-formula.html\" style=\"outline: none;\"><strong>Como Resumir Datos con Formula<\/strong><\/a>\u00ab.<\/p>\n<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">&nbsp;<\/span><a href=\"#comentario\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como ocultar errores de Formula en Excel Te gustar\u00eda aprender los pasos de&nbsp;Como ocultar errores de formula&nbsp;en Excel? A menudo nos encontramos en excel con errores de formula generados por celdas sin valores. Por ejemplo, se genera por que a un el&nbsp;c\u00f3digo del producto no esta seleccionado&nbsp;o bien por que el cliente no esta seleccionado. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":59528,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\"><h1 data-css=\"tve-u-160086d8a12\" style=\"text-align: center;\" class=\"\">Como ocultar errores de Formula en Excel<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19419d03815\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19419d03810\"><div class=\"thrv_wrapper thrv_text_element\">\t<p data-css=\"tve-u-16008721740\">Te gustar\u00eda aprender los pasos de&nbsp;<strong>Como ocultar errores de formula<\/strong>&nbsp;en Excel?<\/p><p data-css=\"tve-u-16008721740\">A menudo nos encontramos en excel con errores de formula generados por celdas sin valores.<\/p><p data-css=\"tve-u-16008721740\">Por ejemplo, se genera por que a un el&nbsp;<strong>c\u00f3digo del producto no esta seleccionado<\/strong>&nbsp;o bien por que el cliente no esta seleccionado.<\/p><p data-css=\"tve-u-1600876ecdf\">Entonces, hay casos muy especiales en la que necesitamos ocultar estos errores de formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1600874d171\" style=\"\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image\" alt=\"Ocultar errores de formula\" width=\"440\" height=\"224\" title=\"6cc080ea89d838db2e73a2f8dc251c90.gif\" src=\"\/\/i.pinimg.com\/originals\/6c\/c0\/80\/6cc080ea89d838db2e73a2f8dc251c90.gif\" data-width=\"440\" data-height=\"224\" data-init-width=\"440\" data-init-height=\"224\" style=\"aspect-ratio: auto 440 \/ 224;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19419d0e17d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19419d0e179\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Hola Soy Roger P\u00e9rez y en este articulo voy a compartirte los pasos de como utilizar formato condicional para ocultar errores de formula.<\/p><p style=\"\">Estas listo para ver este nuevo truco?<\/p><p style=\"\">Comencemos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-160087e86bb\" style=\"\"><h2 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-19419db357a\"><strong>Ocultar errores de Formula con formato condicional<\/strong><\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19419d1ffee\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19419d1ffe9\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Como primer paso, vamos abrir el archivo de pr\u00e1ctica, si a un no lo tienes, te invito a que lo descargues, te lo he dejado justo debajo de este video.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-button tve_ea_thrive_animation tve_anim_slide_top\" data-css=\"tve-u-1600880fae4\" style=\"\">\n<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Ocultar-errores-de-Formula.xlsx\" class=\"tcb-button-link tve_evt_manager_listen tve_et_tve-viewport\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;slide_top&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\" target=\"_blank\">\n<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqu\u00ed para Descargar el Archivo<\/span><\/span>\n<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19419d56d47\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19419d56d42\"><div class=\"thrv_wrapper thrv_text_element\">\t<p data-css=\"tve-u-160088a5925\">Ya lo descargaste?<\/p><p data-css=\"tve-u-160088a5925\">Veamos el segundo paso:<\/p><p data-css=\"tve-u-160088a5925\">Dentro de este puedes notar que al seleccionar el segundo nombre de la lista desplegable se muestra un error de formula en la celda C10.<\/p><p data-css=\"tve-u-160088a5925\">Este error se genera por que no existe o no se encontr\u00f3 el cuarto elemento, en este caso el numero de tel\u00e9fono.<\/p><p data-css=\"tve-u-160088a5925\">Como no existe deseamos mostrar la celda en blanco y no mostrar errores .<\/p><p data-css=\"tve-u-160088a5925\">Para eso sigamos los siguientes pasos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-160089bfdf3\" style=\"\"><h2 class=\"\"><strong>Aplicando Formato Condicional para Ocultar errores de Formula<\/strong><\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15f3acb25ec\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><ul class=\"\"><li class=\"\" data-css=\"tve-u-160089fc9e6\" style=\"text-align: justify;\">En primer lugar, seleccionamos de la C7 hasta la C10 y nos ubicamos en formato condicional.<\/li><li class=\"\" data-css=\"tve-u-160089fc9e6\" style=\"text-align: justify;\">Dentro de este seleccionamos nueva regla.<\/li><li class=\"\" data-css=\"tve-u-160089fc9e6\" style=\"text-align: justify;\">Seleccionamos la opci\u00f3n: \u201c Utilice una formula que determine las celdas para aplicar formato\u201d.<\/li><li class=\"\" data-css=\"tve-u-160089fc9e6\" style=\"text-align: justify;\">Dentro del cuadro de texto escribimos la siguiente formula: =ESERROR(C10).<\/li><li class=\"\" data-css=\"tve-u-160089fc9e6\" style=\"text-align: justify;\">En seguida pulsamos clic en formato y nos ubicamos en la secci\u00f3n fuente.<\/li><li class=\"\" data-css=\"tve-u-160089fc9e6\" style=\"text-align: justify;\">Dentro de este seleccionamos el color de fuente blanco.<\/li><li class=\"\" data-css=\"tve-u-160089fc9e6\" style=\"text-align: justify;\">Ahora, pulsamos aceptar y nuevamente aceptar.<\/li><\/ul><p data-css=\"tve-u-16008a2c40d\">Listo, puedes notar que el error ya no se muestra:<\/p><\/div><\/div><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-16008a4cf4f\"><span class=\"tve_image_frame\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image\" alt=\"Ocultar errores de formula en excel\" width=\"596\" height=\"324\" title=\"a3cdf2de8733e300afecffa719c2fc47.gif\" src=\"\/\/i.pinimg.com\/originals\/a3\/cd\/f2\/a3cdf2de8733e300afecffa719c2fc47.gif\" data-width=\"596\" data-height=\"324\" data-init-width=\"596\" data-init-height=\"324\" style=\"aspect-ratio: auto 596 \/ 324;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16008a7fb5b\"><div class=\"tve-content-box-background\"><\/div><div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-15f3acb25ec\"><div class=\"thrv_wrapper thrv-columns\" style=\"--tcb-col-el-width: 683.938;\"><div class=\"tcb-flex-row tcb--cols--1\"><div class=\"tcb-flex-col\"><div class=\"tcb-col tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16008a67ca1\" style=\"text-align: justify;\">Que tal te pareci\u00f3 el articulo de hoy? te gusto?<\/p><p data-css=\"tve-u-16008a67ca1\" style=\"text-align: justify;\">No olvides dejarme tu comentario al final de esta pagina, tambi\u00e9n te invito a compartir este contenido con tus amigo, para eso pulsa clic en el bot\u00f3n <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\">compartir<\/a>:<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social tve_share_left\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-16008a8a6a6\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb tve-prevent-content-edit\">\n<div class=\"tve_s_item tve_s_fb_share thrv_wrapper tve_share_item\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/ocultar-errores-de-formula.html\" data-label=\"Compartir\" data-css=\"tve-u-19419d7bc68\">\n<a href=\"javascript:void(0)\" class=\"tve_s_link\"><span class=\"tve_s_icon thrv-svg-icon\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"tcb-facebook\" viewBox=\"0 0 16 28\"><path d=\"M14.984 0.187v4.125h-2.453q-1.344 0-1.813 0.562t-0.469 1.687v2.953h4.578l-0.609 4.625h-3.969v11.859h-4.781v-11.859h-3.984v-4.625h3.984v-3.406q0-2.906 1.625-4.508t4.328-1.602q2.297 0 3.563 0.187z\"><\/path><\/svg><\/span><span class=\"tve_s_text\">Compartir<\/span><span class=\"tve_s_count\">0<\/span><\/a>\n<\/div>\n<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19419d825f8\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19419d825f3\"><div class=\"thrv_wrapper thrv_text_element\">\t<p data-css=\"tve-u-16008ac374f\">Para finalizar, no olvides visitar nuestra pagina de facebook&nbsp;<a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\"><strong>pulsando clic&nbsp;<\/strong><\/a><font color=\"#24447b\"><b>aqu\u00ed<\/b><\/font>.<\/p><p data-css=\"tve-u-16008ac3751\">Te recomendamos ver el articulo: \"<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/resumir-datos-con-formula.html\" class=\"\" style=\"outline: none;\"><strong>Como Resumir Datos con Formula<\/strong><\/a>\".<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19419d89e30\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19419d89e2e\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19419d89e31\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19419d89e32\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-19419d89e33\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-19419d89e34\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-19419d89e35\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) [data-css=\"tve-u-16008ac3751\"] { color: rgb(6, 0, 0) !important; }:not(#tve) [data-css=\"tve-u-16008ac374f\"] { color: rgb(6, 0, 0) !important; }[data-css=\"tve-u-16008a8a6a6\"] { float: none; margin-left: auto !important; margin-right: auto !important; margin-top: -47px !important; }[data-css=\"tve-u-16008a7fb5b\"] { margin-top: -24px !important; }:not(#tve) [data-css=\"tve-u-16008a67ca1\"] { color: rgb(4, 0, 0) !important; }[data-css=\"tve-u-16008a4cf4f\"] + div { clear: none; }[data-css=\"tve-u-16008a4cf4f\"] { float: none; margin-left: auto; margin-right: auto; width: 596px; }:not(#tve) [data-css=\"tve-u-16008a2c40d\"] { color: rgb(7, 0, 0) !important; }:not(#tve) [data-css=\"tve-u-160089fc9e6\"] { color: rgb(6, 0, 0) !important; }[data-css=\"tve-u-160089bfdf3\"] { margin-top: 0px !important; }:not(#tve) [data-css=\"tve-u-160088a5925\"] { color: rgb(6, 0, 0) !important; }[data-css=\"tve-u-1600880fae4\"] .tcb-button-link { box-shadow: rgba(16, 217, 115, 0.4) -9px 0px 8px 7px; }[data-css=\"tve-u-1600880fae4\"] { margin-top: 0px !important; }[data-css=\"tve-u-160087e86bb\"] { margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-1600876ecdf\"] { color: rgb(4, 1, 1) !important; }[data-css=\"tve-u-1600874d171\"] + div { clear: none; }[data-css=\"tve-u-1600874d171\"] { float: none; margin-left: auto; margin-right: auto; width: 440px; margin-top: 0px !important; }:not(#tve) [data-css=\"tve-u-16008721740\"] { color: rgb(6, 0, 0) !important; }:not(#tve) [data-css=\"tve-u-160086d8a12\"] { font-size: 42px !important; color: rgb(248, 6, 6) !important; }[data-css=\"tve-u-15f3acb25ec\"] p { margin: 0px 0px 15px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-15f3acb25ec\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f3acb25ec\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f3acb25ec\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-15f3acb25ec\"] address { line-height: 1.45em; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19419d03810\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d03810\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19419d03810\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19419d03815\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19419d0e179\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d0e179\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19419d0e179\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19419d0e17d\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19419d1ffe9\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d1ffe9\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19419d1ffe9\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19419d1ffee\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19419d56d42\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d56d42\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19419d56d42\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19419d56d47\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19419d825f3\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d825f3\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19419d825f3\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19419d825f8\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19419d89e2e\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19419d89e2e\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19419d89e2e\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19419d89e30\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-19419d89e31\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-19419d89e32\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-19419d89e33\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-19419d89e34\"] { --tcb-text-highlight-color: rgb(30,184,76) !important; }[data-css=\"tve-u-19419d89e35\"] { --tcb-text-highlight-color: transparent !important; }:not(#tve) [data-css=\"tve-u-19419db357a\"] { text-transform: none !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[72],"tags":[3526,409,3525],"class_list":["post-27106","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas-excel","tag-errores-de-formula","tag-ocultar-errores","tag-ocultar-errores-de-formula","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/27106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=27106"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/27106\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/59528"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=27106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=27106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=27106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}