Floor()This function is used to convert a number with decimal points to an integer lower that the number. When a number is input to this function, it removes the decimal part of the number and returns only the integer value of that number

SyntaxSyntax

**:**

= Floor (Number,

= Floor (Number,

*Significance*)*Number = the number that is to be rounded off to nearest integer less than the numberSignificance = multiple to which the number is to be rounded off to*

*Example***:**

- =Floor(28.2315 , 1) - result will be – 28
- =Floor(28.2315 , 2) - result will be – 28
- =Floor(28.2315 , 5) - result will be – 25
- =Floor(27.2315 , 1) - result will be – 27
- =Floor(27.2315 , 2) - result will be – 26
- =Floor(27.2315 , 5) - result will be – 25

The floor function rounds off the number down to the nearest integer which is divisible by the Significance value input in the function. Example, if I have to round down 29.33 to an integer, the result will be 29. But, if I want to round of the number down, but that number should also be divisible by 2, then my formula would be:

=Floor(29.33,2)

**The result of the above formula will be - 28**

In the examples above, I have used 28.2315 and 27.2315 to show what does ‘Significance’ values stands for.

## 0 comments:

## Post a Comment