Elite Membership

Excel CEILING Function

Written by Tanuj Kumar Tanuj Kumar Freelance Writer Tanuj Kumar, founder of ShareYourConscience.com, brings 9+ years of expertise in data analytics and content support. As a former Assistant Programmer at CyberQ Consulting and Software Developer at Raxon Technology, he passionately shares tech insights and knowledge to inspire skill-building. A UPTU 9+ years of experience Finance View Full Profile
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Content Reviewer & Course Director Dheeraj is a former J.P. Morgan and CLSA Equity Analyst with nearly two decades of experience in financial modeling, valuation, equity research, and corporate finance. He specializes in helping students and professionals develop practical and in-demand finance skills through structured and AI-powered, 20+ Years of experience CFA, FRM, IIT Delhi, IIM Lucknow Financial Modeling View Full Profile
Updated Dec 20, 2024
Read Time 2 min

Part of our Maths Functions in Excel guide · 76 articles →

CEILING Function in Excel

The Excel CEILING function is very similar to the floor function in Excel. Still, the result is just the opposite of the floor function. The floor function gives us the result of the less significance and CEILING formula provides us with the result of higher significance. 

Download FREE CEILING Function Excel Template and Follow Along!
Download Excel Template

So, for example, if we have the number 10 and significance as 3 then 12 will be the result.

Syntax

Excel CEILING Function

Compulsory Parameter:

  • number: It is the value that you want to round off.
  • significance: It is the multiple that we want to round up.

How to Use the CEILING Function in Excel?

Example #1

Let us take a set of positive integers as number arguments and positive numbers as significance, then apply the CEILING Excel function below. It will show the output in the result.

Things to Remember

  • #NUM! error:
    • It may occur in MS Excel 2007 or earlier versions. For example, if we provide the significance argument with a different arithmetic sign from the given number argument, get #NUM! Error.
    • It occurs if you are using MS Excel 2010/2013, then CEILING functions through #NUM! Error if the given number is positive and the supplied significance is negative.
  • #DIV/0! Error occurs when the significance parameter is zero.
  • #VALUE! Error occurs when any of the parameters is non-numeric.
  • Excel CEILING function is the same as MROUND, but it always rounds up away from zero.

This article has been a guide to the CEILING function in Excel. Here we discuss the CEILING formula in Excel and how to use the CEILING function and Excel example, and downloadable Excel templates. You may also look at these useful functions in Excel: –

Explore the full Maths Functions in Excel guide or browse Excel Resources.