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

    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.