# FLOOR.MATH

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



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

## Syntax

FLOOR.MATH(*value,signif,mode*)

## Arguments

This function has the following arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *value* | Number to round |
| *signif* | [Optional] Number representing the rounding factor |
| *mode* | [Optional] Represents the direction (towards or away from 0) to round negative value |

## Remarks

Positive numbers with decimal parts are rounded down to the nearest integer.
Negative numbers with decimal parts are rounded away from 0 to the nearest integer.

## Data Types

Accepts numeric data for both arguments. Returns numeric data.

## Examples

`FLOOR.MATH(-3.1,3,4)` gives the result -3
`FLOOR.MATH(-6.3,8)` gives the result -8

## Version Available

This function is available in Spread for Windows Forms 11.0 or later.