Saturday 15 April 2017

Excel - Microsoft Excel FLOOR Function

Description

The Excel FLOOR function rounds a supplied number towards zero to the nearest multiple of a specified significance. 

The syntax of the function is: 

FLOOR( number, significance ) 


Where the arguments are as follows: 

Positive and Negative Arguments
Note: In Excel 2003 & 2007, the significance argument must have the same arithmetic sign (positive or negative) as the initial number argument. However, in Excel 2010, the Floor function has been improved, so that it can now handle a negative number argument and a positive significance argument. In this case, the Floor function reverses the direction of the rounding (ie. rounds the supplied number away from zero). 

Floor Function Examples
The following spreadsheet shows the Excel Floor function used with several different significance values, on the positive and negative numbers 26.75 and -26.75. 

The functions are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right. 

The above examples show how, when the number and the significance arguments have the same arithmetic sign, the Floor function rounds the supplied number towards zero

Examples with Positive and Negative Arguments
Different combinations of positive and negative arguments, are shown in the Excel 2010 spreadsheet below. 



Floor Function Errors
If you get an error from the Excel Floor function, this is likely to be one of the following : 

Common Errors 







No comments:

Post a Comment