How to ceiling a decimal number in Excel?

Ceiling, or changing a specific decimal number into become its upper number, for example if we ceiling 3.25 we will got 4, or if we ceiling 2.75 then we will got 3 as a result.

To get a result like that in Microsoft Excel, we can simply use this very simple but neat Excel VBA function

Function Ceiling(Number As Double) As Long
    Ceiling = -Int(-Number)
End Function
This entry was posted in Excel VBA Function and tagged , , , , , . Bookmark the permalink.

5 Responses to How to ceiling a decimal number in Excel?

  1. Pingback: Bail Bonds Los Angeles

  2. Pingback: debt consolidation companies

  3. Pingback: reverse mortgage texas

  4. Pingback: reverse mortgage companies

  5. Pingback: hostgator coupon code 2012

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>