Function Ceiling()

Ceiling ()

This functions is used to convert a number with decimal points to an ineger greater than the number. When a number is input in this function, it adds the decimal points enough to convert the number to an integer more than the number itself


Syntax:

= Ceiling (Number, Significance)

Number = the number that is to be rounded off
Significance = multiple to which the number is to be rounded off


Example:
  • =Ceiling (26.2315 , 1) result will be - 27
  • =Ceiling (26.2315 , 2) result will be - 28
  • =Ceiling (26.2315 , 5) result will be - 30
  • =Ceiling (27.2315 , 1) result will be - 28
  • =Ceiling (27.2315 , 1) result will be - 28
  • =Ceiling (27.2315 , 1) result will be - 30
The ceiling function rounds off the number up to the nearest integer which is divisible by the significance value input in the function. Example - if I have to round up 26.33 to an integer, th result will be 27. But, if I want to round up the number, but to that integer which should also be divisible by 2, then my function wil be -

=Ceiling(26.33,)

The result of this function will be - 28

In the examples above I have used 26.2315 and 27.2315 to show the use of 'Significance' value.
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

Tuesday, May 26, 2009

Function Ceiling()

Ceiling ()

This functions is used to convert a number with decimal points to an ineger greater than the number. When a number is input in this function, it adds the decimal points enough to convert the number to an integer more than the number itself


Syntax:

= Ceiling (Number, Significance)

Number = the number that is to be rounded off
Significance = multiple to which the number is to be rounded off


Example:
  • =Ceiling (26.2315 , 1) result will be - 27
  • =Ceiling (26.2315 , 2) result will be - 28
  • =Ceiling (26.2315 , 5) result will be - 30
  • =Ceiling (27.2315 , 1) result will be - 28
  • =Ceiling (27.2315 , 1) result will be - 28
  • =Ceiling (27.2315 , 1) result will be - 30
The ceiling function rounds off the number up to the nearest integer which is divisible by the significance value input in the function. Example - if I have to round up 26.33 to an integer, th result will be 27. But, if I want to round up the number, but to that integer which should also be divisible by 2, then my function wil be -

=Ceiling(26.33,)

The result of this function will be - 28

In the examples above I have used 26.2315 and 27.2315 to show the use of 'Significance' value.

Function Ceiling()SocialTwist Tell-a-Friend

0 comments:

Post a Comment