{"id":40779,"date":"2019-02-04T06:41:30","date_gmt":"2019-02-04T12:41:30","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=40779"},"modified":"2025-03-11T14:25:03","modified_gmt":"2025-03-11T20:25:03","slug":"formulas-hoja-base-de-tu-app-fi","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/formulas-hoja-base-de-tu-app-fi.html","title":{"rendered":"Formulas hoja base de tu App FI"},"content":{"rendered":"<h1 style=\"text-align: center;\">Formulas Hoja Base de tu App FI<\/h1>\n<p style=\"text-align: justify;\">Estas listo para aplicar las formulas Hoja Base de tu App FI (Facturacion e Inventario) b\u00e1sico?<\/p>\n<p><span style=\"width: 100%;\"><img loading=\"lazy\" decoding=\"async\" alt=\"Formulas hoja base\" width=\"625\" height=\"151\" title=\"Formulas Hoja Base\" data-id=\"40784\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/02\/Formulas-Hoja-Base.png.webp\" style=\"aspect-ratio: auto 630 \/ 152;\" data-width=\"625\" data-height=\"151\" data-init-width=\"630\" data-init-height=\"152\"><\/span><\/p>\n<p style=\"text-align: justify;\">En el tema de hoy vamos a ver y agregar las formulas para la Hoja Base, vamos a asignarle formula a las celdas:<\/p>\n<ul>\n<li style=\"\"><span style=\"\">Crearemos formulas para la columna Productos<\/span><\/li>\n<li style=\"\"><span style=\"\">Crearemos Formulas para la Columna Descripci\u00f3n<\/span><\/li>\n<li style=\"\"><span style=\"\">Asignaremos Formulas a la Columna Impuesto<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Este es el tema 13 y antes de comenzar, tengo una pregunta para ti, \u00bfya viste el tema 12?<\/p>\n<p style=\"text-align: justify;\">Si no has visto el tema 12 \u00bb Formulas hoja venta de tu App FI b\u00e1sico\u00bb, tan solo pulsa clic en el bot\u00f3n Ver tema12:<\/p>\n<p style=\"text-align: justify;\">Si ya viste el tema 12 y estas preparado para continuar con el tema 13, entonces veamos los pasos:<\/p>\n<h1 style=\"text-align: center;\">Formulas Hoja Base &#8211; Columna Productos<\/h1>\n<p style=\"text-align: justify;\">Para comenzar, vamos a ubicarnos en la Hoja Base y nos ubicamos en la celda G2.<\/p>\n<p style=\"text-align: justify;\">Dentro de esta celda vamos a escribir la siguiente formula:<\/p>\n<p style=\"text-align: center;\">=SI(F2&lt;&gt;\u00bb\u00bb;BUSCARV(F2;PRODUCTOS;2;0);\u00bb\u00bb)<\/p>\n<p style=\"text-align: justify;\">Pulsamos enter y listo, le hemos agregado la formula para llamar el nombre del producto.<\/p>\n<p style=\"text-align: justify;\">Ahora continuamos con la siguiente formula:<\/p>\n<h2 style=\"text-align: center;\">&nbsp;Columna Descripci\u00f3n &#8211; Formulas Hoja Base<\/h2>\n<p style=\"text-align: justify;\">A continuaci\u00f3n, vamos a ubicarnos en la celda H2 y vamos a escribir la siguiente formula:<\/p>\n<p style=\"text-align: center;\">=SI(F2&lt;&gt;\u00bb\u00bb;BUSCARV(F2;PRODUCTOS;3;0);\u00bb\u00bb)<\/p>\n<p style=\"text-align: justify;\">Pulsamos enter y listo, hemos agregado la segunda f\u00f3rmula para la Hoja base, ahora veamos la \u00faltima formula:<\/p>\n<h2 style=\"text-align: center;\">&nbsp;Columna Impuesto &#8211; Formulas Hoja Base<\/h2>\n<p style=\"text-align: justify;\">Para finalizar de agregar formula, vamos a ubicarnos en la celda L2 y escribimos la siguiente formula:<\/p>\n<p style=\"text-align: center;\">=SI(K2&gt;0;(I2*K2)*0.12;\u00bb\u00bb)<\/p>\n<p style=\"text-align: justify;\">No olvides, en la parte donde aparece el 0.12 equivale al porcentaje de impuesto, tu lo puedes modificar por el porcentaje aplicado en tu pais.<\/p>\n<p style=\"text-align: justify;\">Por ejemplo: 0.21, 0.15, 0.16, de acuerdo al porcentaje aplicado en tu pais.<\/p>\n<p style=\"text-align: justify;\">Pulsamos enter, y listo, hemos formulado la hoja base.<\/p>\n<p style=\"\">\u00bfQu\u00e9 tal te pareci\u00f3 el art\u00edculo de hoy \u00abFormulas Hoja Base de tu App FI\u00bb? \u00bfTe gusto?<\/p>\n<p style=\"\">Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Facebook<\/a>, a continuaci\u00f3n, te dejo un bot\u00f3n para que puedas compartirlo:<\/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>Formulas Hoja Base de tu App FI Estas listo para aplicar las formulas Hoja Base de tu App FI (Facturacion e Inventario) b\u00e1sico? En el tema de hoy vamos a ver y agregar las formulas para la Hoja Base, vamos a asignarle formula a las celdas: Crearemos formulas para la columna Productos Crearemos Formulas para [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":40784,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h1 class=\"\" style=\"text-align: center;\">Formulas Hoja Base de tu App FI<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b8613e5d\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b858dd9b\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b858dd9e\" style=\"text-align: justify;\">Estas listo para aplicar las formulas Hoja Base de tu App FI (Facturacion e Inventario) b\u00e1sico?<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" style=\"\" data-css=\"tve-u-168b8610d0a\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-40784\" alt=\"Formulas hoja base\" width=\"625\" height=\"151\" title=\"Formulas Hoja Base\" data-id=\"40784\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/02\/Formulas-Hoja-Base.png.webp\" style=\"aspect-ratio: auto 630 \/ 152;\" data-width=\"625\" data-height=\"151\" data-init-width=\"630\" data-init-height=\"152\"><\/span><\/div><div class=\"thrv_wrapper thrv-button tve_ea_thrive_lightbox\" data-css=\"tve-u-16b842d5bf0\" data-button-size=\"l\" data-tcb_hover_state_parent=\"\" style=\"\">\n\t<a href=\"\" class=\"tcb-button-link tve_evt_manager_listen tve_et_click\" data-tcb-events=\"__TCB_EVENT_[{&quot;config&quot;:{&quot;l_anim&quot;:&quot;instant&quot;,&quot;l_id&quot;:&quot;42923&quot;},&quot;a&quot;:&quot;thrive_lightbox&quot;,&quot;t&quot;:&quot;click&quot;}]_TNEVE_BCT__\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\" data-css=\"tve-u-16b842d5bf3\">Clic aqui P\/ver video Ahora \u2192<\/span><\/span>\n\t<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b862e890\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b862b15f\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b862b160\" style=\"text-align: justify;\">En el tema de hoy vamos a ver y agregar las formulas para la Hoja Base, vamos a asignarle formula a las celdas:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" style=\"\" data-css=\"tve-u-168b8663af6\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\"><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\" data-css=\"tve-u-168b8665e6a\" 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-168b8641b71\" style=\"\">Crearemos formulas para la columna Productos<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><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\" data-css=\"tve-u-168b8665e6a\"><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-168b8641b71\" style=\"\">Crearemos Formulas para la Columna Descripci\u00f3n<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><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\" data-css=\"tve-u-168b8665e6a\"><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-168b8641b71\" style=\"\">Asignaremos Formulas a la Columna Impuesto<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b8677a73\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b8677a75\" style=\"text-align: justify;\">Este es el tema 13 y antes de comenzar, tengo una pregunta para ti, \u00bfya viste el tema 12?<\/p><p data-css=\"tve-u-168b8677a75\" style=\"text-align: justify;\">Si no has visto el tema 12 \" Formulas hoja venta de tu App FI b\u00e1sico\", tan solo pulsa clic en el bot\u00f3n Ver tema12:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-button tve_ea_thrive_animation tve_anim_rotate\" data-css=\"tve-u-168b86a07af\" data-button-size=\"m\" data-tcb_hover_state_parent=\"\" style=\"\">\n<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/formulas-hoja-venta-de-tu-app-fi.html\" class=\"tcb-button-link tve_evt_manager_listen tve_et_tve-viewport\" target=\"_blank\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;rotate&quot;,&quot;loop&quot;:0},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\">\n<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqu\u00ed para ver el tema 12 \u2192<\/span><\/span>\n<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b86d444a\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b86b039e\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b86b03a0\" style=\"text-align: justify;\">Si ya viste el tema 12 y estas preparado para continuar con el tema 13, entonces veamos los pasos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h1 class=\"\" style=\"text-align: center;\">Formulas Hoja Base - Columna Productos<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b86fcaf9\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b86f47b4\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b86f47b5\" style=\"text-align: justify;\">Para comenzar, vamos a ubicarnos en la Hoja Base y nos ubicamos en la celda G2.<\/p><p data-css=\"tve-u-168b86f47b5\" style=\"text-align: justify;\">Dentro de esta celda vamos a escribir la siguiente formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2c6a5de\">\n<div class=\"tve-content-box-background\" data-css=\"tve-u-168b871c485\" data-clip-id=\"709a10134391c\"><svg width=\"0\" height=\"0\" class=\"tve-decoration-svg\"><defs><clipPath id=\"clip-bottom-709a10134391c\" class=\"decoration-clip clip-path-bottom\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"13\" pointer-height=\"27\" style=\"curves\" clip-path=\"url(#clip-top-709a10134391c)\"><polygon points=\"0 0, 0 0.73, 1 0.73, 1 0\"><\/polygon><ellipse cx=\"0.0625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.1875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.3125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.4375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.5625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.6875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.8125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.9375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><\/clipPath><clipPath id=\"clip-top-709a10134391c\" class=\"decoration-clip clip-path-top\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"7\" pointer-height=\"6\" style=\"zigzag\"><polygon points=\"0 1, 1 1,1 0.06, 0.9642850000000001 0, 0.92857 0.06, 0.892855 0, 0.85714 0.06, 0.8214250000000001 0, 0.78571 0.06, 0.749995 0, 0.71428 0.06, 0.6785650000000001 0, 0.64285 0.06, 0.607135 0, 0.57142 0.06, 0.5357050000000001 0, 0.49999000000000005 0.06, 0.464275 0, 0.42856000000000005 0.06, 0.3928450000000001 0, 0.35713000000000006 0.06, 0.321415 0, 0.28570000000000007 0.06, 0.24998500000000012 0, 0.21427000000000007 0.06, 0.17855500000000002 0, 0.14284000000000008 0.06, 0.10712500000000014 0, 0.07141000000000008 0.06, 0.03569500000000003 0, -0.00001999999999990898 0.06, 0 0\"><\/polygon><\/clipPath><\/defs><\/svg><\/div>\n<div class=\"tve-cb\" data-css=\"tve-u-168b8752874\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><p data-css=\"tve-u-168b874b9ee\" style=\"text-align: center;\">=SI(F2&lt;&gt;\"\";BUSCARV(F2;PRODUCTOS;2;0);\"\")<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b878204a\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b8769110\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b8769112\" style=\"text-align: justify;\">Pulsamos enter y listo, le hemos agregado la formula para llamar el nombre del producto.<\/p><p data-css=\"tve-u-168b8769112\" style=\"text-align: justify;\">Ahora continuamos con la siguiente formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h2 style=\"text-align: center;\" class=\"\">&nbsp;Columna Descripci\u00f3n - Formulas Hoja Base<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b87b32c8\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b878ae6a\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b878ae6c\" style=\"text-align: justify;\">A continuaci\u00f3n, vamos a ubicarnos en la celda H2 y vamos a escribir la siguiente formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b8706876\">\n<div class=\"tve-content-box-background\" data-css=\"tve-u-168b87ac465\" data-clip-id=\"4138aa060f802\"><svg width=\"0\" height=\"0\" class=\"tve-decoration-svg\"><defs><clipPath id=\"clip-bottom-4138aa060f802\" class=\"decoration-clip clip-path-bottom\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"13\" pointer-height=\"27\" style=\"curves\" clip-path=\"url(#clip-top-4138aa060f802)\"><polygon points=\"0 0, 0 0.73, 1 0.73, 1 0\"><\/polygon><ellipse cx=\"0.0625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.1875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.3125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.4375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.5625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.6875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.8125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.9375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><\/clipPath><clipPath id=\"clip-top-4138aa060f802\" class=\"decoration-clip clip-path-top\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"7\" pointer-height=\"6\" style=\"zigzag\"><polygon points=\"0 1, 1 1,1 0.06, 0.9642850000000001 0, 0.92857 0.06, 0.892855 0, 0.85714 0.06, 0.8214250000000001 0, 0.78571 0.06, 0.749995 0, 0.71428 0.06, 0.6785650000000001 0, 0.64285 0.06, 0.607135 0, 0.57142 0.06, 0.5357050000000001 0, 0.49999000000000005 0.06, 0.464275 0, 0.42856000000000005 0.06, 0.3928450000000001 0, 0.35713000000000006 0.06, 0.321415 0, 0.28570000000000007 0.06, 0.24998500000000012 0, 0.21427000000000007 0.06, 0.17855500000000002 0, 0.14284000000000008 0.06, 0.10712500000000014 0, 0.07141000000000008 0.06, 0.03569500000000003 0, -0.00001999999999990898 0.06, 0 0\"><\/polygon><\/clipPath><\/defs><\/svg><\/div>\n<div class=\"tve-cb\" data-css=\"tve-u-168b8752874\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><p data-css=\"tve-u-168b874b9ee\" style=\"text-align: center;\">=SI(F2&lt;&gt;\"\";BUSCARV(F2;PRODUCTOS;3;0);\"\")<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b87c580a\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b87bd996\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b87bd997\" style=\"text-align: justify;\">Pulsamos enter y listo, hemos agregado la segunda f\u00f3rmula para la Hoja base, ahora veamos la \u00faltima formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h2 style=\"text-align: center;\" class=\"\">&nbsp;Columna Impuesto - Formulas Hoja Base<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b8828c45\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b87d8474\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b87d8475\" style=\"text-align: justify;\">Para finalizar de agregar formula, vamos a ubicarnos en la celda L2 y escribimos la siguiente formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b87f0d9a\">\n<div class=\"tve-content-box-background\" data-css=\"tve-u-168b87ef98e\" data-clip-id=\"f87fe3bf4dc7f\"><svg width=\"0\" height=\"0\" class=\"tve-decoration-svg\"><defs><clipPath id=\"clip-bottom-f87fe3bf4dc7f\" class=\"decoration-clip clip-path-bottom\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"13\" pointer-height=\"27\" style=\"curves\" clip-path=\"url(#clip-top-f87fe3bf4dc7f)\"><polygon points=\"0 0, 0 0.73, 1 0.73, 1 0\"><\/polygon><ellipse cx=\"0.0625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.1875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.3125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.4375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.5625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.6875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.8125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.9375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><\/clipPath><clipPath id=\"clip-top-f87fe3bf4dc7f\" class=\"decoration-clip clip-path-top\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"7\" pointer-height=\"6\" style=\"zigzag\"><polygon points=\"0 1, 1 1,1 0.06, 0.9642850000000001 0, 0.92857 0.06, 0.892855 0, 0.85714 0.06, 0.8214250000000001 0, 0.78571 0.06, 0.749995 0, 0.71428 0.06, 0.6785650000000001 0, 0.64285 0.06, 0.607135 0, 0.57142 0.06, 0.5357050000000001 0, 0.49999000000000005 0.06, 0.464275 0, 0.42856000000000005 0.06, 0.3928450000000001 0, 0.35713000000000006 0.06, 0.321415 0, 0.28570000000000007 0.06, 0.24998500000000012 0, 0.21427000000000007 0.06, 0.17855500000000002 0, 0.14284000000000008 0.06, 0.10712500000000014 0, 0.07141000000000008 0.06, 0.03569500000000003 0, -0.00001999999999990898 0.06, 0 0\"><\/polygon><\/clipPath><\/defs><\/svg><\/div>\n<div class=\"tve-cb\" data-css=\"tve-u-168b8752874\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><p data-css=\"tve-u-168b874b9ee\" style=\"text-align: center;\">=SI(K2&gt;0;(I2*K2)*0.12;\"\")<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168b886279b\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168b882eedb\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168b882eedd\" style=\"text-align: justify;\">No olvides, en la parte donde aparece el 0.12 equivale al porcentaje de impuesto, tu lo puedes modificar por el porcentaje aplicado en tu pais.<\/p><p data-css=\"tve-u-168b882eedd\" style=\"text-align: justify;\">Por ejemplo: 0.21, 0.15, 0.16, de acuerdo al porcentaje aplicado en tu pais.<\/p><p data-css=\"tve-u-168b882eedd\" style=\"text-align: justify;\">Pulsamos enter, y listo, hemos formulado la hoja base.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19586e1f1de\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19586e1f1dd\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">\u00bfQu\u00e9 tal te pareci\u00f3 el art\u00edculo de hoy \"Formulas Hoja Base de tu App FI\"? \u00bfTe gusto?<\/p><p style=\"\">Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\">Facebook<\/a>, a continuaci\u00f3n, te dejo un bot\u00f3n para que puedas compartirlo:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" style=\"\" data-css=\"tve-u-168b885c7d5\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb\">\n<div class=\"tve_s_item tve_s_fb_share\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/formulas-hoja-base-de-tu-app-fi.html\" data-label=\"Compartir\">\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-19586e210c3\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19586e210c1\"><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-19586e210c4\">&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-19586e210c5\">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-19586e210c6\" 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-19586e210c7\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-19586e210c8\"><\/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){[data-css=\"tve-u-168b858dd9b\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b858dd9e\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168b8610d0a\"] { width: 630px; float: none; border: 3px dashed rgb(242, 17, 242); border-radius: 10px; overflow: hidden; margin: 0px auto !important; }[data-css=\"tve-u-168b8613e5d\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168b862b15f\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b862b160\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168b862e890\"] { margin-top: 10px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-168b8663af6\"] p, :not(#tve) [data-css=\"tve-u-168b8663af6\"] li, :not(#tve) [data-css=\"tve-u-168b8663af6\"] blockquote, :not(#tve) [data-css=\"tve-u-168b8663af6\"] address, :not(#tve) [data-css=\"tve-u-168b8663af6\"] .tcb-plain-text, :not(#tve) [data-css=\"tve-u-168b8663af6\"] label, :not(#tve) [data-css=\"tve-u-168b8663af6\"] h1, :not(#tve) [data-css=\"tve-u-168b8663af6\"] h2, :not(#tve) [data-css=\"tve-u-168b8663af6\"] h3, :not(#tve) [data-css=\"tve-u-168b8663af6\"] h4, :not(#tve) [data-css=\"tve-u-168b8663af6\"] h5, :not(#tve) [data-css=\"tve-u-168b8663af6\"] h6 { color: rgb(5, 0, 0); }:not(#tve) [data-css=\"tve-u-168b8665e6a\"] > :first-child { color: rgb(14, 28, 235); }[data-css=\"tve-u-168b8665e6a\"] { font-size: 24px !important; width: 24px !important; height: 24px !important; }[data-css=\"tve-u-168b8663af6\"] { margin-top: 0px !important; margin-bottom: 0px !important; --tve-font-size: 20px; }[data-css=\"tve-u-168b8677a73\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b8677a75\"] { color: rgb(10, 0, 0) !important; }:not(#tve) [data-css=\"tve-u-168b86a07af\"] .tcb-button-link { line-height: 1.2em; font-size: 24px; }[data-css=\"tve-u-168b86a07af\"] .tcb-button-link { padding: 14px 22px; border-color: rgb(251, 255, 235); border-radius: 10px; overflow: hidden; background-image: none !important; background-color: rgb(15, 15, 242) !important; }:not(#tve) [data-css=\"tve-u-168b86a07af\"]:hover .tcb-button-link { background-color: rgb(14, 11, 216) !important; }[data-css=\"tve-u-168b86b039e\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b86b03a0\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168b86d444a\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168b86f47b4\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b86f47b5\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168b86fcaf9\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168b8706876\"] { max-width: 443px; float: none; margin: 0px auto !important; }[data-css=\"tve-u-168b871c485\"] { clip-path: url(\"#clip-bottom-709a10134391c\"); -webkit-clip-path: url(\"#clip-bottom-709a10134391c\");  border-radius: 10px; overflow: hidden; border: none !important; background-color: rgb(155, 10, 32) !important; }:not(#tve) [data-css=\"tve-u-168b874b9ee\"] { color: rgb(251, 247, 247) !important; }[data-css=\"tve-u-168b8752874\"] p { margin: 0px 0px 12px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b8752874\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8752874\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8752874\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8752874\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8752874\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8752874\"] label { font-size: 20px; }[data-css=\"tve-u-168b8769110\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b8769112\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168b878204a\"] { margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168b878ae6a\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b878ae6c\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168b87ac465\"] { clip-path: url(\"#clip-bottom-4138aa060f802\"); -webkit-clip-path: url(\"#clip-bottom-4138aa060f802\");  border-radius: 10px; overflow: hidden; border: none !important; background-color: rgb(10, 155, 80) !important; }[data-css=\"tve-u-168b87b32c8\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168b87bd996\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b87bd997\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168b87c580a\"] { margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168b87d8474\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b87d8475\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168b87ef98e\"] { clip-path: url(\"#clip-bottom-f87fe3bf4dc7f\"); -webkit-clip-path: url(\"#clip-bottom-f87fe3bf4dc7f\");  border-radius: 10px; overflow: hidden; border: none !important; background-color: rgb(155, 10, 120) !important; }[data-css=\"tve-u-168b87f0d9a\"] { max-width: 253px; float: none; margin: 0px auto !important; }[data-css=\"tve-u-168b8828c45\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168b882eedb\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168b882eedd\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168b885c7d5\"] { float: none; margin: 0px auto !important; }[data-css=\"tve-u-168b886279b\"] { margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2c6a5de\"] { max-width: 443px; float: none; margin: 0px auto !important; }:not(#tve) [data-css=\"tve-u-16b842d5bf0\"] .tcb-button-link { line-height: 1.2em; font-size: 32px; }[data-css=\"tve-u-16b842d5bf0\"] .tcb-button-link { padding: 18px 30px; border-radius: 10px; overflow: hidden; background-image: none !important; background-color: rgb(241, 12, 12) !important; }:not(#tve) [data-css=\"tve-u-16b842d5bf0\"]:hover .tcb-button-link { background-color: rgb(215, 12, 9) !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; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b858dd9b\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b858dd9b\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b858dd9b\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b858dd9b\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b858dd9b\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b858dd9b\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b858dd9b\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b862b15f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b862b15f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b862b15f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b862b15f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b862b15f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b862b15f\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b862b15f\"] { --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-168b8663af6\"] li { font-size: var(--tve-font-size, 20px) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b8677a73\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8677a73\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8677a73\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8677a73\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8677a73\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8677a73\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b8677a73\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b86b039e\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86b039e\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86b039e\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86b039e\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86b039e\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86b039e\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b86b039e\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b86f47b4\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86f47b4\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86f47b4\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86f47b4\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86f47b4\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b86f47b4\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b86f47b4\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b8769110\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8769110\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8769110\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8769110\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8769110\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b8769110\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b8769110\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b878ae6a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b878ae6a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b878ae6a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b878ae6a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b878ae6a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b878ae6a\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b878ae6a\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b87bd996\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87bd996\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87bd996\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87bd996\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87bd996\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87bd996\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b87bd996\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b87d8474\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87d8474\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87d8474\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87d8474\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87d8474\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b87d8474\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b87d8474\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168b882eedb\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b882eedb\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b882eedb\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b882eedb\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b882eedb\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168b882eedb\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168b882eedb\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19586e1f1dd\"] { --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-19586e1f1dd\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e1f1dd\"] 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-19586e1f1dd\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19586e1f1de\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19586e210c1\"] { --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-19586e210c1\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e210c1\"] 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-19586e210c1\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19586e210c3\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-19586e210c4\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-19586e210c5\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-19586e210c6\"] { --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-19586e210c7\"] { --tcb-text-highlight-color: rgb(30, 184, 76) !important; }[data-css=\"tve-u-19586e210c8\"] { --tcb-text-highlight-color: transparent !important; }}@media (max-width: 1023px){:not(#tve) [data-css=\"tve-u-16b842d5bf3\"] { font-size: 30px !important; }}@media (max-width: 767px){:not(#tve) [data-css=\"tve-u-16b842d5bf3\"] { font-size: 17px !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":[1],"tags":[6005,6108,6004],"class_list":["post-40779","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-y-contabilidad","tag-base-de-tu-app-fi","tag-formulas-hoja-base","tag-hoja-base","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/40779","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=40779"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/40779\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/40784"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=40779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=40779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=40779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}