deepcalc
DocsFLOOR.MATH

FLOOR.MATH

View as markdown/docs/functions/floor-math.md Ask Claude about this pageOpens Claude with this page's address

Rounds down with optional significance and mode.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=FLOOR.MATH(2)
Result 2

Syntax

FLOOR.MATH(number, [significance], [mode])
number
number required
significance
number optional
mode
number optional
ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.