Sunday, 22 July 2012

Excel FLOOR Function Syntax and Example

FLOOR  Function:
The FLOOR function rounds a number down to the nearest specified multiple.
   
Syntax: 
=FLOOR (number,multiple) 

Examples:



NUMBER
Significance/Multiple
FLOOR Function
Result
10
4
 =FLOOR(A2,B2)
8
25.65
7
 =FLOOR(A3,B3)
21
-99
-10
 =FLOOR(A4,B4)
-90
25.65
-0.5
 =FLOOR(A5,B5)
#NUM!
-25.65
0.5
 =FLOOR(A5,B5)
-26

Explanation :


In above example "=Floor(10,4)" = 8 , because the nearest multiple of '4' which is less than the number '10' is 8.


Note: 

The number argument and the multiple argument must have the same sign or the function will return a #NUM! error. 

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts