Excel FLOOR Function
If you want to follow along with this tutorial, please download the example spreadsheet.
The FLOOR function rounds a given number down to the nearest multiple of the specified significance.
Syntax and arguments
The FLOOR function returns to a numeric value.
#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.
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.
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.
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.