{"id":2020,"date":"2018-11-22T19:05:03","date_gmt":"2018-11-22T19:05:03","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=2020"},"modified":"2023-06-12T17:31:37","modified_gmt":"2023-06-12T17:31:37","slug":"mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/","title":{"rendered":"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos"},"content":{"rendered":"<h2>Ejemplos de funciones en Excel.<\/h2>\n<p>Ocurre que ten\u00eda muchos ejemplos guardados de un taller de hace unos meses. Aqu\u00e9l taller incluye mucho m\u00e1s material, pero me pareci\u00f3 que era buena idea compartir estos archivos en particular. Se trata de m\u00e1s de 40 f\u00f3rmulas con ejemplos en Google Sheets (que puedes descargar en formato Excel si lo necesitas).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2059\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/descarga.png\" alt=\"\" width=\"728\" height=\"523\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/descarga.png 728w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/descarga-300x216.png 300w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/p>\n<p>Considera que ver\u00e1s las f\u00f3rmulas seg\u00fan la configuraci\u00f3n de tu hoja de c\u00e1lculo preferida (Excel o Google Sheets), las f\u00f3rmulas se adaptar\u00e1n al idioma que tengas establecido.<\/p>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"7741409798\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>0. Operadores aritm\u00e9ticos.<\/h2>\n<p>Consulta aqu\u00ed los seis operadores matem\u00e1ticos (operadores aritm\u00e9ticos en excel) b\u00e1sicos: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1bqtJbM8q5DSsHrZ_-ME_datWN49s5TyiMU-RJoqzgw0\/edit#gid=2115301684\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>. Operadores: Suma, Resta, Multiplicaci\u00f3n, Divisi\u00f3n, Potencia, Porcentaje.<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vTsgwcM3ZnowbDGoWFZ67kCEStoa4ENdxD4eNhQoIF3Olt50Cxw4Hinzt0qidQVAdQfiPUSxSUw4xmm\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<h2>1. Operadores de comparaci\u00f3n.<\/h2>\n<p>Consulta aqu\u00ed los operadores de comparaci\u00f3n en excel y google sheets: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1QdApBEJonLsksldCXdlQxLWocT4w_Yxrcox2hAvXuGU\/edit#gid=528740086\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>. Operadores: Igual, Mayor que, Menor que, Mayor o igual que, Menor o igual que, Distinto de.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQmjJVjodRMIi3EpVCkajnndbONV9fAtDCBUAVZxOxOd-zUOPEdW2eTiaLQMfmZxD8ZQn1XUDPN5oJU\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>2. Operadores de texto.<\/h2>\n<p>Consulta aqu\u00ed los operadores de comparaci\u00f3n: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/139fGK04LiSeZKoZF-89RCRZ3X_UVksTTVA09jT1K9dI\/edit#gid=2009598473\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>. Uni\u00f3n: con espacio, sin espacio, con texto.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vRHFQXfJIacND-twkHQUVuAhkue6v_o1zIH-WhUF_n9P5e4lDqUNQNbc4WFThT0GRDPWgIeDgX4VwzX\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"4298448911\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>3. Operadores de referencia.<\/h2>\n<p>Consulta aqu\u00ed los operadores de referencia en excel y google sheets: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1aKkdvQHTt6-vdVAT_Deq_cJ2Q_6133Pjlph5hQRnsrw\/edit#gid=1524102561\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>. Rango y uni\u00f3n de rango.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vSTIn3w3Ekax-KuA1JtWkklp6ysYvLoBlnO5YrneFx9TfD0au5MauLdoICO2jmF5eakdykqXucahaC0\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>4. Funci\u00f3n =SUMA() (en ingl\u00e9s =SUM()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1St8Yv01r3k3ylQX1oghps2De734K_JkRAbnM3nsPSsk\/edit#gid=1786353355\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>. Las 5 posibilidades: manual, por columnas, por filas, por rangos combinados y con datos mixtos.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vT10pqlCnilnBbAUpAb1lM-TQBUJ5zzCtGabUOuEuthjkwm8HEC7S2dZZrAt5770LeSkgvZSBx8dUbr\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>5. Funci\u00f3n =PROMEDIO() (en ingl\u00e9s =AVERAGE()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1YR37SuqdqugCq2vxGQoDkoC2M0nuHAr3wu4CGEncluM\/edit#gid=1574816508\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>. Las 5 posibilidades: manual, por columnas, por filas, por rangos, y los casos para celdas con ceros o sin datos.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQmqeANk5yzF81umK2BO6HtJXSAtJ2n9Kj7Fr_h6BWXcpGfP72f-EV6CJaA1Pj-OGvXNv6ca9XMSM7u\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>6. Funci\u00f3n CONTAR (COUNT).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Y7-Q3WtTgyKR1dIwyXDulgsTifsq0Zvc-MRreKOrgVA\/edit#gid=1222215670\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>. Las 3 posibilidades: manual, por rangos, y los casos para celdas con ceros o sin datos.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vSKUO-QTxkCXvzSjInBOsZTATN8aoTUzUCFKrE2S6lQevkHJFvifvXISFvg8OogMgRXLken9CXhKS-V\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><br \/>\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"5242072910\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>7. Funci\u00f3n CONTARA (COUNTA).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1hnlHra-aM-T1kPcPTsKLHCP8fSsnZ_aV8B2uvEF_DBo\/edit#gid=339481585\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQCBBlTD9sCcVw2pqnB-OT8y5QOb0oYvK7jJnww3Z4_6hCuUndKthzDpmSL8oyYfWkNj0gQLznyoasb\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>8. Funci\u00f3n =MAX() (en ingl\u00e9s =MAX()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1BK6PFLBEvl-mTUHvMKW-CQQDSiYNDETn0DXQqu-f7Gg\/edit#gid=1498116638\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vRFk-_Yfa3cL5yvo_qUbL6U8wvwFmiklxdaLykvFWfONySe2bJb6FW5qlZXFKGsXPwlu3EmyidWYE0Q\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>9. Funci\u00f3n MIN (MIN).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1xEdFMFRs10HCJyHm5W6UVkfdfW4IZw3uNhco0Hzt_Co\/edit#gid=1800155887\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQ92N2yCxDiMR9XDVzAw0p2IqfYN-XKyViNfplEO1CWPaKyzQD3ctjz3x2gx5sffxYsRO3Oa_Fg6OUz\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>10. Funci\u00f3n =SUMARSI() (en ingl\u00e9s =SUMIF()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1AiQaJUogHLEq7LuL-_ARdWtyf0VwsTB5TDWLExJY46E\/edit#gid=672295908\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>. Tenemos seis casos.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vTTr25SHdXQ1AJRXuPnOX0gxPtPAljK38IC-FLzf9YFBbI412O9coQ-MI1ST5o5hOdC91Vuljk6dyMi\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><br \/>\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"5573955846\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>11. Funci\u00f3n =CONTARSI() (en ingl\u00e9s =COUNTIF()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Pj0XDlwLLBBofKkN4TQSh4joOuGoKTu37BC0hahqPuE\/edit#gid=1268396244\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>. Tenemos seis casos.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQgsSdjHKw3WfEFcJXuuK1XVsLWpqq7DL2Ob4vBrghs-qNmyMheGXmR3_jYyLr7CPw0Y5EqnJ2i-oHq\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>12. Funci\u00f3n =ENTERO() (en ingl\u00e9s =INT()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1WfiLktOAT8qnuWlwqjQIepl2kEprkTKWG0Q_Hx0iEeA\/edit#gid=1734177431\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQg_pKqd7GaqZSsI65IFntrxgWu0R9KUNbvs7BBc99kWPdGF7mSdONmKpZnLJ9bW1GHPEOgFVlMuZr1\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>13. Funci\u00f3n =REDONDEAR() (en ingl\u00e9s =ROUND()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1A38ORvP63dWJWXWD4TFs-VDS35uMQRm7afwIPTS3LzM\/edit#gid=1821521101\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vTUd06iSXy7BYf8u7M-v-Kjv3kL1FmtFtI6BaXhQUrVd7-w3N8u51wpJ55ssAVxucoBK3748yV_wkOz\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>14. Funci\u00f3n =TRUNCAR() (en ingl\u00e9s =TRUNC()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1MtbODZBb-0d9cqZTEFXmP7l-9r1BA-hm5p9pwmLrOc4\/edit#gid=1340829159\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQo4A_kbBfNbsao1WvczbY0eq3BqLmnb3R1HfeMEmt0hIqEB9P3DT7qmmO3OwNtziGdFG3lrK5Z4SO4\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><br \/>\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- theFormulas4 --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"5737607377\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>15. Funci\u00f3n =RESIDUO() (en ingl\u00e9s =MOD()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1pjU_j8hBq_Gv5DMyWiulWN-KTysO8eWWoY3Qn8gILfg\/edit#gid=29308017\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vRtLdbuuKcmiai-TXPVVzQVmMhO0vluIw7wIHrtfA4OLNqQYt7lrWu_c68rnl26NNB3JVeCRr6ceCFc\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>16. Funciones de fecha: =HOY(), =AHORA(), =FECHA(), =NUM.DE.SEMANA() (en ingl\u00e9s =TODAY(), =NOW(), =DATE(), =WEEKNUM()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1sWzlO78iuNDPpsH9G71CTV4xrnpKZgf4rBgY4CA6FBA\/edit#gid=1795321974\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQLlvZfPGXrvD7BDX3sUvX4dRBCvwSkkKtQYitMHVEw7VHJGQZooqAh7-S6Ex_PK2trjW6-1qG70Zkk\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>17. Funciones de b\u00fasqueda: =COINCIDIR(), =BUSCARV(), =BUSCARH(), =INDIRECTO() (en ingl\u00e9s =MATCH(), =VLOOKUP(), =HLOOKUP(), =INDIRECT()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1H_nuvPqRD00AQDFE4pfC_NPl-633S-qjpKSeEzZD4As\/edit#gid=1283022738\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vSImjsn1F7xBWNFLa3bCKbAP_rmasGd5pYQH9jVNtAnkP_usg0L5pOphUrltI9m-NXQDlJAyLEufgOp\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>18. Funciones de texto: =TEXTO(), =MINUSC(), =MAYUSC(), =VALOR(), =LARGO(), =HALLAR(), =IZQUIERDA(), =EXTRAE() (en ingl\u00e9s =TEXT(), =LOWER(), =UPPER(), =VALUE(), =LEN(), =FIND(), =LEFT(), =MID()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1poStE62t5syqmLjO-u2QqqWD9jhbRC3zwrD8sXr1VEU\/edit#gid=976427120\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vSd2jgaF1d-rH9_Ntk9BZANdmcW5NvaQGKgo97qCjfWrCqk7bAb8cNpK4HW1AG-LMRT-qau6DAd5h01\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>19. Funciones de informaci\u00f3n: =ESBLANCO(), =ESNUMERO(), =ESTEXTO(), =ESERROR(), =ESERR() (en ingl\u00e9s =ISBLANK(), =ISNUMBER(), =ISTEXT(), =ISERROR(), =ISERR()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1-AIyD3o1FTWjthIQaiagqL0bn8qbZxdAjpkE4NSoBnY\/edit#gid=1623619719\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vRWuuZXFs6NB_g5_oi5bj2ujQqgMBZ_1otWgxC0L5lei0NoN0je7tmygAHVPyQUT-Sf3mC8Lo8T1c0T\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<h2>20. Funci\u00f3n =SI() (en ingl\u00e9s =IF()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1O3-vVT6JqOdwRYZe6Xx5Ut-iGkrJjj4WpyvM4vwMcYU\/edit#gid=963097514\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQxMRvEa2vmf8QQx_ddKMm3ONUZ-SaVIMUqoQTVj87Q45Wb39pnIRjbSeMLWH-elbFZFBqpdYcM2Uy4\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><br \/>\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- theFormulas5 --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"6397998642\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins><br \/>\n<script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h2>21. Funci\u00f3n =Y(), =O(), =IGUAL() (en ingl\u00e9s =AND(), =OR(), =EXACT()).<\/h2>\n<p>Consulta aqu\u00ed el libro de trabajo de los operadores l\u00f3gicos en excel y google sheets: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1vYRbkpItfX5J1_m8oHoapuqS52stRc8zYUVoqxOUhrM\/edit#gid=1772323132\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro de trabajo<\/a>.<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQOwJzIkb-GmCyVftz9okv0w5-l-xNsmx1B6NfLVHSDyjLg-8Wky-NSPZ8TYZPv_vhmkUgKtgUzl3va\/pubhtml?widget=true&amp;headers=false\" width=\"600\" height=\"300\"><\/iframe><\/p>\n<p>Obt\u00e9n una prueba gratuita de GSuite:<\/p>\n<p><a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/goo.gl\/ZPXKU2<\/a><\/p>\n<p><a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1913\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/google-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/google-300x200.jpg 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/google-300x200-120x80.jpg 120w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ejemplos de funciones en Excel. Ocurre que ten\u00eda muchos ejemplos guardados de un taller de hace unos meses. Aqu\u00e9l taller incluye mucho m\u00e1s material, pero me pareci\u00f3 que era buena idea compartir estos archivos en particular. Se trata de m\u00e1s <a href=\"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":2271,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,10],"tags":[56,165,218,195,158,194,215,213,89,216,214,88,59,206,172,176,175,173,174,169,60,193,187,55,171,166,199,196,207,177,181,180,178,179,186,99,192,189,197,107,184,212,183,203,58,200,168,167,217,208,209,170,210,211,188,182,205,204,190,185,191,201,164,104,198,57,103,101,202,159],"class_list":["post-2020","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-google-sheets","tag-ahora","tag-and","tag-average","tag-buscarh","tag-buscarv","tag-coincidir","tag-contar","tag-contara","tag-contarsi","tag-count","tag-counta","tag-countif","tag-date","tag-entero","tag-esblanco","tag-eserr","tag-eserror","tag-esnumero","tag-estexto","tag-exact","tag-fecha","tag-find","tag-hallar","tag-hoy","tag-if","tag-igual","tag-indirect","tag-indirecto","tag-int","tag-isblank","tag-iserr","tag-iserror","tag-isnumber","tag-istext","tag-largo","tag-left","tag-len","tag-lower","tag-match","tag-max","tag-mayusc","tag-min","tag-minusc","tag-mod","tag-now","tag-num-de-semana","tag-o","tag-or","tag-promedio","tag-redondear","tag-round","tag-si","tag-sumarsi","tag-sumif","tag-text","tag-texto","tag-trunc","tag-truncar","tag-upper","tag-valor","tag-value","tag-weeknum","tag-y","tag-extrae","tag-hlookup","tag-today","tag-izquierda","tag-mid","tag-residuo","tag-vlookup"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"google sheets f\u00f3rmulas, f\u00f3rmulas google sheets, f\u00f3rmulas en excel. Todos est\u00e1n listos para que hagas tu copia y empieces y empieces a usarlos\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"google sheets f\u00f3rmulas, f\u00f3rmulas google sheets, f\u00f3rmulas en excel. Todos est\u00e1n listos para que hagas tu copia y empieces y empieces a usarlos\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence MX\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-22T19:05:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-12T17:31:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/formulas2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"573\" \/>\n\t<meta property=\"og:image:height\" content=\"374\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:site\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"V\u00edctor Urbina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos\",\"datePublished\":\"2018-11-22T19:05:03+00:00\",\"dateModified\":\"2023-06-12T17:31:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/\"},\"wordCount\":637,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/formula.jpg\",\"keywords\":[\"=AHORA()\",\"=AND()\",\"=AVERAGE()\",\"=BUSCARH()\",\"=BUSCARV()\",\"=COINCIDIR()\",\"=CONTAR()\",\"=CONTARA()\",\"=CONTARSI()\",\"=COUNT()\",\"=COUNTA()\",\"=COUNTIF()\",\"=DATE()\",\"=ENTERO()\",\"=ESBLANCO()\",\"=ESERR()\",\"=ESERROR()\",\"=ESNUMERO()\",\"=ESTEXTO()\",\"=EXACT()\",\"=FECHA()\",\"=FIND()\",\"=HALLAR()\",\"=HOY()\",\"=IF()\",\"=IGUAL()\",\"=INDIRECT()\",\"=INDIRECTO()\",\"=INT()\",\"=ISBLANK()\",\"=ISERR()\",\"=ISERROR()\",\"=ISNUMBER()\",\"=ISTEXT()\",\"=LARGO()\",\"=LEFT()\",\"=LEN()\",\"=LOWER()\",\"=MATCH()\",\"=MAX()\",\"=MAYUSC()\",\"=MIN()\",\"=MINUSC()\",\"=MOD()\",\"=NOW()\",\"=NUM.DE.SEMANA()\",\"=O()\",\"=OR()\",\"=PROMEDIO()\",\"=REDONDEAR()\",\"=ROUND()\",\"=SI()\",\"=SUMARSI()\",\"=SUMIF()\",\"=TEXT()\",\"=TEXTO()\",\"=TRUNC()\",\"=TRUNCAR()\",\"=UPPER()\",\"=VALOR()\",\"=VALUE()\",\"=WEEKNUM()\",\"=Y()\",\"extrae excel\",\"HLOOKUP\",\"HOY\",\"izquierda\",\"MID\",\"residuo\",\"VLOOKUP\"],\"articleSection\":[\"Excel\",\"Google Sheets\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/\",\"name\":\"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/formula.jpg\",\"datePublished\":\"2018-11-22T19:05:03+00:00\",\"dateModified\":\"2023-06-12T17:31:37+00:00\",\"description\":\"google sheets f\u00f3rmulas, f\u00f3rmulas google sheets, f\u00f3rmulas en excel. Todos est\u00e1n listos para que hagas tu copia y empieces y empieces a usarlos\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/formula.jpg\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/formula.jpg\",\"width\":800,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/excel\\\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"name\":\"Business Intelligence MX\",\"description\":\" \",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\",\"name\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"contentUrl\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"width\":275,\"height\":168,\"caption\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/excelyfinanzasmx\\\/\",\"https:\\\/\\\/x.com\\\/excelfinanzasMX\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\",\"name\":\"V\u00edctor Urbina\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"caption\":\"V\u00edctor Urbina\"},\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos - Business Intelligence MX","description":"google sheets f\u00f3rmulas, f\u00f3rmulas google sheets, f\u00f3rmulas en excel. Todos est\u00e1n listos para que hagas tu copia y empieces y empieces a usarlos","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:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/","og_locale":"en_US","og_type":"article","og_title":"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos - Business Intelligence MX","og_description":"google sheets f\u00f3rmulas, f\u00f3rmulas google sheets, f\u00f3rmulas en excel. Todos est\u00e1n listos para que hagas tu copia y empieces y empieces a usarlos","og_url":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-11-22T19:05:03+00:00","article_modified_time":"2023-06-12T17:31:37+00:00","og_image":[{"width":573,"height":374,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/formulas2.png","type":"image\/png"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos","datePublished":"2018-11-22T19:05:03+00:00","dateModified":"2023-06-12T17:31:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/"},"wordCount":637,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/formula.jpg","keywords":["=AHORA()","=AND()","=AVERAGE()","=BUSCARH()","=BUSCARV()","=COINCIDIR()","=CONTAR()","=CONTARA()","=CONTARSI()","=COUNT()","=COUNTA()","=COUNTIF()","=DATE()","=ENTERO()","=ESBLANCO()","=ESERR()","=ESERROR()","=ESNUMERO()","=ESTEXTO()","=EXACT()","=FECHA()","=FIND()","=HALLAR()","=HOY()","=IF()","=IGUAL()","=INDIRECT()","=INDIRECTO()","=INT()","=ISBLANK()","=ISERR()","=ISERROR()","=ISNUMBER()","=ISTEXT()","=LARGO()","=LEFT()","=LEN()","=LOWER()","=MATCH()","=MAX()","=MAYUSC()","=MIN()","=MINUSC()","=MOD()","=NOW()","=NUM.DE.SEMANA()","=O()","=OR()","=PROMEDIO()","=REDONDEAR()","=ROUND()","=SI()","=SUMARSI()","=SUMIF()","=TEXT()","=TEXTO()","=TRUNC()","=TRUNCAR()","=UPPER()","=VALOR()","=VALUE()","=WEEKNUM()","=Y()","extrae excel","HLOOKUP","HOY","izquierda","MID","residuo","VLOOKUP"],"articleSection":["Excel","Google Sheets"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/","url":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/","name":"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/formula.jpg","datePublished":"2018-11-22T19:05:03+00:00","dateModified":"2023-06-12T17:31:37+00:00","description":"google sheets f\u00f3rmulas, f\u00f3rmulas google sheets, f\u00f3rmulas en excel. Todos est\u00e1n listos para que hagas tu copia y empieces y empieces a usarlos","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/formula.jpg","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/11\/formula.jpg","width":800,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/excel\/mas-de-40-formulas-de-excel-y-google-sheets-con-ejemplos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"M\u00e1s de 40 f\u00f3rmulas de Excel y Google Sheets con ejemplos"}]},{"@type":"WebSite","@id":"https:\/\/www.fditf.com\/bi\/#website","url":"https:\/\/www.fditf.com\/bi\/","name":"Business Intelligence MX","description":" ","publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fditf.com\/bi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fditf.com\/bi\/#organization","name":"FDI Tecnolog\u00eda y Finanzas, SAS de CV","url":"https:\/\/www.fditf.com\/bi\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/","url":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","contentUrl":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","width":275,"height":168,"caption":"FDI Tecnolog\u00eda y Finanzas, SAS de CV"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelyfinanzasmx\/","https:\/\/x.com\/excelfinanzasMX"]},{"@type":"Person","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5","name":"V\u00edctor Urbina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","caption":"V\u00edctor Urbina"},"url":"https:\/\/www.fditf.com\/bi\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/2020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/comments?post=2020"}],"version-history":[{"count":46,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/2020\/revisions"}],"predecessor-version":[{"id":19230,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/2020\/revisions\/19230"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/2271"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=2020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=2020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=2020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}