Spread Formula Reference
FLOOR.MATH
Formula Functions > Functions D to G > FLOOR.MATH

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.