How to use Excel FLOOR.MATH function

Introduction

FLOOR.MATH function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given function to a defined multiple. For example, number 1.5 is rounded down to nearest multiple of 1 by formula =FLOOR.MATH(1.5,1) which gives 1 as the result. FLOOR.MATH function is different from FLOOR as it uses 1 as a default multiple and explicitly rounds down negative integers.

Syntax

=FLOOR.MATH(Number, Significance, Mode)

Arguments

  • Number- The number or cell containing the number that is to be rounded off.
  • Significance- It is the multiple to which you can round down the number.
  • Mode- Used for rounding negative integers. Default value is zero.

Keynotes

  • If the provided number is a multiple of significance argument, it is not rounded down.
  • FLOOR.MATH function is same as MROUND function except it always rounds down.  
  • If argument is non numeric, #VALUE! error is displayed.
  • A negative integer is rounded away from zero. For example, -2.5 is rounded to -3. To round it near to zero, use a negative number in mode argument.
  • FLOOR.MATH function is available in excel 2013 or above.

Examples

In the following example, a table of numbers is given, it is rounded down using FLOOR.MATH function.

In the following example, number of items and their bundle size is given; we use FLOOR.MATH function to find how many bundles are needed.

Leave a Comment