*PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES*

#### CONTENTS

# 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.

## 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

### 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

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

OTHER WAYS TO REACH THIS ARTICLE

## WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

YOU MAY LIKE

- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.