FLOOR

Posted on 17-01-2020 , by: admin , in , 0 Comments

FLOOR

What Does It Do?
This function rounds a value down to the nearest multiple specified by the user.

Syntax
=FLOOR(Number To Round, SignificantValue)

Formatting
No special formatting is needed.

Number Rounded Down
1.5 1  =FLOOR(C4,1)
2.3 2  =FLOOR(C5,1)
2.9 2  =FLOOR(C6,1)
123 100  =FLOOR(C7,50)
145 100  =FLOOR(C8,50)
175 150  =FLOOR(C9,50)

Example:

The following table was used to calculate commission for members of a sales team. Commission is only paid for every £1000 of sales. The =FLOOR() function has been used to round down the Actual Sales to the nearest 1000, which is then used as the basis for Commission.

Name Actual Sales Relevant
Sales
Comm-
ission
Alan £23,500 £23,000 £230
Bob £56,890 £56,000 £560
Carol £18,125 £18,000 £180
 =FLOOR (D29, 1000)

Leave a comment