Excel FLOOR Function
If you want to follow along with this tutorial, please download the example spreadsheet.
Description
The FLOOR function rounds a given number down to the nearest multiple of the specified significance.
Syntax and arguments
Formula syntax
Arguments
|
Return Value
The FLOOR function returns to a numeric value.
Errors
#VALUE! error value occurs when the anyone of arguments is not a numeric value.
#NUM! error value occurs:
- In Excel 2010 or later, when the argument number is a positive value, but the argument significance is a negative value.
- In Excel 2007 or earlier, when argument number and significance have different arithmetic signs. #DIV/0! Error value occurs when the argument significance is zero.
Remarks
If the argument number is positive, FLOOR function rounds down and toward to zero, for example, FLOOR(10,3)=9.
If the argument number is negative, FLOOR function rounds down and goes away to zero, for example, FLOOR(-10,3)=-12.
If the argument number is an exact multiple of significance, FLOOR function returns to the number itself, for example, FLOOR(10,2)=10.
Version
Excel 2003 or later
Usage and Examples
Example: basic usage
Based on the values in table C3:G4, which contains the numbers and the corresponding specified significance, please use FLOOR function to round down and get the nearest multiples as this:
=FLOOR(C3,C4) //or directly use a number in the formula =FLOOR(10,1)
Press Enter key to get the first result, then drag autofill handle right to get other results.
Relative Functions:
Excel FACT Function
The FACT function eturns the factorial of a given number. For example, FACT(5)=120, equivalent to 5 x 4 x 3 x 2 x 1.
Excel FACTDOUBLE Function
The FACTDOUBLE function returns the double factorial of a given number. For example, FACTDOUBLE(5)=15, equivalent 5 x 3 x 1.
Excel RATE Function
The RATE returns the interest rate per period of an annuity.
Excel RECEIVED Function
The RECEIVED function returns the amount received at maturity for a fully invested security.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.