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 Google Plus

About Nifty Guru

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.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Sunday, May 24, 2009

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.

Function Floor()SocialTwist Tell-a-Friend

0 comments:

Post a Comment