{"id":45713,"date":"2020-04-01T21:33:16","date_gmt":"2020-04-02T03:33:16","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=45713"},"modified":"2025-01-05T11:16:17","modified_gmt":"2025-01-05T17:16:17","slug":"funcion-si-conjunto","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/funcion-si-conjunto.html","title":{"rendered":"Funcion si conjunto"},"content":{"rendered":"<h1 style=\"text-align: center;\">Como Aplicar la Funcion SI conjunto en excel<\/h1>\n<p>Estas listo para aprender a utilizar la nueva funci\u00f3n de excel 2019 \u00bb La Funcion SI Conjunto \u00ab.<\/p>\n<p><span><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Funcion-si-conjunto.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"Funcion si conjunto\" data-id=\"45724\" width=\"554\" height=\"86\" title=\"Funcion si conjunto\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Funcion-si-conjunto.png\" data-link-wrap=\"true\"><\/a><\/span><\/p>\n<p>En este articulo vamos a ver como aplicar la nueva funcion SI.CONJUNTO para hacer varias pruebas logicas, sin redundar la Funcion SI.<\/p>\n<p>En enero del 2018, publicamos un articulo llamado&nbsp; \u00bb <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/reducir-repeticion-de-la-funcion-si.html\" style=\"outline: none;\" target=\"_blank\">Como Reducir Repetici\u00f3n de la Funci\u00f3n Si en las F\u00f3rmulas <\/a>\u00ab.<\/p>\n<p>Dentro del articulo, compartimos dos funciones: CODIGO y ELEGIR, el cual nos ayudaria a reducir la repeticion de la Funcion SI.<\/p>\n<p>Pero con la nueva actualizaci\u00f3n, ahora tenemos una nueva funci\u00f3n que hara el proceso totalmente simple, veamos:<\/p>\n<h2 style=\"text-align: center;\">Como aplicar varias pruebas logicas con la Funcion SI Conjunto<\/h2>\n<p>Para comenzar vamos a utilizar el siguiente archivo:<\/p>\n<p><span><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Nota-de-Calificaciones.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" alt=\"Funcion si conjunto\" data-id=\"45730\" width=\"622\" height=\"307\" title=\"Nota de Calificaciones\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Nota-de-Calificaciones.png\" data-link-wrap=\"true\"><\/a><\/span><\/p>\n<p>Ya &nbsp;descargaste el archivo? si ya lo has descargado, por favor abrelo.<\/p>\n<p>Dentro de este puedes notar que en la primera tabla hemos utilizado varias veces la funci\u00f3n SI para hacer 5 pruebas logicas:<\/p>\n<p><span><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Prueba-logica-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" data-id=\"45740\" width=\"600\" height=\"207\" title=\"Prueba logica 1\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Prueba-logica-1.png\" data-link-wrap=\"true\" style=\"\"><\/a><\/span><\/p>\n<p>Con la nueva funcion si conjunto, podemos hacer la prueba logica mas de 5 veces sin tener que repetir la funcion si.<\/p>\n<p>Veamos los pasos:<\/p>\n<ul>\n<li style=\"\"><span>En primer lugar, nos ubicamos en la celda H7 y escribimos = SI.CONJUNTO<\/span><\/li>\n<li style=\"\"><span>A continuacion abrimos parentesis y escribimos lo siguiente: B7=\u00bbA\u00bb;\u00bbEXCELENTE\u00bb;B7=\u00bbB\u00bb;\u00bbMUY BUENO\u00bb;B7=\u00bbC\u00bb;\u00bbBUENO\u00bb;B7=\u00bbD\u00bb;\u00bbREGULAR\u00bb;B7=\u00bbE\u00bb;\u00bbREPROBADO\u00bb.<\/span><\/li>\n<li style=\"\"><span>Y para finalizar con la formula cerramos parentesis ). Te dejo una imagen de como debe de quedar la formula:<\/span><\/li>\n<\/ul>\n<p style=\"\"><strong><\/strong><strong>=SI.CONJUNTO(B7=\u00bbA\u00bb;\u00bbEXCELENTE\u00bb;B7=\u00bbB\u00bb;\u00bbMUY BUENO\u00bb;B7=\u00bbC\u00bb;\u00bbBUENO\u00bb;B7=\u00bbD\u00bb;\u00bbREGULAR\u00bb;B7=\u00bbE\u00bb;<\/strong><strong><\/strong><\/p>\n<p style=\"\"><strong>\u00abREPROBADO\u00bb)<\/strong><\/p>\n<p style=\"text-align: justify;\">Ahora pulsamos enter y seleccionamos de la celda H7 hasta la H16 y rellenamos la formula hacia abajo.<\/p>\n<p style=\"text-align: justify;\">Con este paso, puedes notar que ya se aplica la observacion correspondiente, sin repetir varias veces la funcion SI.<\/p>\n<p style=\"text-align: justify;\">Que tal te parecio el tema de hoy? te gusto?<\/p>\n<p style=\"text-align: justify;\">Si te gusto, comp\u00e1rtelo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" rel=\"noopener\">facebook<\/a>:<\/p>\n<p style=\"text-align: justify;\">Cualquier duda o pregunta, tan solo escribenos en el chat o bien a rogerperez@aplicaexcelcontable.com.<\/p>\n<p style=\"text-align: justify;\">Saludos,<\/p>\n<p style=\"text-align: justify;\"><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como Aplicar la Funcion SI conjunto en excel Estas listo para aprender a utilizar la nueva funci\u00f3n de excel 2019 \u00bb La Funcion SI Conjunto \u00ab. En este articulo vamos a ver como aplicar la nueva funcion SI.CONJUNTO para hacer varias pruebas logicas, sin redundar la Funcion SI. En enero del 2018, publicamos un articulo [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":45730,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" style=\"\" data-css=\"tve-u-1713840d995\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-171360cb4b1\"><div class=\"thrv_wrapper thrv_text_element\"><h1 class=\"\" style=\"text-align: center;\">Como Aplicar la Funcion SI conjunto en excel<\/h1><\/div><div class=\"thrv_wrapper thrv_text_element\"><p>Estas listo para aprender a utilizar la nueva funci\u00f3n de excel 2019 \" La Funcion SI Conjunto \".<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-17136ae10ce\" style=\"\"><span class=\"tve_image_frame\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Funcion-si-conjunto.png\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-45724\" alt=\"Funcion si conjunto\" data-id=\"45724\" width=\"554\" height=\"86\" title=\"Funcion si conjunto\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Funcion-si-conjunto.png\" data-link-wrap=\"true\"><\/a><\/span><\/div><div class=\"thrv_wrapper thrv_text_element\"><p>En este articulo vamos a ver como aplicar la nueva funcion SI.CONJUNTO para hacer varias pruebas logicas, sin redundar la Funcion SI.<\/p><p>En enero del 2018, publicamos un articulo llamado&nbsp; \" <a class=\"\" href=\"https:\/\/aplicaexcelcontable.com\/blog\/reducir-repeticion-de-la-funcion-si.html\" style=\"outline: none;\" target=\"_blank\">Como Reducir Repetici\u00f3n de la Funci\u00f3n Si en las F\u00f3rmulas <\/a>\".<\/p><p>Dentro del articulo, compartimos dos funciones: CODIGO y ELEGIR, el cual nos ayudaria a reducir la repeticion de la Funcion SI.<\/p><p>Pero con la nueva actualizaci\u00f3n, ahora tenemos una nueva funci\u00f3n que hara el proceso totalmente simple, veamos:<\/p><\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" data-css=\"tve-u-17136c397c3\" style=\"text-align: center;\">Como aplicar varias pruebas logicas con la Funcion SI Conjunto<\/h2><\/div><div class=\"thrv_wrapper thrv_text_element\"><p>Para comenzar vamos a utilizar el siguiente archivo:<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-171378073a9\" style=\"\"><span class=\"tve_image_frame\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Nota-de-Calificaciones.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-45730\" alt=\"Funcion si conjunto\" data-id=\"45730\" width=\"622\" height=\"307\" title=\"Nota de Calificaciones\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Nota-de-Calificaciones.png\" data-link-wrap=\"true\"><\/a><\/span><\/div><div class=\"thrv_wrapper thrv_toggle tve-toggle-auto-collapse tcb-local-vars-root\" data-columns=\"1\" data-animation=\"slide\" data-animation-speed=\"fast\" data-ct-name=\"Toggle 09\" data-ct=\"toggle-55901\" data-css=\"tve-u-17137cf2318\" style=\"\" data-element-name=\"Toggle\"><div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"91981\":{\"name\":\"Main Accent\",\"parent\":-1},\"2713c\":{\"name\":\"Main Lighter\",\"parent\":\"91981\"},\"7322c\":{\"name\":\"2nd Accent\",\"parent\":-1},\"816f1\":{\"name\":\"2nd Transparent\",\"parent\":\"7322c\"}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default\",\"value\":{\"colors\":{\"91981\":{\"val\":\"rgb(75, 128, 232)\",\"hsl\":{\"h\":219,\"s\":0.77,\"l\":0.6}},\"2713c\":{\"val\":\"rgb(97, 143, 234)\",\"hsl_parent_dependency\":{\"h\":219,\"s\":0.76,\"l\":0.64}},\"7322c\":{\"val\":\"rgb(141, 255, 213)\",\"hsl\":{\"h\":157,\"s\":1,\"l\":0.77}},\"816f1\":{\"val\":\"rgba(141, 255, 213, 0.25)\",\"hsl_parent_dependency\":{\"h\":157,\"s\":1,\"l\":0.77}}},\"gradients\":[]},\"original\":{\"colors\":{\"91981\":{\"val\":\"rgb(75, 128, 232)\",\"hsl\":{\"h\":219,\"s\":0.77,\"l\":0.6}},\"2713c\":{\"val\":\"rgb(97, 143, 234)\",\"hsl_parent_dependency\":{\"h\":219,\"s\":0.76,\"l\":0.64}},\"7322c\":{\"val\":\"rgb(141, 255, 213)\",\"hsl\":{\"h\":157,\"s\":1,\"l\":0.77}},\"816f1\":{\"val\":\"rgba(141, 255, 213, 0.25)\",\"hsl_parent_dependency\":{\"h\":157,\"s\":1,\"l\":0.77}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div><div class=\"thrive-group-edit-config\" style=\"display: none !important\">__CONFIG_group_edit__{\"k5p7vfy4\":{\"name\":\"All Text(s)\",\"singular\":\"-- Text %s\"}}__CONFIG_group_edit__<\/div>\n<div class=\"tve-toggle-grid tve-prevent-content-edit\" style=\"\"><div class=\"tve-toggle-column\" data-index=\"1\" style=\"\"><div class=\"thrv_toggle_item tve_faq\" style=\"\" data-css=\"tve-u-17137cf2319\">\n\t\t<div class=\"tve_faqI\">\n\t\t\t<div class=\"tve_faqB thrv_toggle_title tve-toggle-show-icon tcb-icon-display\" data-icon-code=\"icon-plus-circle-light\" data-css=\"tve-u-17137cf231a\" data-selector=\"[data-css=&quot;tve-u-17137cf2318&quot;] .thrv_toggle_title\" data-append-suffix=\"1\" style=\"\" data-tcb_hover_state_parent=\"\">\n\t\t\t\t<div class=\"tve_toggle\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-plus-circle-light\" data-name=\"\">\n            <path d=\"M384 250v12c0 6.6-5.4 12-12 12h-98v98c0 6.6-5.4 12-12 12h-12c-6.6 0-12-5.4-12-12v-98h-98c-6.6 0-12-5.4-12-12v-12c0-6.6 5.4-12 12-12h98v-98c0-6.6 5.4-12 12-12h12c6.6 0 12 5.4 12 12v98h98c6.6 0 12 5.4 12 12zm120 6c0 137-111 248-248 248S8 393 8 256 119 8 256 8s248 111 248 248zm-32 0c0-119.9-97.3-216-216-216-119.9 0-216 97.3-216 216 0 119.9 97.3 216 216 216 119.9 0 216-97.3 216-216z\"><\/path>\n        <\/svg><\/div>\n\t\t\t\t<h4 class=\"tve-toggle-text\" data-css=\"tve-u-17137cf231b\" style=\"\">Descarga aqui el archivo excel <img decoding=\"async\" role=\"img\" class=\"emoji\" alt=\"\ud83d\udc47\" src=\"https:\/\/s.w.org\/images\/core\/emoji\/15.0.3\/svg\/1f447.svg\"><\/h4>\n\t\t\t<\/div>\n\t\t\t<div class=\"tve_faqC \"><div class=\"thrv_wrapper thrv_toggle_content tve-elem-default-pad\" data-css=\"tve-u-17137cf231c\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\"><div class=\"thrv_wrapper thrv-button tcb-with-icon tve_ea_thrive_animation tve_anim_slide_left\" data-css=\"tve-u-17137c50199\" data-tcb_hover_state_parent=\"\" data-button-style=\"rounded\" style=\"\">\n<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/?smd_process_download=1&amp;download_id=45735\" class=\"tcb-button-link tve_evt_manager_listen tve_et_tve-viewport tve-viewport-triggered\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;slide_left&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\" target=\"_blank\"><span class=\"tcb-button-icon\">\n<div class=\"thrv_wrapper thrv_icon tve_no_drag tve_no_icons tcb-icon-inherit-style\">\n<svg data-name=\"credit-card\" class=\"tcb-icon\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" x=\"0px\" y=\"0px\" viewBox=\"0 0 18 14\" xml:space=\"preserve\" preserveAspectRatio=\"none slice\">\n<g>\n<path d=\"M17.5,1.9v10.6c0,0.8-0.6,1.4-1.4,1.4h-14c-0.8,0-1.4-0.6-1.4-1.4V1.9c0-0.8,0.6-1.4,1.4-1.4h14 C16.9,0.5,17.5,1.1,17.5,1.9z M1.9,1.9v2h14.5v-2c0-0.1-0.1-0.3-0.3-0.3h-14C2,1.6,1.9,1.7,1.9,1.9z M16.4,12.5V7.2H1.9v5.3 c0,0.1,0.1,0.3,0.3,0.3h14C16.3,12.8,16.4,12.6,16.4,12.5z M3,10.5h2.2v1.1H3V10.5z M6.3,10.5h3.4v1.1H6.3V10.5z\"><\/path>\n<\/g>\n<\/svg>\n<\/div>\n<\/span>\n<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\" data-css=\"tve-u-17137c5019b\">Haz clic aqu\u00ed para descargar el archivo<\/span><\/span>\n<\/a>\n<\/div><\/div>\n<\/div><\/div>\n\t\t<\/div>\n\t<\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_text_element\"><p>Ya &nbsp;descargaste el archivo? si ya lo has descargado, por favor abrelo.<\/p><p>Dentro de este puedes notar que en la primera tabla hemos utilizado varias veces la funci\u00f3n SI para hacer 5 pruebas logicas:<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-171380756b0\" style=\"\"><span class=\"tve_image_frame\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Prueba-logica-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-45740\" alt=\"\" data-id=\"45740\" width=\"600\" height=\"207\" title=\"Prueba logica 1\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Prueba-logica-1.png\" data-link-wrap=\"true\" style=\"\" data-css=\"tve-u-171380760ef\"><\/a><\/span><\/div><div class=\"thrv_wrapper thrv_text_element\"><p>Con la nueva funcion si conjunto, podemos hacer la prueba logica mas de 5 veces sin tener que repetir la funcion si.<\/p><p>Veamos los pasos:<\/p><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" style=\"\" data-css=\"tve-u-17138413671\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-17138361083\" 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\"><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-171383607b7\">En primer lugar, nos ubicamos en la celda H7 y escribimos = SI.CONJUNTO<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-17138361083\" 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\"><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-171383607b7\">A continuacion abrimos parentesis y escribimos lo siguiente: B7=\"A\";\"EXCELENTE\";B7=\"B\";\"MUY BUENO\";B7=\"C\";\"BUENO\";B7=\"D\";\"REGULAR\";B7=\"E\";\"REPROBADO\".<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-17138361083\" 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-171383cb6f8\"><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-171383607b7\">Y para finalizar con la formula cerramos parentesis ). Te dejo una imagen de como debe de quedar la formula:<\/span><\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" style=\"\" data-css=\"tve-u-1713840c5bc\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-171384059bc\"><\/div>\n\t<div class=\"tve-cb\" data-css=\"tve-u-1713845e251\" style=\"\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\" data-css=\"tve-u-17138408e20\"><p data-css=\"tve-u-171383f903a\" style=\"\"><strong><\/strong><strong>=SI.CONJUNTO(B7=\"A\";\"EXCELENTE\";B7=\"B\";\"MUY BUENO\";B7=\"C\";\"BUENO\";B7=\"D\";\"REGULAR\";B7=\"E\";<\/strong><strong><\/strong><\/p><p data-css=\"tve-u-171383f903a\" style=\"\"><strong>\"REPROBADO\")<\/strong><\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" style=\"\" data-css=\"tve-u-17138e35ff4\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-17138e1994a\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: justify;\">Ahora pulsamos enter y seleccionamos de la celda H7 hasta la H16 y rellenamos la formula hacia abajo.<\/p><p style=\"text-align: justify;\">Con este paso, puedes notar que ya se aplica la observacion correspondiente, sin repetir varias veces la funcion SI.<\/p><p style=\"text-align: justify;\">Que tal te parecio el tema de hoy? te gusto?<\/p><\/div><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: justify;\">Si te gusto, comp\u00e1rtelo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\">facebook<\/a>:<\/p><\/div><div class=\"tcb-clear\" data-css=\"tve-u-17138e5a573\"><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-17138e59b28\">\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:\/\/www.facebook.com\/AplicaExceContable\/\" data-label=\"Compartir\">\n\t<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><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: justify;\">Cualquier duda o pregunta, tan solo escribenos en el chat o bien a rogerperez@aplicaexcelcontable.com.<\/p><p style=\"text-align: justify;\">Saludos,<\/p><p style=\"text-align: justify;\"><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-171360cb4b1\"] h6 { color: var(--tve-color,rgb(0,4,7)); --tcb-applied-color: rgb(0,4,7); }[data-css=\"tve-u-171360cb4b1\"] { --tve-color: rgb(0,4,7); }[data-css=\"tve-u-171360cb4b1\"] h1 { padding: 0px 0px 5px !important; margin: 0px !important; }[data-css=\"tve-u-171360cb4b1\"] p { padding: 0px 0px 12px !important; margin: 0px !important; }[data-css=\"tve-u-171360cb4b1\"] h2 { padding: 0px 0px 7px !important; margin: 0px !important; }[data-css=\"tve-u-17136ae10ce\"] { width: 554px; margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-17136c397c3\"] { font-size: 27px !important; color: rgb(23, 9, 248) !important; --tcb-applied-color: rgb(23,9,248) !important; }[data-css=\"tve-u-171378073a9\"] { width: 622px; border: 4px solid rgb(13, 128, 243); border-radius: 10px; overflow: hidden; margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-17137c50199\"] { margin-top: -1px !important; }[data-css=\"tve-u-17137c50199\"] .tcb-button-link { border-radius: 8px; background-image: none !important; background-color: rgb(246, 138, 11) !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title { border-radius: 5px; overflow: hidden; --tve-font-weight: var(--g-bold-weight,bold); --tve-font-family: \"Source Sans Pro\"; --g-regular-weight: 400; --g-bold-weight: 600; background-color: var(--tcb-local-color-91981) !important; padding-left: 20px !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title .tve-toggle-text { --tcb-applied-color: rgb(255,255,255); color: rgb(255, 255, 255) !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title .tve_toggle { color: rgb(255, 255, 255); font-size: 20px !important; width: 20px !important; height: 20px !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title.tve-state-expanded { background-image: linear-gradient(330deg,var(--tcb-local-color-816f1) 0%,rgba(255,255,255,0) 100%) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; background-color: var(--tcb-local-color-91981) !important; }:not(#tve) [data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title:hover:not(.tve-state-expanded) { background-image: linear-gradient(330deg,var(--tcb-local-color-816f1) 0%,rgba(255,255,255,0) 100%) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; background-color: var(--tcb-local-color-91981) !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title.tve-state-expanded .tve_toggle:not(.inc) { color: var(--tcb-local-color-7322c); font-size: 20px !important; width: 20px !important; height: 20px !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title.tve-state-expanded:not(.inc) { --animation-angle: 45deg; border-bottom-right-radius: 0px; overflow: hidden; border-bottom-left-radius: 0px; background-image: none !important; background-color: var(--tcb-local-color-91981) !important; }[data-css=\"tve-u-17137cf231c\"] { overflow: hidden; padding-left: 50px !important; border-top: none !important; border-right: 1px solid var(--tcb-local-color-2713c) !important; border-bottom: 1px solid var(--tcb-local-color-2713c) !important; border-left: 1px solid var(--tcb-local-color-2713c) !important; border-image: initial !important; border-bottom-right-radius: 5px !important; border-bottom-left-radius: 5px !important; padding-top: 40px !important; padding-bottom: 40px !important; }[data-css=\"tve-u-17137cf2318\"] .tve-toggle-column { width: calc(100% + 0px) !important; margin-left: 0px !important; }[data-css=\"tve-u-17137cf2318\"] .tve-toggle-grid { margin-left: 0px !important; }[data-css=\"tve-u-17137cf231c\"].tve-state-expanded { border-bottom: 2px solid rgb(57, 164, 210) !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title.tve-state-expanded .tve_toggle { color: var(--tcb-local-color-7322c); }:not(#tve) [data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title:hover:not(.tve-state-expanded) .tve_toggle { color: var(--tcb-local-color-7322c) !important; }[data-css=\"tve-u-17137cf2319\"] { margin-top: 7.5px; margin-bottom: 7.5px; --toggle-vertical-space: 15; }:not(#tve) [data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title .tve-toggle-text { font-family: var(--tve-font-family,\"Source Sans Pro\"); font-weight: var(--tve-font-weight,var(--g-bold-weight,bold) ) !important; }[data-css=\"tve-u-171380756b0\"] { width: 600px; border: 4px solid rgb(10, 122, 234); border-radius: 10px; overflow: hidden; margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-171383f903a\"] { background-color: rgb(248, 241, 10) !important; color: rgb(0, 3, 6) !important; --tcb-applied-color: rgb(0,3,6) !important; }[data-css=\"tve-u-171384059bc\"] { border-radius: 10px; overflow: hidden; background-color: rgb(239, 132, 5) !important; }[data-css=\"tve-u-17138408e20\"] { overflow: hidden; border-radius: 10px !important; padding-right: 1px !important; margin-right: 0px !important; }[data-css=\"tve-u-1713840c5bc\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-1713840d995\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-17138413671\"] { margin-bottom: 0px !important; }[data-css=\"tve-u-17138361083\"] { padding-bottom: 0px !important; }[data-css=\"tve-u-1713845e251\"] p { padding: 0px !important; margin: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-1713845e251\"] h6 { color: var(--tve-color,rgb(0,3,6)); --tcb-applied-color: rgb(0,3,6); }[data-css=\"tve-u-1713845e251\"] { --tve-color: rgb(0,3,6); }:not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-17138e1994a\"] h6 { color: var(--tve-color,rgb(0,4,8)); --tcb-applied-color: rgb(0,4,8); }[data-css=\"tve-u-17138e1994a\"] { --tve-color: rgb(0,4,8); }[data-css=\"tve-u-17138e1994a\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-17138e35ff4\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-17138e59b28\"] { float: right; z-index: 3; position: relative; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-17138e5a573\"]::after { clear: both; }[data-css=\"tve-u-17137cf2318\"] { --tcb-local-color-91981: rgb(75,128,232); --tcb-local-color-2713c: rgb(97,143,234); --tcb-local-color-7322c: rgb(141,255,213); --tcb-local-color-816f1: rgba(141,255,213,0.25); }.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: 1023px){[data-css=\"tve-u-17137cf231c\"] { padding: 20px 20px 20px 45px !important; }}@media (max-width: 767px){:not(#tve) [data-css=\"tve-u-17137c5019b\"] { font-size: 13px !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title .tve-toggle-text { font-size: 18px !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title .tve_toggle { font-size: 18px !important; width: 18px !important; height: 18px !important; }[data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title { padding-left: 10px !important; }[data-css=\"tve-u-17137cf231c\"] { padding-left: 20px !important; }:not(#tve) [data-css=\"tve-u-17137cf2318\"] .thrv_toggle_title .tve-toggle-text { line-height: 1.75em !important; }[data-css=\"tve-u-17137cf2319\"] { margin-top: 7.5px; margin-bottom: 7.5px; --toggle-vertical-space: 15; }}","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":[7318,7317,7319,7320],"class_list":["post-45713","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-funciones-excel","tag-funcion-si-conjunto","tag-si-conjunto","tag-si-conjunto-en-excel","tag-si-conjunto-2","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/45713","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=45713"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/45713\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/45730"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=45713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=45713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=45713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}