CEILING formula in Excel with examples

The CEILING function in Excel is a powerful tool for rounding numbers up to the nearest specified multiple. Let’s explore how it works and provide some examples:

1. Syntax:

   • The CEILING function has the following syntax:

     =CEILING(number, significance)
     

   • Number: The value you want to round.
   • Significance: The multiple to which you want to round.

2. Examples:

   • To round 2.5 up to the nearest multiple of 1, use:

     =CEILING(2.5, 1)   // Result: 3
     

   • For negative numbers:
     • To round -2.5 up to the nearest multiple of -2, use:

       =CEILING(-2.5, -2)   // Result: -4
       

     • To round -2.5 up to the nearest multiple of 2, use:

       =CEILING(-2.5, 2)   // Result: -2
       

   • Decimal precision:
     • To round 1.5 up to the nearest multiple of 0.1, use:

       =CEILING(1.5, 0.1)   // Result: 1.5
       

     • To round 0.234 up to the nearest multiple of 0.01, use:

       =CEILING(0.234, 0.01)   // Result: 0.24
       

Remember, the CEILING function ensures precise rounding based on your specified criteria!