{"id":1188,"date":"2018-07-01T15:18:51","date_gmt":"2018-07-01T15:18:51","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1188"},"modified":"2023-11-02T18:35:16","modified_gmt":"2023-11-02T18:35:16","slug":"ceiling","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/ceiling\/","title":{"rendered":"CEILING function"},"content":{"rendered":"\n
The CEILING function in Excel is used to round a number up to the nearest specified multiple or significance. It helps ensure that a number is always rounded up to a certain level, which can be particularly useful in financial calculations, pricing, and other scenarios.<\/p>\n\n\n\n
CEILING(number, significance)<\/strong><\/p>\n\n\n\n The CEILING function is straightforward to use. You provide it with a number and a significance, and it rounds the number up to the nearest multiple of the given significance.<\/p>\n\n\n\n Here’s an example:<\/p>\n\n\n\n This formula rounds the number 17 up to the nearest multiple of 5, which is 20.<\/p>\n\n\n\n You can also use negative values for the significance. For instance:<\/p>\n\n\n\n This formula rounds the number 23 up to the nearest multiple of -10, which is -20.<\/p>\n\n\n\n If you need to round to a different level of precision, simply change the significance value. For example:<\/p>\n\n\n\n This formula rounds 42.75 up to the nearest multiple of 0.1, resulting in 42.8.<\/p>\n\n\n\n Remember that if the number is already a multiple of the specified significance, it won’t be rounded up further. The function only rounds up when necessary to reach the nearest multiple.<\/p>\n\n\n\n Additional Information: The CEILING function can be combined with other Excel functions and formulas to perform more complex calculations and adjustments. It is especially useful in financial modeling and pricing calculations.<\/p>\n","protected":false},"excerpt":{"rendered":" The CEILING function in Excel is used to round a number up to the nearest specified multiple or significance. It helps ensure that…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
number<\/strong><\/td> The number you want to round up to the nearest significance.<\/td><\/tr> significance<\/strong><\/td> The multiple to which you want to round the number up. This can be a positive or negative number, and it determines the level to which the number is rounded up.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=CEILING(17, 5)<\/code><\/pre>\n\n\n\n
=CEILING(23, -10)<\/code><\/pre>\n\n\n\n
=CEILING(42.75, 0.1)<\/code><\/pre>\n\n\n\n