SheetFX
≡
<< Go back to all functions

FLOOR.MATH

The FLOOR.MATH function in Google Sheets rounds a number down to the nearest integer multiple of the specified significance. The function supports negative numbers rounding toward or away from 0, depending on the mode. Learn how to use this function effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: FLOOR.MATH(number, [significance], [mode])

Parameters:

  • number: The number to be rounded.
  • significance: [Optional] The multiple to which the number should be rounded. If omitted, the significance is set to 1.
  • mode: [Optional] Determines how negative numbers are rounded. If omitted, the mode is set to 0 or towards zero.

Step-by-Step Tutorial

  1. Using FLOOR.MATH with default parameters:

    • Example: =FLOOR.MATH(7.8)
    • Result: 7

  2. Using FLOOR.MATH with specified significance:

    • Example: =FLOOR.MATH(13, 5)
    • Result: 10

  3. Using FLOOR.MATH with specified mode:

    • Example: =FLOOR.MATH(-7.8, , 1)
    • Result: -8

Use Cases and Scenarios

  1. Time Calculation: Round down time values to the nearest hour or minute.
  2. Inventory Management: Determine the number of items that can fit into certain packaging sizes.
  3. Financial Modeling: Round down monthly expenses or interest rates.

Related Functions

  • FLOOR: Rounds a number down to a certain significance level.
  • CEILING: Rounds a number up to a certain significance level.

Related Articles