{"id":14094,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/residuo\/"},"modified":"2021-02-26T08:54:01","modified_gmt":"2021-02-26T08:54:01","slug":"mod","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/mod\/","title":{"rendered":"RESIDUO"},"content":{"rendered":"

La funci\u00f3n MOD, conocida en espa\u00f1ol como RESIDUO, es una herramienta muy \u00fatil tanto en Microsoft Excel como en Google Sheets. Esta funci\u00f3n devuelve el residuo de una divisi\u00f3n entre dos n\u00fameros, es decir, el sobrante despu\u00e9s de realizar una divisi\u00f3n entera. La comprensi\u00f3n de su sintaxis es fundamental para efectuar c\u00e1lculos que impliquen operaciones de m\u00f3dulo.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n RESIDUO es:<\/p>\n

RESIDUO(numerador, denominador)<\/code><\/pre>\n
 Donde: <\/p>\n
    \n
  • numerador:<\/strong> Es el n\u00famero que deseamos dividir.<\/li>\n
  • denominador:<\/strong> Es el n\u00famero por el cual se divide el numerador.<\/li>\n<\/ul>\n
    Es crucial recordar que el denominador no debe ser cero, pues la divisi\u00f3n por cero no est\u00e1 definida.<\/p>\n
    Ejemplo 1:<\/b> Para encontrar el residuo de dividir 10 entre 3, la f\u00f3rmula ser\u00eda:<\/p>\n
    =RESIDUO(10, 3)<\/code><\/pre>\n
    El resultado ser\u00eda 1, ya que 10 dividido entre 3 produce un cociente de 3 y un residuo de 1.<\/p>\n
    Ejemplo 2:<\/b> Calculando el residuo de 25 dividido entre 7, emplear\u00edamos:<\/p>\n
    =RESIDUO(25, 7)<\/code><\/pre>\n
    El resultado es 4, puesto que 25 dividido entre 7 resulta en un cociente de 3 y un residuo de 4.<\/p>\n
    Uso Pr\u00e1ctico de la Funci\u00f3n<\/h2>\n
    La funci\u00f3n RESIDUO se puede utilizar en diversas situaciones pr\u00e1cticas, incluyendo \u00e1reas como contabilidad, ingenier\u00eda y ciencias de la computaci\u00f3n. A continuaci\u00f3n se describen algunos ejemplos pr\u00e1cticos:<\/p>\n
    Ejemplo de Aplicaci\u00f3n en Horarios<\/h2>\n
    Supongamos que necesitas calcular cu\u00e1ntas horas extras trabaj\u00f3 un empleado despu\u00e9s de una semana regular de 40 horas. Si el empleado registr\u00f3 53 horas en total, podr\u00edas emplear RESIDUO para determinar el tiempo extra:<\/p>\n
    =RESIDUO(53, 40)<\/code><\/pre>\n
    El resultado ser\u00eda 13, indicando que el empleado trabaj\u00f3 13 horas extras.<\/p>\n
    Ejemplo de Aplicaci\u00f3n en Programaci\u00f3n<\/h2>\n
    En programaci\u00f3n, frecuentemente necesitamos establecer si un n\u00famero es par o impar para definir ciertas condiciones. Esto se logra utilizando la funci\u00f3n RESIDUO.<\/p>\n
    =RESIDUO(numero, 2)<\/code><\/pre>\n
    Si esta f\u00f3rmula devuelve 0, entonces el n\u00famero es par; si devuelve 1, es impar.<\/p>\n\n\n\n\n
    N\u00famero<\/th>\nResultado (RESIDUO(numero, 2))<\/th>\nPar o Impar<\/th>\n<\/tr>\n
    4<\/td>\n0<\/td>\nPar<\/td>\n<\/tr>\n
    7<\/td>\n1<\/td>\nImpar<\/td>\n<\/tr>\n<\/table>\n
    Este ejemplo pr\u00e1ctico muestra c\u00f3mo se puede utilizar RESIDUO para influir en el flujo de un programa, dependiendo de si un n\u00famero es par o impar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el resto de la divisi\u00f3n<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[535],"tags":[],"class_list":["post-14094","post","type-post","status-publish","format-standard","hentry","category-matematicas-y-trigonometria"],"acf":[],"yoast_head":"\nFunci\u00f3n MOD (RESIDUO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n MOD (RESIDUO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/mod\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n MOD (RESIDUO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n MOD (RESIDUO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/mod\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:54:01+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n MOD (RESIDUO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/mod\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/mod\/\",\"name\":\"Funci\u00f3n MOD (RESIDUO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:54:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n MOD (RESIDUO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/mod\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/mod\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/mod\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matem\u00e1ticas y trigonometr\u00eda\",\"item\":\"https:\/\/functiontranslator.com\/es\/matematicas-y-trigonometria\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"RESIDUO\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n MOD (RESIDUO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n MOD (RESIDUO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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:\/\/functiontranslator.com\/es\/mod\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n MOD (RESIDUO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n MOD (RESIDUO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/mod\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:54:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n MOD (RESIDUO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/mod\/","url":"https:\/\/functiontranslator.com\/es\/mod\/","name":"Funci\u00f3n MOD (RESIDUO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:54:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n MOD (RESIDUO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/mod\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/mod\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/mod\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Matem\u00e1ticas y trigonometr\u00eda","item":"https:\/\/functiontranslator.com\/es\/matematicas-y-trigonometria\/"},{"@type":"ListItem","position":3,"name":"RESIDUO"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14094"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14094\/revisions"}],"predecessor-version":[{"id":30187,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14094\/revisions\/30187"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}