EXCEL FUNCTIONS-FLOOR.MATH

INTRODUCTION

FLOOR.MATH FUNCTION is quite a useful function in day to day working in programming. It is a special type of ROUND function.

It is found under the MATH AND TRIG GROUP of the formulas in MICROSOFT EXCEL.

FLOOR.MATH FUNCTION rounds down the number (rounding towards the lower digit) to the next lower integer or nearest multiple of  digit of significance.

This is a question found in many brains that how can we round to a certain specific number or how can we round other than the standard numbers. So this is the answer to all those question.

This function is very helpful when we need to do some rounding or giving the result as a multiple of some number.

FLOOR.MATH is the revised version of the function FLOOR which was available before Excel versions earlier to 2010. CLICK HERE TO READ ABOUT FLOOR FUNCTION.

PURPOSE OF FLOOR.MATH FUNCTION IN EXCEL

FLOOR.MATH FUNCTION rounds down the number to the next integer or the next nearest multiple of significance.

PREREQUISITES TO LEARN FLOOR.MATH FUNCTION

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the MATH AND TRIG terms is an advantage for the use of such formulas.
  •  Of course, Excel software.

Helpful links for the prerequisites mentioned above What Excel does? How to use formula in Excel?

SYNTAX: FLOOR.MATH FUNCTION

The Syntax for the function is

=FLOOR.MATH (NUMBER OR REFERENCE, SIGNIFICANCE, MODE)

NUMBER is the given number which is to be rounded

SIGNIFICANCE[OPTIONAL default=+1 ] is the number of significance. The number will be rounded down to its nearest multiple.

MODE [optional default is 0] decides if the rounding of the NEGATIVE NUMBER is to be towards the zero or away from the zero. Use 0 for away from the 0 and 1 for towards the zero.

EXAMPLE: FLOOR.MATH FUNCTION IN EXCEL

DATA SAMPLE

Let us take a random data to check the FLOOR.MATH FUNCTION to various significance.

ROUND 240 DOWN TO NEAREST MULTIPLE OF 4.5

ROUND DOWN -230.54 TOWARDS AND AWAY FROM 0

ROUND DOWN 10.23 TO THE NEAREST MULTIPLE OF 0.25

USING FLOOR.MATH FUNCTION IN EXCEL

STEPS TO USE FLOOR FUNCTION-EXAMPLE

STEPS:

FOR

ROUND 240 DOWN TO NEAREST MULTIPLE OF 4.5

USE FUNCTION

=FLOOR.MATH(240,4.5)

The number to be rounded is 240 with the significance of 4.5. The answer comes out to be 238.5.

ROUND DOWN -230.54 TOWARDS 0

USE FUNCTION

=FLOOR.MATH(-230.54,,1)

Here -230.54 is the number to be rounded, second argument is omitted. [remember we need to mention second argument with an empty ,, otherwise function won’t be able to understand whether its second argument or third]

The third argument is 1 which will take it towards zero and hence the result is -230.

ROUND DOWN -230.54 AWAY FROM 0

USE FUNCTION

=FLOOR.MATH(-230.54,,0)

The number is same as above but we want it away from the zero so we took 0 to make it away from 0 and the answer is -231.

ROUND DOWN 10.23 TO THE NEAREST MULTIPLE OF 0.25

USE FUNCTION

=FLOOR.MATH(10.23,0.25)

The number to be rounded is 10.23 which is to be rounded to the multiple of 0.25 and answer is 10 which is nearest multiple of significance inthe downside.

generalized STEPS TO USE FLOOR function

HERE ARE THE STEPS TO USE COUNT FUNCTION     PLACE YOUR CURSOR IN THE CELL WHERE YOU WANT THE RESULT.

  • USE THE FUNCTION
  • =FLOOR.MATH( CELL WITH THE DATA, NUMBER OF SIGNIFICANCE, MODE)
  • Press ENTER and the result will appear.