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.