{"id":1034,"date":"2019-05-03T12:37:09","date_gmt":"2019-05-03T09:37:09","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=1034"},"modified":"2019-05-03T12:38:36","modified_gmt":"2019-05-03T09:38:36","slug":"the-ceiling-math-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-ceiling-math-function\/","title":{"rendered":"The CEILING.MATH Function"},"content":{"rendered":"\n<p>It returns a number rounded up, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the <strong><a href=\"https:\/\/www.test4u.eu\/excelpedia\/the-ceiling-function\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"CEILING (opens in a new tab)\">CEILING<\/a><\/strong> function.<\/p>\n\n\n\n<p>The syntax of the function is the following: <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-style-large is-layout-flow wp-block-quote-is-layout-flow\"><p> <strong>CEILING.MATH<\/strong><em>(<strong>number, [significance], [mode]<\/strong><\/em>) <\/p><cite><strong>number<\/strong>: The number we need to round up.<br><strong>[significance]<\/strong>: Optional. The multiple of significance we wish to round up to.  <br><strong>[mode]<\/strong>: Optional. It controls if the number will be rounded towards or away from zero. <\/cite><\/blockquote>\n\n\n\n<p> The default value of <strong>significance<\/strong> is +1 for positive numbers and -1 for negative numbers.<\/p>\n\n\n\n<p>The <strong>mode <\/strong>argument does not affect positive numbers<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It returns a number rounded up, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the CEILING function.<\/p>\n","protected":false},"author":2,"featured_media":1035,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[153,15],"class_list":["post-1034","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-ceiling-math","tag-math"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/05\/ceiling_math.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-gG","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/1034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/comments?post=1034"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/1034\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/1035"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=1034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=1034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=1034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}