How to ceiling a decimal number in Excel?

Posted on June 16, 2008 by Admin

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.

1,275 Responses to How to ceiling a decimal number in Excel?

← Older Comments

  1. Pingback: planning a wedding on a small budget

  2. Pingback: sponsors

  3. Pingback: on-line marketing

  4. Pingback: cancer survival

  5. Pingback: Maison à vendre auterive

  6. Pingback: Hellboy XX

  7. Pingback: ????abe ??

  8. Pingback: masseuse 3

  9. Pingback: Immobilier Concarneau

  10. Pingback: payday lender

  11. Pingback: married but need an affair

  12. Pingback: car finance brisbane

  13. Pingback: url

  14. Pingback: golf instruction

  15. Pingback: barcode printers

  16. Pingback: Publishing for the kindle

  17. Pingback: got milk?

  18. Pingback: my logo design

  19. Pingback: online payday advance

  20. Pingback: blog

  21. Pingback: Sites Like Quibids

  22. Pingback: link

  23. Pingback: leaking bladder surgery

  24. Pingback: ftp hosting

  25. Pingback: HCG Diet Reviews

← Older Comments

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>