# FLOOR

## Content

This function rounds a number down to the nearest multiple of a specified value.

## Syntax

`FLOOR(value, signif)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *value* | [Required] Number to round |
| *signif* | [Required] Number representing the rounding factor |

Use either both positive or both negative numbers for the arguments. Regardless of the sign of the numbers, the value is rounded toward zero.

## Examples

`FLOOR(C4,B2)`
`FLOOR(B3,0.05)`
`FLOOR(R1C2,1)`
`FLOOR(4.65,2)` gives the result 4.
`FLOOR(-2.78,-1)` gives the result -2.