Limited Ceiling

The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function.

It allows you to round  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 D2 which is 22 into the next 7 up, 7 is in D3, result is 28 as you can see

Screenshot_1

 

 

But …

A challange a while back was to create what is equivelent to CEILING

So, here it is …

Screenshot_2

Using the function INT that will cutthe integer part of a number, we can easily mimic CEILING function.

 

 

Comments

comments