# 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* | Number to round |
| *signif* | 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.

## Data Types

Accepts numeric data for both arguments. Returns numeric data.

## 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.