Function Floor()

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


Syntax:

= Floor (Number, Significance)

Number = the number that is to be rounded off to nearest integer less than the number
Significance = 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.

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.