{"id":251087,"date":"2022-06-08T06:52:55","date_gmt":"2022-06-08T06:52:55","guid":{"rendered":"http:\/\/sftarticles.wpenginepowered.com\/es\/?p=251087"},"modified":"2024-08-08T12:57:26","modified_gmt":"2024-08-08T10:57:26","slug":"google-sheets-formulas-basicas","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/","title":{"rendered":"Google Sheets: 7 f\u00f3rmulas b\u00e1sicas que debes conocer"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Las hojas de c\u00e1lculo forman parte de nuestro d\u00eda a d\u00eda, en especial si trabajamos con datos o informaciones que necesitan de un correcto tratamiento. Con la llegada de <strong>Google Sheets<\/strong>, el popular servicio propiedad del buscador dio una vuelta de tuercas a usar estas hojas, de ah\u00ed que ahora sea todav\u00eda m\u00e1s f\u00e1cil acceder a ellas.<\/p>\n\n\n<div class=\"sc-card-program\">\r\n  <div class=\"sc-card-program__body\">\r\n    <div class=\"sc-card-program__row clearfix\">\r\n      <div class=\"sc-card-program__col-logo\">\r\n        <img decoding=\"async\" class=\"sc-card-program__img\" src=\"https:\/\/images.sftcdn.net\/images\/t_app-logo-xl,f_auto\/p\/6be60c89-63c3-40c9-8190-a54aff441f59\/748907252\/google-sheets-logo.png\" alt=\"Google Sheets\" width=\"100px\" height=\"100px\">\r\n      <\/div>\r\n      <div class=\"sc-card-program__col-title\">\r\n        <span class=\"sc-card-program__title\">Google Sheets<\/span>\r\n        <a class=\"sc-card-program__button sc-card-program-internal\" href=\"https:\/\/google-sheets.softonic\" target=\"_self\" rel=\"noopener noreferrer\">DESCARGAR<\/a>\r\n      <\/div>\r\n      <div class=\"sc-card-program__col-rating\">\r\n        <svg class=\"rating-score__content\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.1\" x=\"0\" y=\"0\" viewbox=\"0 0 50 50\" enable-background=\"new 0 0 50 50\" xml:space=\"preserve\"><path class=\"rating-score__background rating-score--good\" fill=\"none\" stroke-width=\"6\" stroke-miterlimit=\"10\" d=\"M40 40c8.3-8.3 8.3-21.7 0-30s-21.7-8.3-30 0 -8.3 21.7 0 30\"><\/path><path class=\"rating-score__value rating-score__value--80\" fill=\"none\" stroke-width=\"6\" stroke-dashoffset=\"80\" stroke-miterlimit=\"10\" d=\"M40 40c8.3-8.3 8.3-21.7 0-30s-21.7-8.3-30 0 -8.3 21.7 0 30\"><\/path><text class=\"rating-score__number\" content=\"8\" text-anchor=\"middle\" transform=\"matrix(1 0 0 1 25 31.0837)\" data-auto=\"app-user-score\">8<\/text><\/svg>\r\n      <\/div>\r\n    <\/div>\r\n    <div class=\"sc-card-program__row\">\r\n      <span class=\"sc-card-program__description\"><\/span>\r\n    <\/div>\r\n    <div class=\"sc-card-program__row\">\r\n      <img decoding=\"async\" class=\"sc-card-program__bigpic\" src=\"\" onerror=\"this.style.display='none'\">\r\n    <\/div>\r\n    <a class=\"sc-card-program__link track-link sc-card-program-internal\" href=\"https:\/\/google-sheets.softonic\" target=\"_self\" rel=\"noopener noreferrer\"><\/a>\r\n  <\/div>\r\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Si est\u00e1s empezando en el \u201capasionante\u201d mucho de las hojas de c\u00e1lculo, este art\u00edculo te va a gustar mucho: te ense\u00f1amos <strong>7 f\u00f3rmulas o funciones b\u00e1sicas que debes conocer en Google Sheets<\/strong>. Para que vayas abriendo apetito.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Formulaciones simples<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Sumar<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Empezamos con una de las f\u00f3rmulas m\u00e1s f\u00e1ciles y asequibles: <strong>la de sumar celdas<\/strong>. Gracias a esta ecuaci\u00f3n, podremos sumar los d\u00edgitos que aparecen dentro de las celdas para que nos d\u00e9 un resultado total. Para ello, la sintaxis es (sin espacios):<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=SUM (valor 1; valor 2) | =SUM (celda 1 ; celda 2)<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Por tanto, si quisi\u00e9ramos sumar contenido y\/o celdas, el ejemplo ser\u00eda:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=SUM(10,10,10) o =SUM(A1;A10). <\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">De esta manera, se sumar\u00edan los n\u00fameros consecutivos, mientras que con la segunda f\u00f3rmula se sumar\u00edan todas las celdas de la 1 a la 10.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"464\" height=\"280\" src=\"https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/2\/2022\/06\/google-sheets-sumar.jpg\" alt=\"\" class=\"wp-image-251093\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2. Fecha y hora<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Una f\u00f3rmula perfecta para saber siempre en qu\u00e9 d\u00eda se est\u00e1 haciendo esa hoja de c\u00e1lculo en cuesti\u00f3n:<strong> la de fecha y hora<\/strong>. Para ello, basta con escribir:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=NOW()<\/strong><\/li><li><strong>=TODAY()<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Con la primera se muestra la fecha y hora, mientras que con la segunda nos quedamos s\u00f3lo con la fecha actual (sin la hora). Para encabezar tus hojas de c\u00e1lculo es perfecta esta f\u00f3rmula.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"623\" height=\"147\" src=\"https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/2\/2022\/06\/google-sheets-hora.jpg\" alt=\"\" class=\"wp-image-251094\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3. Insertar una imagen<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Aunque se puede introducir una imagen desde \u201cInsertar\u201d -&gt; \u201cImagen\u201d, existe otra manera alternativa de hacer esto mediante una direcci\u00f3n web, es decir, <strong>a trav\u00e9s de la URL<\/strong> que acabe en JPG, PNG, etc. Para ello, la f\u00f3rmula a introducir es la siguiente (sin espacios):<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=IMAGE (\u201cURLDELAWEB.PNG\u201d)<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Si la queremos con un tama\u00f1o personalizado, el comando var\u00eda al siguiente:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=IMAGE(\u201cURLDELAWEB.PNG\u201d,10,40,100)<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">F\u00e1cil, \u00bfverdad? Pues ahora a sacarle partido.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1023\" height=\"115\" src=\"https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/2\/2022\/06\/google-sheets-imagen.jpg\" alt=\"\" class=\"wp-image-251095\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">4. Eliminar caracteres no imprimibles<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Imprimir una hoja de c\u00e1lculo no es siempre la mejor opci\u00f3n. Es importante tener controlado el tama\u00f1o, la orientaci\u00f3n y muchos factores, como puede ser el caso de contar o no con caracteres especiales. Si tu sheet posee estos caracteres, la impresora va a imprimirlos, as\u00ed que tienes que introducir la siguiente f\u00f3rmula:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=CLEAN(y la celda)<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">De esta manera, si lo que buscas es que la celda B2 no tenga ning\u00fan car\u00e1cter raro, <strong>tan s\u00f3lo escribe esta ecuaci\u00f3n y se quitar\u00e1n todos<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. Traducir contenido<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Lo hemos repetido en innumerables ocasiones\u2026 y vamos a seguir haci\u00e9ndolo: intenta no usar traductores autom\u00e1ticos en la medida de lo posible, sobre todo en materia laboral o acad\u00e9mica. No obstante, y si no existe m\u00e1s remedio, <strong>Google Sheets permite utilizar Google Translate de manera directa en las celdas<\/strong>. S\u00ed, tal como lo oyes. La formulaci\u00f3n es la siguiente (sin espacios):<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=Googletranslate (Valor1; \u201cidioma 1\u201d; \u201cidioma 2\u201d)<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Como siempre, colocamos un ejemplo para que veas c\u00f3mo funciona:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=Googletranslate(A1;\u201dEn\u201d;\u201dEs)<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">En primer lugar, seleccionamos la celda a traducir y luego ponemos en segunda posici\u00f3n el idioma original y en tercera al que queremos traducirlo. Y listo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"626\" height=\"78\" src=\"https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/2\/2022\/06\/google-sheets-translate.jpg\" alt=\"\" class=\"wp-image-251091\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">6. Convertir valores<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u00bfCu\u00e1ntos kilos son estos gramos? \u00bfY a cu\u00e1ntos metros corresponden estos kil\u00f3metros? Preguntas b\u00e1sicas, pero que Google Sheets puede ayudarte a responder con una f\u00f3rmula, una vez m\u00e1s, muy sencilla. Basta con escribir (sin espacios):<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=Convert (\u201cvalor\u201d; \u201cunidad original\u201d; \u201cunidad de destino\u201d)<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Con esto sobre la mesa, ah\u00ed va el ejemplo de siempre:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=Convert(\u201c10\u201d;\u201dg\u201d;\u201dkg\u201d)<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Con esta f\u00f3rmula, le estar\u00edamos preguntando a Google Sheets cu\u00e1ntos kilos son 10 gramos. La celda donde hayamos creado la ecuaci\u00f3n nos devolver\u00e1 el resultado de manera autom\u00e1tica en menos de un segundo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"465\" height=\"102\" src=\"https:\/\/articles-img.sftcdn.net\/sft\/articles\/auto-mapping-folder\/sites\/2\/2022\/06\/google-sheets-convertir.jpg\" alt=\"\" class=\"wp-image-251092\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Y el truco universal<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">7. Todas las f\u00f3rmulas<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Espera, tranquilo, no entres en un ataque de p\u00e1nico. Si hemos puesto en s\u00e9ptima posici\u00f3n el \u201ctodas las f\u00f3rmulas\u201d es por una raz\u00f3n: el propio <strong>Google Sheets te permite ver todas las combinaciones posibles<\/strong> de una manera muy simple. Basta con escribir en el caj\u00f3n correspondiente lo siguiente:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>=(<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">S\u00ed, parece el emoji de una cara triste, pero es un signo igual y un par\u00e9ntesis de apertura. Con esas dos teclas, Google Sheets te va a mostrar literalmente todas las f\u00f3rmulas que existen. Como es obvio, las resume en una vista r\u00e1pida, as\u00ed que escr\u00edbele una letra detr\u00e1s para ver las posibilidades).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Paciencia, la madre de todas las ciencias<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">No vamos a enga\u00f1arte: conocer todas las f\u00f3rmulas de Google Sheets es una tarea ardua y complicada; de hecho, dudamos que alguna persona sea capaz de saberse todas las formulaciones. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Por lo general, siempre se recurre a las mismas, as\u00ed que <strong>apr\u00e9ndete aquellas que sean m\u00e1s f\u00e1ciles<\/strong> para tu trabajo y <a href=\"https:\/\/google-sheets.softonic.com\/articulos\/complementos-esenciales-google-sheets\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"opta por las extensiones\">opta por las extensiones de Google Sheets<\/a> para sacar m\u00e1s potencial a las hojas de c\u00e1lculo. Eso es lo que hacemos nosotros\u2026 \u00a1y merece mucho la pena el tiempo que ahorras!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Las hojas de c\u00e1lculo forman parte de nuestro d\u00eda a d\u00eda, en especial si trabajamos con datos o informaciones que necesitan de un correcto tratamiento. Con la llegada de Google Sheets, el popular servicio propiedad del buscador dio una vuelta de tuercas a usar estas hojas, de ah\u00ed que ahora sea todav\u00eda m\u00e1s f\u00e1cil acceder &hellip; <a href=\"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Google Sheets: 7 f\u00f3rmulas b\u00e1sicas que debes conocer&#8221;<\/span><\/a><\/p>\n","protected":false},"author":9091,"featured_media":251089,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wpcf-pageviews":0},"categories":[9743,9706],"tags":[10339],"usertag":[],"vertical":[],"content-category":[],"class_list":["post-251087","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-guides","category-how-to","tag-app-subdomain-redirectiongoogle-sheets"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"Google Sheets posee decenas y decenas de funciones y f\u00f3rmulas para sacarle partido. Te ense\u00f1amos cu\u00e1les son las 7 m\u00e1s populares si est\u00e1s aprendiendo.\" \/>\n\t<meta name=\"robots\" content=\"noindex, nofollow, max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Nacho Requena Molina\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"es_ES\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Softonic Spain - Just another Softonic Sites site\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"F\u00f3rmulas b\u00e1sicas para Google Sheets - Softonic Spain\" \/>\n\t\t<meta property=\"og:description\" content=\"Google Sheets posee decenas y decenas de funciones y f\u00f3rmulas para sacarle partido. Te ense\u00f1amos cu\u00e1les son las 7 m\u00e1s populares si est\u00e1s aprendiendo.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2022-06-08T06:52:55+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-08-08T10:57:26+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"F\u00f3rmulas b\u00e1sicas para Google Sheets - Softonic Spain\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Google Sheets posee decenas y decenas de funciones y f\u00f3rmulas para sacarle partido. Te ense\u00f1amos cu\u00e1les son las 7 m\u00e1s populares si est\u00e1s aprendiendo.\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#blogposting\",\"name\":\"F\\u00f3rmulas b\\u00e1sicas para Google Sheets - Softonic Spain\",\"headline\":\"Google Sheets: 7 f\\u00f3rmulas b\\u00e1sicas que debes conocer\",\"author\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/author\\\/nrequenaext\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/articles-img.sftcdn.net\\\/auto-mapping-folder\\\/sites\\\/2\\\/2022\\\/06\\\/google-sheets.jpg\",\"width\":1200,\"height\":675},\"datePublished\":\"2022-06-08T06:52:55+02:00\",\"dateModified\":\"2024-08-08T12:57:26+02:00\",\"inLanguage\":\"es-ES\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#webpage\"},\"articleSection\":\"Guides, Trucos y Consejos, app-subdomain-redirection:google-sheets\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/#listItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/category\\\/how-to\\\/#listItem\",\"name\":\"Trucos y Consejos\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/category\\\/how-to\\\/#listItem\",\"position\":2,\"name\":\"Trucos y Consejos\",\"item\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/category\\\/how-to\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#listItem\",\"name\":\"Google Sheets: 7 f\\u00f3rmulas b\\u00e1sicas que debes conocer\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/#listItem\",\"name\":\"Inicio\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#listItem\",\"position\":3,\"name\":\"Google Sheets: 7 f\\u00f3rmulas b\\u00e1sicas que debes conocer\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/category\\\/how-to\\\/#listItem\",\"name\":\"Trucos y Consejos\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/#organization\",\"name\":\"Softonic Spain\",\"description\":\"Just another Softonic Sites site\",\"url\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/author\\\/nrequenaext\\\/#author\",\"url\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/author\\\/nrequenaext\\\/\",\"name\":\"Nacho Requena Molina\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e155d4887623b2713bc6315dd7152cab2719337c42d1e96ccb0aaac292df338?s=96&d=https%3A%2F%2Farticles-images.sftcdn.net%2Fwp-content%2Fuploads%2Fsoftonic_avatar.png&r=g\",\"width\":96,\"height\":96,\"caption\":\"Nacho Requena Molina\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#webpage\",\"url\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/\",\"name\":\"F\\u00f3rmulas b\\u00e1sicas para Google Sheets - Softonic Spain\",\"description\":\"Google Sheets posee decenas y decenas de funciones y f\\u00f3rmulas para sacarle partido. Te ense\\u00f1amos cu\\u00e1les son las 7 m\\u00e1s populares si est\\u00e1s aprendiendo.\",\"inLanguage\":\"es-ES\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/author\\\/nrequenaext\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/author\\\/nrequenaext\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/articles-img.sftcdn.net\\\/auto-mapping-folder\\\/sites\\\/2\\\/2022\\\/06\\\/google-sheets.jpg\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#mainImage\",\"width\":1200,\"height\":675},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/google-sheets-formulas-basicas\\\/#mainImage\"},\"datePublished\":\"2022-06-08T06:52:55+02:00\",\"dateModified\":\"2024-08-08T12:57:26+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/#website\",\"url\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/\",\"name\":\"Softonic Spain\",\"description\":\"Just another Softonic Sites site\",\"inLanguage\":\"es-ES\",\"publisher\":{\"@id\":\"https:\\\/\\\/cms-articles.softonic.io\\\/es\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"F\u00f3rmulas b\u00e1sicas para Google Sheets - Softonic Spain","description":"Google Sheets posee decenas y decenas de funciones y f\u00f3rmulas para sacarle partido. Te ense\u00f1amos cu\u00e1les son las 7 m\u00e1s populares si est\u00e1s aprendiendo.","canonical_url":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/","robots":"noindex, nofollow, max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#blogposting","name":"F\u00f3rmulas b\u00e1sicas para Google Sheets - Softonic Spain","headline":"Google Sheets: 7 f\u00f3rmulas b\u00e1sicas que debes conocer","author":{"@id":"https:\/\/cms-articles.softonic.io\/es\/author\/nrequenaext\/#author"},"publisher":{"@id":"https:\/\/cms-articles.softonic.io\/es\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/2\/2022\/06\/google-sheets.jpg","width":1200,"height":675},"datePublished":"2022-06-08T06:52:55+02:00","dateModified":"2024-08-08T12:57:26+02:00","inLanguage":"es-ES","mainEntityOfPage":{"@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#webpage"},"isPartOf":{"@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#webpage"},"articleSection":"Guides, Trucos y Consejos, app-subdomain-redirection:google-sheets"},{"@type":"BreadcrumbList","@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/cms-articles.softonic.io\/es\/#listItem","position":1,"name":"Inicio","item":"https:\/\/cms-articles.softonic.io\/es\/","nextItem":{"@type":"ListItem","@id":"https:\/\/cms-articles.softonic.io\/es\/category\/how-to\/#listItem","name":"Trucos y Consejos"}},{"@type":"ListItem","@id":"https:\/\/cms-articles.softonic.io\/es\/category\/how-to\/#listItem","position":2,"name":"Trucos y Consejos","item":"https:\/\/cms-articles.softonic.io\/es\/category\/how-to\/","nextItem":{"@type":"ListItem","@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#listItem","name":"Google Sheets: 7 f\u00f3rmulas b\u00e1sicas que debes conocer"},"previousItem":{"@type":"ListItem","@id":"https:\/\/cms-articles.softonic.io\/es\/#listItem","name":"Inicio"}},{"@type":"ListItem","@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#listItem","position":3,"name":"Google Sheets: 7 f\u00f3rmulas b\u00e1sicas que debes conocer","previousItem":{"@type":"ListItem","@id":"https:\/\/cms-articles.softonic.io\/es\/category\/how-to\/#listItem","name":"Trucos y Consejos"}}]},{"@type":"Organization","@id":"https:\/\/cms-articles.softonic.io\/es\/#organization","name":"Softonic Spain","description":"Just another Softonic Sites site","url":"https:\/\/cms-articles.softonic.io\/es\/"},{"@type":"Person","@id":"https:\/\/cms-articles.softonic.io\/es\/author\/nrequenaext\/#author","url":"https:\/\/cms-articles.softonic.io\/es\/author\/nrequenaext\/","name":"Nacho Requena Molina","image":{"@type":"ImageObject","@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/4e155d4887623b2713bc6315dd7152cab2719337c42d1e96ccb0aaac292df338?s=96&d=https%3A%2F%2Farticles-images.sftcdn.net%2Fwp-content%2Fuploads%2Fsoftonic_avatar.png&r=g","width":96,"height":96,"caption":"Nacho Requena Molina"}},{"@type":"WebPage","@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#webpage","url":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/","name":"F\u00f3rmulas b\u00e1sicas para Google Sheets - Softonic Spain","description":"Google Sheets posee decenas y decenas de funciones y f\u00f3rmulas para sacarle partido. Te ense\u00f1amos cu\u00e1les son las 7 m\u00e1s populares si est\u00e1s aprendiendo.","inLanguage":"es-ES","isPartOf":{"@id":"https:\/\/cms-articles.softonic.io\/es\/#website"},"breadcrumb":{"@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#breadcrumblist"},"author":{"@id":"https:\/\/cms-articles.softonic.io\/es\/author\/nrequenaext\/#author"},"creator":{"@id":"https:\/\/cms-articles.softonic.io\/es\/author\/nrequenaext\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/2\/2022\/06\/google-sheets.jpg","@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#mainImage","width":1200,"height":675},"primaryImageOfPage":{"@id":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/#mainImage"},"datePublished":"2022-06-08T06:52:55+02:00","dateModified":"2024-08-08T12:57:26+02:00"},{"@type":"WebSite","@id":"https:\/\/cms-articles.softonic.io\/es\/#website","url":"https:\/\/cms-articles.softonic.io\/es\/","name":"Softonic Spain","description":"Just another Softonic Sites site","inLanguage":"es-ES","publisher":{"@id":"https:\/\/cms-articles.softonic.io\/es\/#organization"}}]},"og:locale":"es_ES","og:site_name":"Softonic Spain - Just another Softonic Sites site","og:type":"article","og:title":"F\u00f3rmulas b\u00e1sicas para Google Sheets - Softonic Spain","og:description":"Google Sheets posee decenas y decenas de funciones y f\u00f3rmulas para sacarle partido. Te ense\u00f1amos cu\u00e1les son las 7 m\u00e1s populares si est\u00e1s aprendiendo.","og:url":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/","article:published_time":"2022-06-08T06:52:55+00:00","article:modified_time":"2024-08-08T10:57:26+00:00","twitter:card":"summary","twitter:title":"F\u00f3rmulas b\u00e1sicas para Google Sheets - Softonic Spain","twitter:description":"Google Sheets posee decenas y decenas de funciones y f\u00f3rmulas para sacarle partido. Te ense\u00f1amos cu\u00e1les son las 7 m\u00e1s populares si est\u00e1s aprendiendo."},"aioseo_meta_data":{"post_id":"251087","title":"F\u00f3rmulas b\u00e1sicas para Google Sheets #separator_sa #site_title","description":"Google Sheets posee decenas y decenas de funciones y f\u00f3rmulas para sacarle partido. Te ense\u00f1amos cu\u00e1les son las 7 m\u00e1s populares si est\u00e1s aprendiendo.","keywords":[],"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":null,"isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"limit_modified_date":false,"created":"2022-06-07 21:11:13","updated":"2024-08-11 08:10:46","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/cms-articles.softonic.io\/es\/\" title=\"Inicio\">Inicio<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/cms-articles.softonic.io\/es\/category\/how-to\/\" title=\"Trucos y Consejos\">Trucos y Consejos<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tGoogle Sheets: 7 f\u00f3rmulas b\u00e1sicas que debes conocer\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Inicio","link":"https:\/\/cms-articles.softonic.io\/es\/"},{"label":"Trucos y Consejos","link":"https:\/\/cms-articles.softonic.io\/es\/category\/how-to\/"},{"label":"Google Sheets: 7 f\u00f3rmulas b\u00e1sicas que debes conocer","link":"https:\/\/cms-articles.softonic.io\/es\/google-sheets-formulas-basicas\/"}],"_links":{"self":[{"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/posts\/251087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/users\/9091"}],"replies":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/comments?post=251087"}],"version-history":[{"count":0,"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/posts\/251087\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/media\/251089"}],"wp:attachment":[{"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/media?parent=251087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/categories?post=251087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/tags?post=251087"},{"taxonomy":"usertag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/usertag?post=251087"},{"taxonomy":"vertical","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/vertical?post=251087"},{"taxonomy":"content-category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/es\/wp-json\/wp\/v2\/content-category?post=251087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}