Function Type: Compatibility
Description:
Rounds a number down, toward zero. In Excel 2007 and Excel 2010, this is a Math and trigonometry function.
Function Structure:
=FLOOR(number, significance).
Argument Breakdown:
number – The number that should be rounded.
significance – The multiple to use when rounding.
Example:

If y If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.