How to use the Excel FLOOR function

Floor function is used for rounding down the decimal number and integer numbers but this function converts the selected numbers to the nearest possible specified numbers to any down value of it. For example, if we have a number 10 that we need to round then as per syntax significance multiple values should down less than 2 to see the change. If we select 3 here in place of significance multiple, then we will see round down to nearest 3 as 9.

Syntax: =FLOOR (number, multiple)

The FLOOR function syntax has the following arguments:

  • Number (Required): The numeric value you want to round.
  • Significance (Required): The multiple to which you want to round. Remarks

Example: Let’s look at some Excel FLOOR function examples and explore how to use the FLOOR function as a worksheet function in Microsoft Excel:

Excel FLOOR function 1 - How to use the Excel FLOOR function

Syntax:  =FLOOR(G27,H27)

Result:

Excel FLOOR function - How to use the Excel FLOOR function

Based on the Excel spreadsheet above, the following FLOOR examples would return:

Syntax: =FLOOR(G28,H28)
Result: 1652

Syntax: =FLOOR(G29,H29)
Result: 100

Syntax: =FLOOR(G30,H30)
Result: 5.1

Syntax: =FLOOR(G31,H31)
Result: 5

Syntax: =FLOOR(G32,H32)
Result: -7

Syntax: =FLOOR(G33,H33)
Result: -6

Syntax: =FLOOR(G34,H34)
Result: #NUM!

Note: The Excel FLOOR function rounds a number down to a given multiple. FLOOR works like the MROUND function, which also rounds to a given multiple, but FLOOR always rounds down.

Add a Comment

Your email address will not be published. Required fields are marked *