{"id":47378,"date":"2021-12-06T14:18:25","date_gmt":"2021-12-06T20:18:25","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=47378"},"modified":"2025-01-03T17:56:00","modified_gmt":"2025-01-03T23:56:00","slug":"funcion-let","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/funcion-let.html","title":{"rendered":"Funcion Let"},"content":{"rendered":"<h1 style=\"text-align: center;\">Como Aplicar la Funcion Let<\/h1>\n<p>Estas listo para aprender a aplicar la Funci\u00f3n LET paso a paso ? Te gustar\u00eda conocer la sintaxis y la ventaja de utilizar esta funci\u00f3n ?<\/p>\n<p><span><img decoding=\"async\" alt=\"Funcion LET\" data-id=\"47679\" width=\"481\" data-init-width=\"481\" height=\"184\" data-init-height=\"184\" title=\"La funcion LET (1)\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/01\/La-funcion-LET-1.png\" data-width=\"481\" data-height=\"184\" style=\"aspect-ratio: auto 481 \/ 184;\"><\/span><\/p>\n<p>Hola! Soy Roger Perez y en este articulo te voy a compartir varios ejemplos de como utilizar la funcion LET y aplicarlo en tus labores diarios.<\/p>\n<p>Estas listo para comenzar?<\/p>\n<p>Veamos:<\/p>\n<h2 style=\"text-align: center;\">Sintaxis de la Funcion LET<\/h2>\n<p>Para comenzar a utilizar la funcion LET, debes de entender bien la sintaxis de esta funcion.<\/p>\n<p>Veamos su sintaxis:<\/p>\n<blockquote><p><em><strong>=LET(Nombre1;Nombre_valor1;Calculo)<\/strong><\/em><\/p><\/blockquote>\n<p>A continuacion los detalles de cada sintaxis:<\/p>\n<ul>\n<li><span><strong>Nombre1<\/strong> = Aqui debes de reflejar el nombre de la variable (X, Y, Z).<\/span><\/li>\n<li><span><strong>Valor_nombre <\/strong>= Aqui debes de escribir el valor de la variable.<\/span><\/li>\n<li><span><strong>Calculo<\/strong> = Aqui se debe escribir el calculo a realizar (X+5).<\/span><\/li>\n<\/ul>\n<p>Muy bien, ahora que conoces la sintaxis, te voy a compartir dos ejemplos de como utilizar la funcion.<\/p>\n<h2 style=\"text-align: center;\">Considerando una expreci\u00f3n simple con la Funcion LET &#8211; Ejemplo 1<\/h2>\n<p>A continuacion vamos a ver el primer ejemplo considerando la exprecion simple \u00abSUMA(x;2)\u00bb, donde x es una variable con nombre a la que se puede asignar un valor, en este caso se le asignara el valor 7.<\/p>\n<p>Entonces como a de quedar la formula ?<\/p>\n<p>Esta es la formula: =LET(X;7;SUMA(X;2)<\/p>\n<p>Al escribir esta formula dentro de una celda te devolvera 9, a continuaci\u00f3n te dejo una imagen animada:<\/p>\n<p><span><img decoding=\"async\" alt=\"Funcion Let\" data-id=\"47672\" width=\"381\" data-init-width=\"394\" height=\"182\" data-init-height=\"188\" title=\"Ejemplo Funcion Let GIF\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/01\/Ejemplo-Funcion-Let-GIF.gif\" data-width=\"381\" data-height=\"182\" style=\"aspect-ratio: auto 394 \/ 188;\"><\/span><\/p>\n<p>En esta formula, el resultado es nueve, por el valor de la variable es 7, entonces facilmente la suma se completa sumando 7+2 = 9.<\/p>\n<p>Ahora veamos otro ejemplo:<\/p>\n<h2 style=\"text-align: center;\">Reduciendo la repeticion de Funciones en una Formula con LET<\/h2>\n<p style=\"text-align: justify;\">En este ejemplo 2, vamos a ver como utilizar la funcion LET ,para disminuir la repeticion de operacion en las formulas.<\/p>\n<p style=\"text-align: justify;\">Para comenzar, te invito a descargar el archivo excel, dentro de este te he dejado una tabla con la cual vamos a realizar el ejercicio:<\/p>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/?smd_process_download=1&amp;download_id=47686\" target=\"_blank\"><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/?smd_process_download=1&amp;download_id=47686\" target=\"_blank\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p>\n<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p>\n<p style=\"\">Ya descargaste el archivo ? Si ya lo has descagado ahora tan solo abrelo.<\/p>\n<p style=\"\">Dentro de este, en la hoja ejemplo2 podras ver que tenemos una tabla, desde esta tabla, vamos a filtrar los datos de miguel y color un guion en las celdas que esten vacios.<\/p>\n<h3 style=\"text-align: center;\">Veamos la primera opcion:<\/h3>\n<p style=\"\">Dentro de este vamos a escribir la siguiente formula dentro de la celda F2:<\/p>\n<p style=\"\"><em><strong>=SI(ESBLANCO(FILTRAR(A2:D8;A2:A8=\u00bbMiguel\u00bb));\u00bb-\u00ab;<\/strong><\/em><em><strong>FILTRAR(A2:D8;A2:A8=\u00bbMiguel\u00bb))<\/strong><\/em><\/p>\n<p style=\"\">Al pulsar enter, podras notar que todos los datos de Miguel se rellenan automaticamente, sin embargo, dentro de la Formula desbordada, puedes notar que se repite 2 veces una misma fucion para conseguir el resultado deseado: FILTRAR(A2:D8;A2:A8=\u00bbMiguel.<\/p>\n<p style=\"\">Pero exite una desventaja, al utilizar dos veces una misma funcion, una misma operacion, corremos el riesgo de cometer errores.<\/p>\n<p style=\"\">Y ademas requiere que excel realice el calculo dos veces y esto puede probocar que disminuya el rendimiento.<\/p>\n<p style=\"\">Al utilizar la funcion LET, no es necesario repetir dos veces una misma operacion.<\/p>\n<h3 style=\"text-align: center;\">Veamos la segun opcion: Utilizando LET<\/h3>\n<p style=\"\">Para comenzar, nos vamos a la celda F8 y escribimos la siguiente formula:<\/p>\n<p style=\"\"><em><strong>=LET(Criteriodefiltro;\u00bbMiguel\u00bb;Rangoafiltrar;FILTRAR(A2:D8;A2:A8=Criteriodefiltro);SI(ESBLANCO(Rangoafiltrar);\u00bb-\u00ab;Rangoafiltrar))<\/strong><\/em><\/p>\n<p style=\"\"><em><strong><\/strong><\/em>Pulsamos enter y listo, puedes notar que dentro dentro de esta formula, no se repite funciones y calculas para obtener el resultado deseado.<\/p>\n<p style=\"\">Que tal te parecio el articulo de hoy ? Si tienes algun comentario sobre el articulo, no dudes en escribirnos:<\/p>\n<p>No olvides compartir este articulo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">facebook<\/a>, para que ellos tambien puedan aprender sobre la funcion LET, para eso pulsa clic en el boton:<\/p>\n<p>Cualquier duda o pregunta, tan solo escribenos en el chat o bien a rogerperez@aplicaexcelcontable.com.<\/p>\n<p>Saludos,<\/p>\n<p><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como Aplicar la Funcion Let Estas listo para aprender a aplicar la Funci\u00f3n LET paso a paso ? Te gustar\u00eda conocer la sintaxis y la ventaja de utilizar esta funci\u00f3n ? Hola! Soy Roger Perez y en este articulo te voy a compartir varios ejemplos de como utilizar la funcion LET y aplicarlo en tus [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":47672,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\"><h1 style=\"text-align: center;\" class=\"\" data-css=\"tve-u-17e1b2955c5\">Como Aplicar la Funcion Let<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17d916f3e06\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d916f3e00\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Estas listo para aprender a aplicar la Funci\u00f3n LET paso a paso ? Te gustar\u00eda conocer la sintaxis y la ventaja de utilizar esta funci\u00f3n ?<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-17e1b2366f5\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image tcb-moved-image wp-image-47679\" alt=\"Funcion LET\" data-id=\"47679\" width=\"481\" data-init-width=\"481\" height=\"184\" data-init-height=\"184\" title=\"La funcion LET (1)\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/01\/La-funcion-LET-1.png\" data-width=\"481\" data-height=\"184\" style=\"aspect-ratio: auto 481 \/ 184;\" data-css=\"tve-u-17e1b23708b\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17e1b267d15\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d916f3e00\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Hola! Soy Roger Perez y en este articulo te voy a compartir varios ejemplos de como utilizar la funcion LET y aplicarlo en tus labores diarios.<\/p><p>Estas listo para comenzar?<\/p><p>Veamos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 style=\"text-align: center;\" data-css=\"tve-u-17e1b282888\" class=\"\">Sintaxis de la Funcion LET<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17e1b267d15\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d916f3e00\"><div class=\"thrv_wrapper thrv_text_element\"><p>Para comenzar a utilizar la funcion LET, debes de entender bien la sintaxis de esta funcion.<\/p><p>Veamos su sintaxis:<\/p><blockquote class=\"\"><em><strong>=LET(Nombre1;Nombre_valor1;Calculo)<\/strong><\/em><\/blockquote><p>A continuacion los detalles de cada sintaxis:<\/p><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-css=\"tve-u-17e1b3e3728\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-17e1b3cb044\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-17e1b39c60a\"><strong>Nombre1<\/strong> = Aqui debes de reflejar el nombre de la variable (X, Y, Z).<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-17e1b3cb044\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-17e1b39c60a\"><strong>Valor_nombre <\/strong>= Aqui debes de escribir el valor de la variable.<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-17e1b3cb044\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-17e1b39c60a\"><strong>Calculo<\/strong> = Aqui se debe escribir el calculo a realizar (X+5).<\/span><\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17e1b3efe21\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d916f3e00\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Muy bien, ahora que conoces la sintaxis, te voy a compartir dos ejemplos de como utilizar la funcion.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 style=\"text-align: center;\" data-css=\"tve-u-17e1b43511f\" class=\"\">Considerando una expreci\u00f3n simple con la Funcion LET - Ejemplo 1<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17e1b3efe21\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d916f3e00\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>A continuacion vamos a ver el primer ejemplo considerando la exprecion simple \"SUMA(x;2)\", donde x es una variable con nombre a la que se puede asignar un valor, en este caso se le asignara el valor 7.<\/p><p>Entonces como a de quedar la formula ?<\/p><p>Esta es la formula: =LET(X;7;SUMA(X;2)<\/p><p>Al escribir esta formula dentro de una celda te devolvera 9, a continuaci\u00f3n te dejo una imagen animada:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-17e1bf55f27\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-47672\" alt=\"Funcion Let\" data-id=\"47672\" width=\"381\" data-init-width=\"394\" height=\"182\" data-init-height=\"188\" title=\"Ejemplo Funcion Let GIF\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/01\/Ejemplo-Funcion-Let-GIF.gif\" data-width=\"381\" data-height=\"182\" style=\"aspect-ratio: auto 394 \/ 188;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17e1b267d15\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d916f3e00\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>En esta formula, el resultado es nueve, por el valor de la variable es 7, entonces facilmente la suma se completa sumando 7+2 = 9.<\/p><p>Ahora veamos otro ejemplo:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 style=\"text-align: center;\" data-css=\"tve-u-17e20fcdc6e\" class=\"\">Reduciendo la repeticion de Funciones en una Formula con LET<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17e1b267d15\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17d916f3e00\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: justify;\">En este ejemplo 2, vamos a ver como utilizar la funcion LET ,para disminuir la repeticion de operacion en las formulas.<\/p><p style=\"text-align: justify;\">Para comenzar, te invito a descargar el archivo excel, dentro de este te he dejado una tabla con la cual vamos a realizar el ejercicio:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17e223ed673\" style=\"\" id=\"descarga\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-17e223ed675\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17e223ed66b\"><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-17e223ed671\" style=\"--tcb-col-el-width: 645.938;\"><div class=\"tcb-flex-row v-2 tcb-resized tcb--cols--2\"><div class=\"tcb-flex-col\" data-css=\"tve-u-17e223ed666\" style=\"\"><div class=\"tcb-col\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/?smd_process_download=1&amp;download_id=47686\" target=\"_blank\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-17e223ed663\" style=\"\" data-link-wrap=\"true\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-file-excel-solid\" data-name=\"\" style=\"\"><path d=\"M224 136V0H24C10.7 0 0 10.7 0 24v464c0 13.3 10.7 24 24 24h336c13.3 0 24-10.7 24-24V160H248c-13.2 0-24-10.8-24-24zm60.1 106.5L224 336l60.1 93.5c5.1 8-.6 18.5-10.1 18.5h-34.9c-4.4 0-8.5-2.4-10.6-6.3C208.9 405.5 192 373 192 373c-6.4 14.8-10 20-36.6 68.8-2.1 3.9-6.1 6.3-10.5 6.3H110c-9.5 0-15.2-10.5-10.1-18.5l60.3-93.5-60.3-93.5c-5.2-8 .6-18.5 10.1-18.5h34.8c4.4 0 8.5 2.4 10.6 6.3 26.1 48.8 20 33.6 36.6 68.5 0 0 6.1-11.7 36.6-68.5 2.1-3.9 6.2-6.3 10.6-6.3H274c9.5-.1 15.2 10.4 10.1 18.4zM384 121.9v6.1H256V0h6.1c6.4 0 12.5 2.5 17 7l97.9 98c4.5 4.5 7 10.6 7 16.9z\"><\/path><\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-17e223ed668\" style=\"\"><div class=\"tcb-col\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: center;\" data-css=\"tve-u-17e223ed66a\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/?smd_process_download=1&amp;download_id=47686\" target=\"_blank\" class=\"\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p><\/div><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p><\/div><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root tve-viewport-triggered\" data-css=\"tve-u-17e223ed677\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-hand-point-up-solid\" data-name=\"\" style=\"\"><path d=\"M135.652 0c23.625 0 43.826 20.65 43.826 44.8v99.851c17.048-16.34 49.766-18.346 70.944 6.299 22.829-14.288 53.017-2.147 62.315 16.45C361.878 158.426 384 189.346 384 240c0 2.746-.203 13.276-.195 16 .168 61.971-31.065 76.894-38.315 123.731C343.683 391.404 333.599 400 321.786 400H150.261l-.001-.002c-18.366-.011-35.889-10.607-43.845-28.464C93.421 342.648 57.377 276.122 29.092 264 10.897 256.203.008 242.616 0 224c-.014-34.222 35.098-57.752 66.908-44.119 8.359 3.583 16.67 8.312 24.918 14.153V44.8c0-23.45 20.543-44.8 43.826-44.8zM136 416h192c13.255 0 24 10.745 24 24v48c0 13.255-10.745 24-24 24H136c-13.255 0-24-10.745-24-24v-48c0-13.255 10.745-24 24-24zm168 28c-11.046 0-20 8.954-20 20s8.954 20 20 20 20-8.954 20-20-8.954-20-20-20z\"><\/path><\/svg><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17e2265d144\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17fc353ed83\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Ya descargaste el archivo ? Si ya lo has descagado ahora tan solo abrelo.<\/p><p style=\"\">Dentro de este, en la hoja ejemplo2 podras ver que tenemos una tabla, desde esta tabla, vamos a filtrar los datos de miguel y color un guion en las celdas que esten vacios.<\/p><h3 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-17e226c8b91\">Veamos la primera opcion:<\/h3><p style=\"\">Dentro de este vamos a escribir la siguiente formula dentro de la celda F2:<\/p><p style=\"\"><em><strong>=SI(ESBLANCO(FILTRAR(A2:D8;A2:A8=\"Miguel\"));\"-\";<\/strong><\/em>\n<em><strong>FILTRAR(A2:D8;A2:A8=\"Miguel\"))<\/strong><\/em><\/p><p style=\"\">Al pulsar enter, podras notar que todos los datos de Miguel se rellenan automaticamente, sin embargo, dentro de la Formula desbordada, puedes notar que se repite 2 veces una misma fucion para conseguir el resultado deseado: FILTRAR(A2:D8;A2:A8=\"Miguel.<\/p><p style=\"\">Pero exite una desventaja, al utilizar dos veces una misma funcion, una misma operacion, corremos el riesgo de cometer errores.<\/p><p style=\"\">Y ademas requiere que excel realice el calculo dos veces y esto puede probocar que disminuya el rendimiento.<\/p><p style=\"\">Al utilizar la funcion LET, no es necesario repetir dos veces una misma operacion.<\/p><h3 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-17e226cf218\">Veamos la segun opcion: Utilizando LET<\/h3><p style=\"\">Para comenzar, nos vamos a la celda F8 y escribimos la siguiente formula:<\/p><p style=\"\"><em><strong>=LET(Criteriodefiltro;\"Miguel\";Rangoafiltrar;FILTRAR(A2:D8;A2:A8=Criteriodefiltro);SI(ESBLANCO(Rangoafiltrar);\"-\";Rangoafiltrar))<\/strong><\/em><\/p><p style=\"\"><em><strong><\/strong><\/em>Pulsamos enter y listo, puedes notar que dentro dentro de esta formula, no se repite funciones y calculas para obtener el resultado deseado.<\/p><p style=\"\">Que tal te parecio el articulo de hoy ? Si tienes algun comentario sobre el articulo, no dudes en escribirnos:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-17fc3506737\"><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-17fc3506735\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"rgb(241, 11, 25)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"#comentario\" class=\"tcb-button-link tcb-plain-text tve-jump-scroll\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\" style=\"\" data-css=\"tve-u-17fc3506738\">Clic aqu\u00ed para comentar<\/span><\/span>\n\t<\/a>\n<\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17fc350d803\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17fc350d800\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>No olvides compartir este articulo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\">facebook<\/a>, para que ellos tambien puedan aprender sobre la funcion LET, para eso pulsa clic en el boton:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-17fc351f318\"><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-device-config=\"{&quot;desktop&quot;:{&quot;isFullWidth&quot;:&quot;0&quot;},&quot;tablet&quot;:{},&quot;mobile&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;,&quot;showCount&quot;:&quot;0&quot;}}\" data-css=\"tve-u-17fc351f316\" style=\"\">\n<div class=\"tve_social_items tve_social_custom tve-prevent-content-edit tve_style_6 tve_social_itb\">\n\t\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_fb_share tve_share_item\" data-s=\"fb_share\" data-href=\"{tcb_post_url}\" data-label=\"Compartir\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 264 512\" data-id=\"icon-fb\" data-name=\"\">\n            <path d=\"M76.7 512V283H0v-91h76.7v-71.7C76.7 42.4 124.3 0 193.8 0c33.3 0 61.9 2.5 70.2 3.6V85h-48.2c-37.8 0-45.1 18-45.1 44.3V192H256l-11.7 91h-73.6v229\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text tve-froala\">Compartir<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_t_share tve_share_item\" data-s=\"t_share\" data-href=\"{tcb_post_url}\" data-label=\"Tweet\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-t\" data-name=\"\">\n            <path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text tve-froala\">Tweet<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_pin_share tve_share_item\" data-s=\"pin_share\" data-href=\"{tcb_post_url}\" data-label=\"Pin\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-pin\" data-name=\"\">\n            <path d=\"M204 6.5C101.4 6.5 0 74.9 0 185.6 0 256 39.6 296 63.6 296c9.9 0 15.6-27.6 15.6-35.4 0-9.3-23.7-29.1-23.7-67.8 0-80.4 61.2-137.4 140.4-137.4 68.1 0 118.5 38.7 118.5 109.8 0 53.1-21.3 152.7-90.3 152.7-24.9 0-46.2-18-46.2-43.8 0-37.8 26.4-74.4 26.4-113.4 0-66.2-93.9-54.2-93.9 25.8 0 16.8 2.1 35.4 9.6 50.7-13.8 59.4-42 147.9-42 209.1 0 18.9 2.7 37.5 4.5 56.4 3.4 3.8 1.7 3.4 6.9 1.5 50.4-69 48.6-82.5 71.4-172.8 12.3 23.4 44.1 36 69.3 36 106.2 0 153.9-103.5 153.9-196.8C384 71.3 298.2 6.5 204 6.5z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Pin<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\n<\/div>\n<\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-17fc3522667\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17fc3522664\"><div class=\"thrv_wrapper thrv_text_element\">\t<p>Cualquier duda o pregunta, tan solo escribenos en el chat o bien a rogerperez@aplicaexcelcontable.com.<\/p><p>Saludos,<\/p><p><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-divider\" data-style-d=\"tve_sep-1\" data-thickness-d=\"3\" data-color-d=\"rgb(66, 66, 66)\" data-css=\"tve-u-17e2254dafa\">\n\t<hr class=\"tve_sep tve_sep-1\" style=\"\">\n<\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17d916f3e00\"] { --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-17d916f3e00\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17d916f3e00\"] 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-17d916f3e00\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-17d916f3e06\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 10px !important; }[data-css=\"tve-u-17e1b2366f5\"] { width: 481px; --tve-alignment: center; float: none; --tve-border-radius: 30px; border-radius: 30px; overflow: hidden; margin-left: auto !important; margin-right: auto !important; margin-top: 0px !important; }[data-css=\"tve-u-17e1b267d15\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 10px !important; padding-top: 10px !important; }:not(#tve) [data-css=\"tve-u-17e1b282888\"] { color: rgb(7, 0, 0) !important; --tcb-applied-color: rgb(7,0,0) !important; --tve-applied-color: rgb(7,0,0) !important; }:not(#tve) [data-css=\"tve-u-17e1b2955c5\"] { color: rgb(7, 0, 0) !important; --tcb-applied-color: rgb(7,0,0) !important; --tve-applied-color: rgb(7,0,0) !important; }[data-css=\"tve-u-17e1b3e3728\"] { margin-bottom: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-17e1b3efe21\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 10px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-17e1b43511f\"] { color: rgb(6, 0, 0) !important; --tcb-applied-color: rgb(6,0,0) !important; --tve-applied-color: rgb(6,0,0) !important; font-size: 40px !important; }[data-css=\"tve-u-17e1bf55f27\"] { width: 394px; --tve-alignment: center; float: none; --tve-border-width: 7px; border: 7px dotted rgb(174, 13, 13); --tve-applied-border: 7px dotted rgb(174,13,13); --tve-border-radius: 30px; border-radius: 30px; overflow: hidden; margin: 0px auto !important; }:not(#tve) [data-css=\"tve-u-17e20fcdc6e\"] { font-size: 40px !important; color: rgb(4, 0, 0) !important; --tcb-applied-color: rgb(4,0,0) !important; --tve-applied-color: rgb(4,0,0) !important; }[data-css=\"tve-u-17e223ed663\"] { font-size: 84px; margin-left: auto; margin-right: auto; --tcb-local-color-icon: rgb(4,228,38); --tcb-local-color-var: rgb(4,228,38); --tve-icon-size: 84px; --tcb-icon-rotation-angle: -22deg; width: 84px; height: 84px; }:not(#tve) [data-css=\"tve-u-17e223ed663\"] > :first-child { color: rgb(4, 228, 38); --tve-applied-color: rgb(4,228,38); }[data-css=\"tve-u-17e223ed666\"] { max-width: 18.1%; }[data-css=\"tve-u-17e223ed668\"] { max-width: 81.9%; }:not(#tve) [data-css=\"tve-u-17e223ed66a\"] { font-size: 21px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17e223ed66b\"] h6 { color: var(--tve-color,rgb(0,3,6)); --tve-applied-color: var$(--tve-color,rgb(0,3,6)); --tcb-applied-color: rgb(0,3,6); }[data-css=\"tve-u-17e223ed66b\"] { --tve-color: rgb(0,3,6); --tve-applied---tve-color: rgb(0,3,6); text-align: justify; }[data-css=\"tve-u-17e223ed66b\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-17e223ed671\"] { margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-17e223ed673\"] { margin-top: 0px !important; padding-top: 0px !important; padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-17e223ed675\"] { --tve-border-width: 6px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; border: 6px dashed rgb(234, 194, 13) !important; --tve-applied-border: 6px dashed rgb(234,194,13) !important; }[data-css=\"tve-u-17e223ed677\"] { font-size: 60px; --tcb-local-color-icon: rgb(227,12,38); --tcb-local-color-var: rgb(227,12,38); --tve-icon-size: 60px; float: none; z-index: 3; position: relative; --tve-alignment: center; margin: -109px auto 0px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-17e223ed677\"] > :first-child { color: rgb(227, 12, 38); --tve-applied-color: rgb(227,12,38); }[data-css=\"tve-u-17e2254dafa\"] .tve_sep { width: 100%; border-width: 3px !important; border-color: rgb(66, 66, 66) !important; }[data-css=\"tve-u-17e2265d144\"] { margin-top: 20px !important; margin-bottom: 10px !important; padding-bottom: 10px !important; padding-top: 10px !important; }:not(#tve) [data-css=\"tve-u-17e226c8b91\"] { font-size: 35px !important; color: rgb(6, 0, 0) !important; --tcb-applied-color: rgb(6,0,0) !important; --tve-applied-color: rgb(6,0,0) !important; }:not(#tve) [data-css=\"tve-u-17e226cf218\"] { font-size: 35px !important; }[data-css=\"tve-u-17fc3506735\"] .tcb-button-link { letter-spacing: 2px; background-image: linear-gradient(var(--tcb-local-color-62516,rgb(19,114,211)),var(--tcb-local-color-62516,rgb(19,114,211))); --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-62516,rgb(19,114,211)),var$(--tcb-local-color-62516,rgb(19,114,211))); background-size: auto; background-attachment: scroll; border-radius: 5px; overflow: hidden; padding: 18px; background-position: 50% 50%; background-repeat: no-repeat; }[data-css=\"tve-u-17fc3506735\"] .tcb-button-link span { color: rgb(255, 255, 255); --tcb-applied-color: #fff; }[data-css=\"tve-u-17fc3506735\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; --tcb-local-color-62516: rgb(241,11,25) !important; margin-top: -14px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-17fc3506737\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] h6 { color: var(--tve-color,rgb(6,0,0)); --tve-applied-color: var$(--tve-color,rgb(6,0,0)); --tcb-applied-color: rgb(6,0,0); }[data-css=\"tve-u-17fc350d800\"] { --tve-color: rgb(6,0,0); --tve-applied---tve-color: rgb(6,0,0); text-align: justify; --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc350d800\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17fc350d800\"] p { padding: 0px 0px 12px !important; margin: 0px !important; }[data-css=\"tve-u-17fc350d800\"] h1 { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-17fc350d800\"] h2 { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-17fc350d800\"] h3 { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-17fc350d803\"] { margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-17fc351f316\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-17fc351f318\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] h6 { color: var(--tve-color,rgb(6,0,0)); --tve-applied-color: var$(--tve-color,rgb(6,0,0)); --tcb-applied-color: rgb(6,0,0); }[data-css=\"tve-u-17fc3522664\"] { --tve-color: rgb(6,0,0); --tve-applied---tve-color: rgb(6,0,0); text-align: justify; --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc3522664\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17fc3522664\"] p { padding: 0px 0px 12px !important; margin: 0px !important; }[data-css=\"tve-u-17fc3522664\"] h1 { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-17fc3522664\"] h2 { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-17fc3522664\"] h3 { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-17fc3522667\"] { margin-bottom: 0px !important; margin-top: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-17fc353ed83\"] { --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-17fc353ed83\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17fc353ed83\"] 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-17fc353ed83\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }.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; }}@media (max-width: 767px){:not(#tve) [data-css=\"tve-u-17fc3506738\"] { font-size: 16px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"0","_tve_footer":"0"},"categories":[7656],"tags":[318,7517,7518,7514,7513,7515,7516],"class_list":["post-47378","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-funciones-excel","tag-aplica-excel-contable","tag-aplicar-let-en-excel","tag-excelycontabilidad","tag-formula-let","tag-funcion-let","tag-sintaxis-let","tag-utilizar-let-en-excel","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/47378","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=47378"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/47378\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/47672"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=47378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=47378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=47378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}