Search This Blog

pCloud Crypto

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!

pCloud Lifetime

The customer care and complaint management contact details for BASIC Bank Limited

If you need to get in touch with  BASIC Bank Limited  in Bangladesh regarding complaints or suggestions, here are the ways you can reach the...