Excel Function : FLOOR.PRECISE
Category
Math and trigonometry
Description
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
Microsoft Excel Reference Page
https://support.office.com/en-us/article/FLOORPRECISE-function-f769b468-1452-4617-8dc3-02f842a0702e
Syntax and Description of the FLOOR.PRECISE Excel Function
=FLOOR.PRECISE(number, significance)
About FLOOR.PRECISE Excel Function
FLOOR.PRECISE rounds a number down, to the nearest integer or multiple of significance.