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.

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.

Tuesday, May 26, 2009