{"id":1212,"date":"2018-03-13T00:08:11","date_gmt":"2018-03-12T18:08:11","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1212"},"modified":"2018-03-13T00:08:11","modified_gmt":"2018-03-12T18:08:11","slug":"limited-ceiling","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1212","title":{"rendered":"Limited Ceiling"},"content":{"rendered":"<p>The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function.<\/p>\n<p>It allows you to round &nbsp;number to any value up<\/p>\n<p>Unlike ROUND, ROUNDUP and ROUNDDOWN, that are limited to number of decimal places.<\/p>\n<p>CEILING can round to any number, decimal or not.<\/p>\n<p>Below is an example of rounding the number in D2 which is 22 into the next 7 up, 7 is in D3, result is 28 as you can see<\/p>\n<p><!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1214\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/03\/Screenshot_1.png\" alt=\"Screenshot_1\" width=\"652\" height=\"399\"><\/p>\n<h3>&nbsp;<\/h3>\n<h3>&nbsp;<\/h3>\n<h3>But &#8230;<\/h3>\n<p>A challange a while back was to create what is equivelent to CEILING<\/p>\n<p>So, here it is &#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1215\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/03\/Screenshot_2.png\" alt=\"Screenshot_2\" width=\"652\" height=\"399\"><\/p>\n<p>Using the function INT that will cutthe integer part of a number, we can easily mimic CEILING function.<br \/>\n<br \/>&nbsp;<\/p>\n<div class=\"row\">\n<div class=\"col-lg-6 col-md-6 col-sm-6 text-right\"><a class=\"btn btn-primary btn-lg\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/03\/LimitedCeiling.xlsx\"><i class=\"fa fa-download\"><\/i> Download Spreadsheet<\/a><\/div>\n<div class=\"col-lg-6 col-md-6 col-sm-6\"><a class=\"btn btn-primary btn-lg\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO18sfhVTzZha2K_s1qQ\" target=\"_blank\" rel=\"noopener\"><i class=\"fa fa-cloud\"><\/i> Excel Online version<\/a><\/div>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function. It allows you to round &nbsp;number to any value up Unlike ROUND, ROUNDUP and ROUNDDOWN, that are limited to number of decimal places. CEILING can round to any number, decimal or not. Below is an example of rounding the number in&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=1212\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Limited Ceiling&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1213,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,69,3,86,38,6],"tags":[102,151],"class_list":["post-1212","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-basic-math","category-ceiling","category-formulas","category-int","category-math-and-trig","category-standard_functions","tag-ceiling","tag-int"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1212"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1212\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1213"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}