The `CEILING` function in Excel is used to round a number up to the nearest multiple of a specified value. Here’s how to use it:
Syntax:
CEILING(number, significance)
- number: This is the value you want to round up.
- significance: This is the multiple to which you want to round the number.
Example:
Suppose you want to round up the number 17 to the nearest 5.
- Click on the cell where you want the result to appear.
- Enter the formula: `=CEILING(17, 5)`
- Press `Enter`.
This formula will return `20`, since 20 is the nearest multiple of 5 that is greater than or equal to 17.
Important Notes:
- If the number is an exact multiple of the significance, `CEILING` will return that number.
- The function works for both positive and negative numbers. However, if you are rounding a negative number, it behaves by moving away from zero, making it more negative.
- If the `significance` value is negative, you might get unexpected results. It’s generally used with positive values for significance.
Feel free to experiment by replacing `17` and `5` with any numbers you wish to round and any significance you want to use!
Unlock Your Potential
Excel
Access
Power BI
