{"id":1030,"date":"2019-05-03T12:21:00","date_gmt":"2019-05-03T09:21:00","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=1030"},"modified":"2019-05-03T12:21:17","modified_gmt":"2019-05-03T09:21:17","slug":"the-ceiling-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-ceiling-function\/","title":{"rendered":"The CEILING Function"},"content":{"rendered":"\n

It returns a number rounded up, away from 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

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

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

if numbers is negative and significance positive 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 CEILING function:<\/strong><\/p>\n\n\n\n

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

\n