SheetFX
≡
<< Go back to all functions

FLOOR

The FLOOR function in Google Sheets rounds a number down to the nearest integer multiple of the specified significance. It is commonly used to eliminate decimal places while maintaining the original structure of a dataset.

Function Syntax and Parameters

Syntax: FLOOR(value, [factor])

Parameters:

  • value: The number or range that you want to round down.
  • factor: [Optional] The significance to which you want to round down. Default value is 1 if not provided.

Step-by-Step Tutorial

  1. Using FLOOR with a single number:

    • Example: =FLOOR(4.9)
    • Result: 4

  2. Using FLOOR with a range of numbers:

    • Example: If A1:A5 has the values 5.8, 10, 3.7, 8.9, 7.2, then =FLOOR(A1:A5) will return 5, 10, 3, 8, 7.

Use Cases and Scenarios

  1. Sales Pricing: Determine the exact number of units to sell in order to reach a certain revenue target.
  2. Inventory Management: Calculate the minimum quantity of stock required to fulfill orders without excess.
  3. Time Conversion: Round down timestamps to the nearest minute, hour, or day.

Related Functions

  • CEILING: Round a number up to the nearest integer or to the specified significance.
  • INT: Round a number down to the nearest integer.

Related Articles