Excel: Floor Function

In Excel, the Floor function returns a number rounded down based on a multiple of significance.

The syntax for the Floor function is:

Floor( number, significance )

number is the number that you wish to round down.

significance is the multiple of significance that you wish to round a number to.

Note:

If the sign of the number and the significance parameters are different, the Floor function will return the #NUM! error.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Floor(A1, 1) would return 169

=Floor(A1, 0.05) would return 169.65

=Floor(A2, 0.05) would return 169.6

=Floor(A3, 2) would return 2

=Floor(A4, 2) would return #NUM!

=Floor(-4.5, -1) would return -4