Menu
EXCEL FLOOR.MATH FUNCTION
Excel FLOOR.MATH Function Introduction
The floor of Excel. A provided integer is rounded down to a specified multiple of significance using the math function.
Positive numbers are often rounded toward zero, whereas negative numbers are rounded away from zero. However, for negative values, the user has the option to reverse the direction of rounding.
Description of Excel FLOOR.MATH Function
Syntax :
=FLOOR.MATH( number, [significance], [mode] )
Parameters :
- The following are some arguments:
number –
- The rounded-down number.
[significance] –
- An optional parameter that defines the significance multiple to round the provided integer to.
If the [significance] parameter is missing, the value 1 is used as the default (i.e. round down to the nearest integer).
(The [significance] argument’s arithmetic sign is disregarded.)
[mode] –
- A number parameter that can be provided as an option.
Step By Step Guide of FLOOR.MATH Function
Example :
The Excel Floor is in column B in the following spreadsheet. The mathematics function is used to rounded down the positive and negative integers 58.55 and -58.55 to various significance levels.
If the [significance] parameter is missing, the default value of 1 is used (see cell B1).
The floor is yours. Positive numbers are often rounded towards zero, whereas negative numbers are rounded away from zero. Negative values are rounded to zero if the [mode] option is specified and is non-zero (see cell B5).
Key Points
- #VALUE! – This error occurs if any of the supplied parameters is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
