Function Type: Compatibility


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.


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

Back to Learn Excel->

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: