{"id":1038,"date":"2019-05-03T13:07:33","date_gmt":"2019-05-03T10:07:33","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=1038"},"modified":"2019-05-03T13:07:36","modified_gmt":"2019-05-03T10:07:36","slug":"the-floor-math-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-floor-math-function\/","title":{"rendered":"The FLOOR.MATH Function"},"content":{"rendered":"\n<p>It returns a number rounded down, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the <strong><a rel=\"noreferrer noopener\" aria-label=\"FLOOR  (opens in a new tab)\" href=\"https:\/\/www.test4u.eu\/excelpedia\/the-floor-function\/\" target=\"_blank\">FLOOR <\/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>FLOOR.MATH<\/strong><em>(<strong>number, [significance], [mode]<\/strong><\/em>) <\/p><cite><strong>number<\/strong>: The number we need to round down.<br><strong>[significance]<\/strong>: Optional. The multiple of significance we wish to round down to.  <br><strong>[mode]<\/strong>: Optional. It controls if the number will be rounded toward 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 down, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the FLOOR function.<\/p>\n","protected":false},"author":2,"featured_media":1042,"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":[155,15],"class_list":["post-1038","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-floor-math","tag-math"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/05\/floor_math.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-gK","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/1038","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=1038"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/1038\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/1042"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=1038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=1038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=1038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}