Floor Formula

	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)
What Does It Do ?
This function rounds a value down to the nearest multiple specified by the user.
Syntax
=FLOOR(NumberToRound,SignificantValue)
Formatting
No special formatting is needed.
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	Commission
	Alan	£23,500	£23,000	£230
	Bob	£56,890	£56,000	£560
	Carol	£18,125	£18,000	£180
			=FLOOR(D29,1000)