FLOOR.PRECISE Function Explained

The FLOOR.PRECISE function in Microsoft Excel rounds a number down to the nearest multiple of a specified significance. It takes two arguments: the number to be rounded and the significance to which it should be rounded. It returns a number rounded down to the nearest multiple of the specified significance.

FLOOR.PRECISE Function Syntax

FLOOR.PRECISE(number, significance)

  • number: The number you want to round down to the nearest multiple of significance.
  • significance: The multiple to which you want to round down number.