{"id":13973,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/multiplo-inferior-mat\/"},"modified":"2021-02-26T08:48:13","modified_gmt":"2021-02-26T08:48:13","slug":"floor-math","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/floor-math\/","title":{"rendered":"MULTIPLO.INFERIOR.MAT"},"content":{"rendered":"

Descripci\u00f3n General<\/h2>\n

La funci\u00f3n MULTIPLO.INFERIOR.MAT<\/code> en Excel y su equivalente FLOOR.MATH<\/code> en Google Sheets se utilizan para redondear un n\u00famero hacia abajo hasta el m\u00faltiplo m\u00e1s cercano de un n\u00famero especificado. Esta funci\u00f3n resulta especialmente \u00fatil en situaciones donde se necesita estandarizar cantidades, como en el ajuste de precios, determinaci\u00f3n de medidas de empaque o en la asignaci\u00f3n de unidades en procesos de manufactura.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

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

=MULTIPLO.INFERIOR.MAT(n\u00famero, [significaci\u00f3n], [modo])<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • n\u00famero<\/strong>: (obligatorio) Es el n\u00famero que deseas redondear hacia abajo.<\/li>\n
  • significaci\u00f3n<\/strong>: (opcional) El m\u00faltiplo al que quieres redondear. Si no se especifica, el valor predeterminado es 1.<\/li>\n
  • modo<\/strong>: (opcional) Determina la forma en que se realizar\u00e1 el redondeo. Si se omite este argumento o se establece en cero (0), se redondea hacia el m\u00faltiplo m\u00e1s cercano. Si se asigna un valor diferente de cero, el redondeo toma en cuenta la direcci\u00f3n del signo del n\u00famero ingresado.<\/li>\n<\/ul>\n
    Ejemplo 1:<\/strong><\/p>\n
    =MULTIPLO.INFERIOR.MAT(15.5) \/\/ Devolver\u00e1 15<\/code><\/pre>\n
    Ejemplo 2:<\/strong><\/p>\n
    =MULTIPLO.INFERIOR.MAT(-15.5, 2) \/\/ Devolver\u00e1 -16<\/code><\/pre>\n
    Pr\u00e1cticas Aplicaciones<\/h2>\n
    Caso de Uso 1: Precios de Productos<\/h3>\n
    Imagina que eres un comerciante que necesita redondear precios hacia abajo hasta el m\u00faltiplo de 0.05 m\u00e1s cercano para evitar el uso de monedas de baja denominaci\u00f3n.<\/p>\n
    Por ejemplo, si enfrentas un precio de $4.87 y decides redondearlo:<\/p>\n
    =MULTIPLO.INFERIOR.MAT(4.87, 0.05) \/\/ Resultado: 4.85<\/code><\/pre>\n
    Este ajuste garantiza que los precios siempre se redondeen de forma consistente a m\u00faltiplos f\u00e1ciles de manejar tanto para clientes como para cajeros.<\/p>\n
    Caso de Uso 2: Empaque por Unidades<\/h3>\n
    Considera una empresa que empaca galletas en cajas donde cada una debe contener un m\u00faltiplo de 10 unidades. Si se producen cantidades no est\u00e1ndar, esta funci\u00f3n ayuda a determinar cu\u00e1ntas galletas se incluir\u00e1n en la \u00faltima caja.<\/p>\n
    Por ejemplo, si se producen 57 galletas, puedes calcular:<\/p>\n
    =MULTIPLO.INFERIOR.MAT(57, 10) \/\/ Resultado: 50<\/code><\/pre>\n
    Este c\u00e1lculo asegura que la \u00faltima caja contenga solo 50 galletas, garantizando que cada paquete contenga \u00fanicamente m\u00faltiplos completos del producto.<\/p>\n\n\n\n
    Funci\u00f3n<\/th>\nDescripci\u00f3n<\/th>\nEjemplo<\/th>\n<\/tr>\n
    MULTIPLO.INFERIOR.MAT<\/code><\/td>\nRedondea un n\u00famero hacia abajo al m\u00faltiplo m\u00e1s pr\u00f3ximo.<\/td>\n=MULTIPLO.INFERIOR.MAT(34.7, 5)<\/code> devuelve 30<\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
    Redondea un n\u00famero hacia abajo al entero m\u00e1s pr\u00f3ximo o al m\u00faltiplo significativo m\u00e1s cercano<\/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-13973","post","type-post","status-publish","format-standard","hentry","category-matematicas-y-trigonometria"],"acf":[],"yoast_head":"\nFunci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) 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\/floor-math\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/floor-math\/\" \/>\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:48:13+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 FLOOR.MATH (MULTIPLO.INFERIOR.MAT) 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\/floor-math\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/floor-math\/\",\"name\":\"Funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) 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:48:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/floor-math\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/floor-math\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/floor-math\/#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\":\"MULTIPLO.INFERIOR.MAT\"}]},{\"@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 FLOOR.MATH (MULTIPLO.INFERIOR.MAT) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) 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\/floor-math\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/floor-math\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:48:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) 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\/floor-math\/","url":"https:\/\/functiontranslator.com\/es\/floor-math\/","name":"Funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) 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:48:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n FLOOR.MATH (MULTIPLO.INFERIOR.MAT) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/floor-math\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/floor-math\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/floor-math\/#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":"MULTIPLO.INFERIOR.MAT"}]},{"@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\/13973","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=13973"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13973\/revisions"}],"predecessor-version":[{"id":30032,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13973\/revisions\/30032"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}