{"id":31,"date":"2023-11-20T01:48:26","date_gmt":"2023-11-20T01:48:26","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/"},"modified":"2023-12-25T10:27:54","modified_gmt":"2023-12-25T10:27:54","slug":"concatenar-si-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/","title":{"rendered":"\u00bfc\u00f3mo utilizar combinaci\u00f3n si con condici\u00f3n?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1053269023\"><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 Excel, existen dos m\u00e9todos para utilizar la f\u00f3rmula de concatenaci\u00f3n.<\/p>\n<ul>\n<li> Por columna<\/li>\n<li> Por lineas<\/li>\n<\/ul>\n<p> Y tenemos dos funciones diferentes para escribir estas f\u00f3rmulas. Entonces, en este tutorial, aprenderemos los cuatro m\u00e9todos.<\/p>\n<h2 class=\"wp-block-heading\"> Concatenar con IF usando la funci\u00f3n CONCAT<\/h2>\n<h3 class=\"wp-block-heading\"> 1. Por columna<\/h3>\n<p> Esta f\u00f3rmula es bastante simple. Aqu\u00ed estamos probando si el valor \u201cA\u201d est\u00e1 en la columna A. Y si est\u00e1 ah\u00ed, combina los valores de las columnas A y B. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83621\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"concatenar-con-si\" width=\"506\" height=\"385\"><\/figure>\n<\/div>\n<p> Usamos las funciones CONCAT e IF. En la funci\u00f3n SI, hemos especificado una condici\u00f3n para probar si el valor de la celda A1 es \u00abA\u00bb. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83622\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-concatener-et-si-combine.png\" sizes=\"auto, \" srcset=\"\" alt=\"concatenar-y-si-combinar\" width=\"344\" height=\"75\"><\/figure>\n<\/div>\n<p> Y si el valor es A, devuelve el rango A1:B1; de lo contrario, un valor vac\u00edo. En \u00faltima instancia, CONCAT utiliza el rango devuelto por IF y combina los valores.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CONCAT(IF(A1=\"A\",A1:B1,\"\"))<\/code><\/pre>\n<h3 class=\"wp-block-heading\"> 2. Por filas (+ columnas)<\/h3>\n<p> Ahora digamos que quieres concatenar los valores de todas las filas usando una condici\u00f3n. En este caso puedes utilizar la misma f\u00f3rmula pero debes referirte a todo el rango. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83623\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-valeurs-de-concatenation-a-laide-dune-condition.png\" sizes=\"auto, \" srcset=\"\" alt=\"concatenar-valores-usando-una-condici\u00f3n\" width=\"542\" height=\"401\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CONCAT(IF(A1:A4=\"A\",A1:B4,\"\"))<\/code><\/pre>\n<p> En esta f\u00f3rmula, IF verifica el valor A&#8217; en todo el rango A1:A4. VERDADERO para la celda con el valor y FALSO para el resto. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83624\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-concat-avec-if-pour-verifier-letat.png\" sizes=\"auto, \" srcset=\"\" alt=\"concat-con-si-verificar-condici\u00f3n\" width=\"567\" height=\"116\"><\/figure>\n<\/div>\n<p> Y luego devuelve filas del rango A1:B4 donde el valor es \u00abA\u00bb 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-83625\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-lignes-renvoyees-par-condition-appliquee.png\" sizes=\"auto, \" srcset=\"\" alt=\"filas-devueltas-por-condici\u00f3n-aplicada\" width=\"455\" height=\"342\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Concatenar con IF usando la funci\u00f3n TEXTJOIN<\/h2>\n<h3 class=\"wp-block-heading\"> 1. Por columnas<\/h3>\n<p> Una vez que inserte la funci\u00f3n TEXTJOIN, deber\u00e1 especificar el delimitador. Y tambi\u00e9n si quieres ignorar las celdas vac\u00edas o no. Despu\u00e9s de eso, debes usar la funci\u00f3n SI como la usaste en el m\u00e9todo anterior. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83626\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-concatener-avec-si-vous-utilisez-textjoin.png\" sizes=\"auto, \" srcset=\"\" alt=\"concatenaci\u00f3n-con-si-uso-textjoin\" width=\"508\" height=\"394\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\",\",TRUE,IF(A1=\"A\",A1:B1,\"\"))<\/code><\/pre>\n<p> IF solo devuelve valores de rango si una celda de la columna A tiene el valor \u00abA\u00bb.<\/p>\n<h3 class=\"wp-block-heading\"> 2. Por filas<\/h3>\n<p> Y de manera similar, puedes concatenar valores de varias filas usando una condici\u00f3n.<\/p>\n<p> Por ejemplo, en la siguiente f\u00f3rmula, ha hecho referencia a todo el rango A1:A4 para la condici\u00f3n que se va a probar. Y al rango A1:B4 para que el valor se combine. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\",\",TRUE,IF(A1:A4=\"A\",A1:B4,\"\"))<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83627\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-textjoin-avec-si-par-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"uni\u00f3n de texto con si por filas\" width=\"550\" height=\"365\"><\/figure>\n<\/div>\n<p> En el resultado tenemos los valores A,1,A,3, de las celdas A1, B1, A3 y B3.<\/p>\n<p> Con la funci\u00f3n SI, probamos una condici\u00f3n en la columna A. Devuelve los valores de las filas donde el valor de la celda en la columna A es \u00abA\u00bb. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83628\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-concatener-la-valeur-resultante.png\" sizes=\"auto, \" srcset=\"\" alt=\"valor-resultado-concatenaci\u00f3n\" width=\"565\" height=\"158\"><\/figure>\n<\/div>\n<p> TEXTJOIN ignora los valores vac\u00edos y, utilizando el delimitador, combina todos los valores en uno. <\/p>\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\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" style=\"font-size: 16px;\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a> <\/h2>\n<\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\">\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> Marque IF 0 (cero) y luego en blanco en Excel<\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/comprobar-si-existe-un-valor-en-un-rango\/\">Comprobar si existe un valor en un rango en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-y-1\/\">Combina funciones IF y AND en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-o-1\/\">Combina funciones SI y O en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-la-celda-esta-vacia\/\">SI la celda est\u00e1 vac\u00eda usando IF + ESBLANCO en Excel<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, existen dos m\u00e9todos para utilizar la f\u00f3rmula de concatenaci\u00f3n. Por columna Por lineas Y tenemos dos funciones diferentes para escribir estas f\u00f3rmulas. Entonces, en este tutorial, aprenderemos los cuatro m\u00e9todos. Concatenar con IF usando la funci\u00f3n CONCAT 1. Por columna Esta f\u00f3rmula es bastante simple. Aqu\u00ed estamos probando si el valor \u201cA\u201d est\u00e1 [&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-31","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>\u00bfc\u00f3mo utilizar combinaci\u00f3n si con condici\u00f3n?<\/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\/concatenar-si-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar combinaci\u00f3n si con condici\u00f3n?\" \/>\n<meta property=\"og:description\" content=\"En Excel, existen dos m\u00e9todos para utilizar la f\u00f3rmula de concatenaci\u00f3n. Por columna Por lineas Y tenemos dos funciones diferentes para escribir estas f\u00f3rmulas. Entonces, en este tutorial, aprenderemos los cuatro m\u00e9todos. Concatenar con IF usando la funci\u00f3n CONCAT 1. Por columna Esta f\u00f3rmula es bastante simple. Aqu\u00ed estamos probando si el valor \u201cA\u201d est\u00e1 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/\",\"name\":\"\u00bfc\u00f3mo utilizar combinaci\u00f3n si con condici\u00f3n?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png\",\"datePublished\":\"2023-11-20T01:48:26+00:00\",\"dateModified\":\"2023-12-25T10:27:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar combinaci\u00f3n si con condici\u00f3n?\"}]},{\"@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":"\u00bfc\u00f3mo utilizar combinaci\u00f3n si con condici\u00f3n?","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\/concatenar-si-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar combinaci\u00f3n si con condici\u00f3n?","og_description":"En Excel, existen dos m\u00e9todos para utilizar la f\u00f3rmula de concatenaci\u00f3n. Por columna Por lineas Y tenemos dos funciones diferentes para escribir estas f\u00f3rmulas. Entonces, en este tutorial, aprenderemos los cuatro m\u00e9todos. Concatenar con IF usando la funci\u00f3n CONCAT 1. Por columna Esta f\u00f3rmula es bastante simple. Aqu\u00ed estamos probando si el valor \u201cA\u201d est\u00e1 [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/","url":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/","name":"\u00bfc\u00f3mo utilizar combinaci\u00f3n si con condici\u00f3n?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png","datePublished":"2023-11-20T01:48:26+00:00","dateModified":"2023-12-25T10:27:54+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/concatenar-si-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar combinaci\u00f3n si con condici\u00f3n?"}]},{"@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\/31","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=31"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/31\/revisions"}],"predecessor-version":[{"id":1244,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/31\/revisions\/1244"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}