Excel > Functions

FLOOR Function

The Excel FLOOR function is used to round a number down to a multiple of significance. For example, you could round a number down to the nearest decimal place, or to the next multiple of 5.

The syntax for the FLOOR function is:

=FLOOR(number,significance)

Argument

Purpose

Number

The number you want to round down

Significance

The multiple of sigificance you want to round the number down to.

This must match the sign of the number you are using. For example, you cannot round a positive number down to a negative number

Below are examples of the FLOOR function being used to round numbers down to various multiples.

Data to use for FLOOR function

Function

Result

=FLOOR(A1,0.1)

5.3

=FLOOR(A2,1)

2

=FLOOR(A3,0.1)

4.5

=FLOOR(A4,5)

20

Follow us on

Facebook  Twitter  You Tube 

Other Mathematical Functions

Excel 2010 Superhero Course