What to use the CEILING function for
The CEILING function is used to round numbers up to the nearest multiple of the number supplied as the significance. Must have sounded alien🤯
But let me explain this to you. Here’s how you write the CEILING function in Excel.
= CEILING (Number, significance)
- The number is the value that you want to be rounded up.
- Significance is the number whose multiple is used to round the number up.
For example, write the CEILING function as follows:
= CEILING (11,2)
The CEILING function tells Excel to round the number 11 up to the nearest multiple of 2.
The two closest multiples of 2 around 11 are:
As the CEILING function rounds a number up (and not down), it returns 12😏
Hope that explains how the CEILING function works.
The CEILING function can be used in financial analysis. You can also set it to determine a rounded price after different currency conversions, a percentage discount, commissions, etc.
If you are offering discounts to different customers on a variety of items that are differently priced, you can use the CEILING function to get the discounted price as a round multiple of 5💪