In This Topic

FLOOR.MATH

In This Topic

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

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

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 |

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.

Accepts numeric data for both arguments. Returns numeric data.

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

FLOOR.MATH(-6.3,8) gives the result -8

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