{"id":342,"date":"2023-11-02T15:07:50","date_gmt":"2023-11-02T15:07:50","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/si-declaracion\/"},"modified":"2023-12-25T10:32:46","modified_gmt":"2023-12-25T10:32:46","slug":"si-declaracion","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/si-declaracion\/","title":{"rendered":"Consulta de energ\u00eda: declaraci\u00f3n if"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4256556472\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>En Power Query, si desea crear una declaraci\u00f3n IF, existe una opci\u00f3n espec\u00edfica que le ayudar\u00e1 a escribirla sin una f\u00f3rmula. Por ejemplo, a continuaci\u00f3n se muestra una lista de n\u00fameros (100) en la columna A. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88939\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"consulta-declaraci\u00f3n-if-en-poder\" width=\"224\" height=\"222\"><\/figure>\n<\/div>\n<p> Necesita una nueva columna con declaraci\u00f3n IF para verificar si un n\u00famero es mayor o igual a 1000.<\/p>\n<h2 class=\"wp-block-heading\"> Usar IF en Power Query<\/h2>\n<p> Estos son los pasos para escribir una declaraci\u00f3n IF en Power Query:<\/p>\n<ol>\n<li> Primero, seleccione una celda y vaya a la pesta\u00f1a Datos &gt; Obtener datos &gt; De otras fuentes &gt; De tabla\/rango. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"2-consulta de uso-si-est\u00e1-en-poder\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-si-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-if-in-power-query\" width=\"477\" height=\"337\"><\/li>\n<li> Haga clic en Aceptar para convertir los datos en una tabla y cargarlos en el editor de consultas avanzado. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"3-convertir-datos-a-tabla-y-cargar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-convertir-les-donnees-en-table-et-charger.png\" sizes=\"auto, \" srcset=\"\" alt=\"convert-data-into-table-and-load\" width=\"369\" height=\"133\"><\/li>\n<li> Vaya a la pesta\u00f1a \u00abAgregar columna\u00bb en el potente editor de consultas y haga clic en \u00abColumna condicional\u00bb. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"Columna condicional en 4 clics\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Colonne-conditionnelle-en-4-clics.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-conditional-column\" width=\"499\" height=\"271\"><\/li>\n<li> Y cuando haga clic en el bot\u00f3n, le mostrar\u00e1 un cuadro de di\u00e1logo para crear la declaraci\u00f3n condicional. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5-di\u00e1logos-para-crear-una-declaraci\u00f3n-condicional\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-boite-de-dialogue-pour-creer-une-instruction-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"dialog-box-to-create-conditional-statement\" width=\"658\" height=\"271\"><\/li>\n<li id=\"block-12d1fea2-fe89-41da-ac3f-76a8f6ad6909\" class=\"block-editor-block-list__block wp-block is-selected wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"12d1fea2-fe89-41da-ac3f-76a8f6ad6909\" data-type=\"core\/list-item\" data-title=\"List item\">\n<div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Debes seguir los pasos a continuaci\u00f3n: <\/div>\n<ol id=\"block-13e8ba86-7e9d-4dfa-85f8-8e7781c51f00\" class=\"block-editor-block-list__block wp-block wp-block-list block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List\" data-block=\"13e8ba86-7e9d-4dfa-85f8-8e7781c51f00\" data-type=\"core\/list\" data-title=\"List\" data-is-drop-zone=\"true\">\n<li id=\"block-65da9307-cc10-4433-b081-92a73d2f0951\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"65da9307-cc10-4433-b081-92a73d2f0951\" data-type=\"core\/list-item\" data-title=\"List item\">\n<div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Ingrese el nuevo nombre de la columna \u00abEstado\u00bb. <\/div>\n<\/li>\n<li id=\"block-f8f0d664-28ef-4f73-ba86-551008a23a8f\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"f8f0d664-28ef-4f73-ba86-551008a23a8f\" data-type=\"core\/list-item\" data-title=\"List item\">\n<div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Seleccione la columna \u00abN\u00fameros\u00bb. <\/div>\n<\/li>\n<li id=\"block-69edee46-70e4-4e1b-9a47-949b59b1ce26\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"69edee46-70e4-4e1b-9a47-949b59b1ce26\" data-type=\"core\/list-item\" data-title=\"List item\">\n<div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Utilice el operador \u00abes mayor o igual que\u00bb. <\/div>\n<\/li>\n<li id=\"block-b5df48b9-7ab0-4e28-abe7-494ef564e69c\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"b5df48b9-7ab0-4e28-abe7-494ef564e69c\" data-type=\"core\/list-item\" data-title=\"List item\">\n<div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Introduzca el valor \u00ab1000\u00bb. <\/div>\n<\/li>\n<li id=\"block-4aa8de0b-76a9-483f-9d10-6bb90baf0c60\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"4aa8de0b-76a9-483f-9d10-6bb90baf0c60\" data-type=\"core\/list-item\" data-title=\"List item\">\n<div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> \u201cS\u00ed\u201d para salir. <\/div>\n<\/li>\n<li id=\"block-5bbc9f99-1ac7-479d-80d8-b531b968581e\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"5bbc9f99-1ac7-479d-80d8-b531b968581e\" data-type=\"core\/list-item\" data-title=\"List item\">\n<div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> \u201cNo\u201d para el resto. <\/div>\n<\/li>\n<li id=\"block-0841c1ed-0853-42a0-ae07-8585ec60b6a6\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"0841c1ed-0853-42a0-ae07-8585ec60b6a6\" data-type=\"core\/list-item\" data-title=\"List item\">\n<div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Haga clic en Aceptar. <\/div>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"6-sentencia-agregar-condicional\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-ajouter-une-instruction-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-conditional-statement\" width=\"661\" height=\"276\"><\/p>\n<\/li>\n<\/ol>\n<p> Con la declaraci\u00f3n IF anterior, le est\u00e1 indicando a PowerQuery que cree una nueva columna donde use \u00abS\u00ed\u00bb si el n\u00famero es mayor o igual a \u00ab1000\u00bb; de lo contrario, \u00abNo\u00bb. Y en el momento en que presionas Enter, ingresa a una nueva columna con la condici\u00f3n que escribiste. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88945\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-nouvelle-colonne-avec-la-condition-que-vous-avez-ecrite.png\" sizes=\"auto, \" srcset=\"\" alt=\"nueva-columna-con-la-condici\u00f3n-que-escribiste\" width=\"377\" height=\"343\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Usar IF con ELSE-IF en Power Query (IF anidado)<\/h2>\n<p> Tambi\u00e9n tiene la opci\u00f3n de utilizar la instrucci\u00f3n else if con el IF (anidado). Puede ver una opci\u00f3n para agregarlo en el cuadro de di\u00e1logo de la declaraci\u00f3n IF. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88946\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-si-avec-elseif-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"consulta si-con-si no-si-est\u00e1-en-poder\" width=\"550\" height=\"311\"><\/figure>\n<\/div>\n<ol>\n<li> Cuando hace clic en el bot\u00f3n \u00abAgregar cl\u00e1usula\u00bb, obtendr\u00e1 una declaraci\u00f3n Else IF, al igual que IF, y ahora deber\u00e1 ingresar los detalles aqu\u00ed. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"9-a\u00f1adir-cl\u00e1usula-para-obtener-elseif-declaraci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-ajouter-une-clause-pour-obtenir-une-instruction-elseif.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-clause-to-get-else-if-statement\" width=\"831\" height=\"247\"><\/li>\n<li> Aqu\u00ed usar\u00e9 el operador mayor que e igual para obtener el valor \u00abQuiz\u00e1s\u00bb para n\u00fameros mayores que 500 pero menores que 1000. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"10-use-mayor-e-igual-para-obtener-tal vez\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-utiliser-superieur-et-egal-a-obtenir-peut-etre.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-greater-than-and-equal-to-get-may-be\" width=\"832\" height=\"252\"><\/li>\n<li> Una vez que haga clic en Aceptar, obtendr\u00e1 tres valores diferentes en la columna \u00abEstado\u00bb, seg\u00fan su declaraci\u00f3n IF escrita. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"11-tres-valores-diferentes-en-columna\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-trois-valeurs-differentes-dans-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"three-different-values-in-the-column\" width=\"391\" height=\"286\"><\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\"> Escribe una f\u00f3rmula SI real<\/h2>\n<p> S\u00ed, tambi\u00e9n puedes escribir una f\u00f3rmula IF real. Por ejemplo, escribir la f\u00f3rmula IF en PowerQuery es ligeramente diferente en Power Query, pero no mucho. Entonces, una vez que haya cargado los datos en el Editor de consultas avanzado, vaya a la pesta\u00f1a Columna y haga clic en el bot\u00f3n \u00abAgregar columna\u00bb. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88950\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-ecrire-si-la-formule-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"escribir-si-f\u00f3rmula-en-poder-consulta\" width=\"460\" height=\"255\"><\/figure>\n<\/div>\n<p> Y luego, ingrese la siguiente f\u00f3rmula en la \u00abbarra de entrada de f\u00f3rmulas\u00bb.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=if [Numbers] &gt;= 1000 then \"Yes\" else \"No\"<\/code><\/pre>\n<p> Esta f\u00f3rmula tiene tres partes:<\/p>\n<ul>\n<li> si \u2013 condici\u00f3n al texto<\/li>\n<li> entonces \u2013 valor si la condici\u00f3n es verdadera.<\/li>\n<li> else: valor si la condici\u00f3n es falsa.<\/li>\n<\/ul>\n<p> Y aseg\u00farate de escribirlo todo en min\u00fasculas. A diferencia de Excel, en Power Query debes hacer referencia a las columnas completas de la f\u00f3rmula. Y tambi\u00e9n tenemos un operador mayor que igual para probar la condici\u00f3n. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88951\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-font-reference-a-des-colonnes-entieres-dans-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"consultar-columnas-completas-en-f\u00f3rmula\" width=\"658\" height=\"409\"><\/figure>\n<\/div>\n<p> Y, si desea crear un if anidado, puede hacerlo, como se muestra a continuaci\u00f3n: <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=if [Numbers] &gt;= 1000 then \"Yes\" else if [Numbers] &gt;= 500 then \"May Be\" else \"No\"<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88952\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-creer-imbrique-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"crear-anidado-si\" width=\"668\" height=\"414\"><\/figure>\n<\/div>\n<p> Al final, haga clic en Aceptar para agregar la columna. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88953\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-cliquez-sur-ok-pour-ajouter-un-nuage.png\" sizes=\"auto, \" srcset=\"\" alt=\"haga clic en Aceptar para agregar una columna\" width=\"405\" height=\"333\"><\/figure>\n<\/div>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/si-requete-de-puissance.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/div>\n<div class=\"gb-container gb-container-9e2850fe gb-container-mt\"> <a class=\"gb-button gb-button-71636faa gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/solicitud-de-energia\/\">Consulta de energ\u00eda en Excel (Tutorial)<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-c566b2ed gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-b15ed1bf gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-6e9de105\">\n<div class=\"gb-container gb-container-6e9de105\">\n<ul>\n<li> Fusionar [Combinar] M\u00faltiples ARCHIVOS de Excel en UN CUADERNO<\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/buscarv-2\/\">Realizar BUSCARV en Power Query en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/datos-sin-rotar\/\">Eliminar el pivote de datos en Excel usando Power Query<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cadena\/\">Power Query: concatenar valores (texto y n\u00fameros)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/diferencia-de-fechas\/\">Consulta de energ\u00eda: diferencia de fecha<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-4eaecde3\">\n<div class=\"gb-container gb-container-4eaecde3\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Power Query, si desea crear una declaraci\u00f3n IF, existe una opci\u00f3n espec\u00edfica que le ayudar\u00e1 a escribirla sin una f\u00f3rmula. Por ejemplo, a continuaci\u00f3n se muestra una lista de n\u00fameros (100) en la columna A. Necesita una nueva columna con declaraci\u00f3n IF para verificar si un n\u00famero es mayor o igual a 1000. Usar [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-342","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Consulta de energ\u00eda: declaraci\u00f3n if<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/si-declaracion\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Consulta de energ\u00eda: declaraci\u00f3n if\" \/>\n<meta property=\"og:description\" content=\"En Power Query, si desea crear una declaraci\u00f3n IF, existe una opci\u00f3n espec\u00edfica que le ayudar\u00e1 a escribirla sin una f\u00f3rmula. Por ejemplo, a continuaci\u00f3n se muestra una lista de n\u00fameros (100) en la columna A. Necesita una nueva columna con declaraci\u00f3n IF para verificar si un n\u00famero es mayor o igual a 1000. Usar [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/si-declaracion\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:32:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/si-declaracion\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/si-declaracion\/\",\"name\":\"Consulta de energ\u00eda: declaraci\u00f3n if\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/si-declaracion\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/si-declaracion\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png\",\"datePublished\":\"2023-11-02T15:07:50+00:00\",\"dateModified\":\"2023-12-25T10:32:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/si-declaracion\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/si-declaracion\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/si-declaracion\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/si-declaracion\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Consulta de energ\u00eda: declaraci\u00f3n if\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Consulta de energ\u00eda: declaraci\u00f3n if","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/es\/si-declaracion\/","og_locale":"es_ES","og_type":"article","og_title":"Consulta de energ\u00eda: declaraci\u00f3n if","og_description":"En Power Query, si desea crear una declaraci\u00f3n IF, existe una opci\u00f3n espec\u00edfica que le ayudar\u00e1 a escribirla sin una f\u00f3rmula. Por ejemplo, a continuaci\u00f3n se muestra una lista de n\u00fameros (100) en la columna A. Necesita una nueva columna con declaraci\u00f3n IF para verificar si un n\u00famero es mayor o igual a 1000. Usar [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/si-declaracion\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:32:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/si-declaracion\/","url":"https:\/\/exceladvisor.org\/es\/si-declaracion\/","name":"Consulta de energ\u00eda: declaraci\u00f3n if","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/si-declaracion\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/si-declaracion\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png","datePublished":"2023-11-02T15:07:50+00:00","dateModified":"2023-12-25T10:32:46+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/si-declaracion\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/si-declaracion\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/si-declaracion\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/si-declaracion\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"Consulta de energ\u00eda: declaraci\u00f3n if"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=342"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/342\/revisions"}],"predecessor-version":[{"id":1437,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/342\/revisions\/1437"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}