Spread.NET 17 Formula Reference
Formula Functions / Functions D to G / FLOOR.MATH
In This Topic
    In This Topic

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




    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.

    Data Types

    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

    Version Available

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