{"id":1039,"date":"2019-05-03T13:05:07","date_gmt":"2019-05-03T10:05:07","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=1039"},"modified":"2019-05-03T13:05:10","modified_gmt":"2019-05-03T10:05:10","slug":"the-floor-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-floor-function\/","title":{"rendered":"The FLOOR Function"},"content":{"rendered":"\n

It returns a number rounded down, toward zero, to the nearest multiple of significance . <\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

FLOOR<\/strong>(number, significance<\/strong><\/em>) <\/p>number<\/strong>: The number we need to round down.
significance<\/strong>: the multiple of significance we wish to round down to. <\/cite><\/blockquote>\n\n\n\n

if number is negative and significance positive the value is rounded down away from zero.<\/p>\n\n\n\n

if numbers is negative and significance negative the value is rounded up towards zero.<\/p>\n\n\n\n

<\/div>\n\n\n\n\n
<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the FLOOR function:<\/strong><\/p>\n\n\n\n

In the third row, round down the numbers of the respective cells of the first row, using the instructions found in the second row.<\/p>\n\n\n\n

\n