Excel
FLOOR function in Excel
Rounds a number down, toward zero
=FLOOR(number, significance)FLOOR syntax and parameters
Two arguments, two required.
- numbernumberRequired
The numeric value you want to round.
- significancenumberRequired
The multiple to which you want to round.
FLOOR examples
Formulas you'll actually reuse.
Round a 7.8h timesheet entry down to the billing half-hour:
=FLOOR(B2, 0.5)Result
7.5Gross price rounded down to the nearest 5 cents:
=FLOOR(B2 * 1.19, 0.05)Result
23.75
FLOOR in Google Sheets
Same name — your formula ports as-is.
Try FLOOR in the playground
Edit the example — nothing to install.
Preloaded with the FLOOR formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- RANKReturns the rank of a number in a list of numbersCompatibilityGoogle Sheets
- AVERAGEIFReturns the average (arithmetic mean) of all the cells in a range that meet a given criteriaStatisticalGoogle Sheets
- CELLReturns information about the formatting, location, or contents of a cellThis function is not available in Excel for the web.InfoGoogle Sheets
- CSCReturns the cosecant of an angleMathGoogle Sheets
- FILTERFilters a range of data based on criteria you defineLookupGoogle Sheets
- FINDFinds one text value within another (case-sensitive)TextGoogle Sheets