How to use the Excel FLOOR.PRECISE function

The FLOOR.PRECISE function rounds a given number down to the nearest integer or user specified level of significance. Regardless of the number’s sign, it is always rounded down. If you are trying to round to the nearest multiple, either up or down, the MROUND function can be used.

Syntax: =FLOOR.PRECISE (number, [significance])

The FLOOR.PRECISE function syntax has the following arguments:

  • number – The Number to be rounded down
  • significance– Multiple of Significance to which the number has to be rounded to

Note: the arithmetic sign of the [significance] argument is ignored.

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

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

Syntax:  =FLOOR.PRECISE(H27,I27)

Result:

Excel FLOOR.PRECISE function - How to use the Excel FLOOR.PRECISE function

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

Syntax =FLOOR.PRECISE(H28,I28)
Result: 13

Syntax: =FLOOR.PRECISE(H29,I29)
Result: -14

Syntax: =FLOOR.PRECISE(H30,I30)
Result: -14

Syntax: =FLOOR.PRECISE(H31,I31)
Result: 13.1

Syntax: =FLOOR.PRECISE(H32,I32)
Result: 13.1

Syntax: =FLOOR.PRECISE(H33,I33)
Result: -13.2

Syntax: =FLOOR.PRECISE(H34,I34)
Result: -13.2

Note: The FLOOR.PRECISE function is used to round a number down to the nearest integer. The function always rounds the number argument down. When dealing with decimals, positive numbers will round down to the nearest integer and negative numbers will always round away from zero. For example, 5.5 would round down to 5 and -5.5 would round to -6. If you require control over how negative numbers are rounded, the FLOOR.MATH function can be used.

READ:  How to use WEEKNUM Function in Excel

Add a Comment

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