Ceiling Excel Example

Example 1 round up to nearest 5.

Ceiling excel example. The ceiling function is a built in function in excel that is categorized as a math trig function it can be used as a worksheet function ws in excel. Ceiling function can be used to set the pricing after currency conversion discounts etc. Positive numbers with decimal portions are rounded up to the nearest integer e g.

The microsoft excel ceiling function returns a number rounded up based on a multiple of significance. Roundup b3 2 ceiling in google sheets. Instead of using the ceiling function to round up to a multiple you can use the roundup function to round a number up to a certain number of digits.

Let s see the results from using the function when we provide the following data. The excel ceiling math function will round a number up to the nearest integer or given multiple of significance. Copy the example data in the following table and paste it in cell a1 of a new excel worksheet.

Rnd function rounds off any decimal value to a whole number whereas in ceiling function we can choose the number to which extent we want to see the decimal. The formula used and results in excel are shown in the screenshot below. To round a number in a1 up to the nearest multiple of 5 you can use a formula like this.

Ceiling examples in vba. Ceiling function is another mathematical function in excel which is quite useful which is used for rounding off any decimal number closer to value selected in the function but away from 0. For example if you want to avoid using pennies in your prices and your product is priced at 4 42 use the formula ceiling 4 42 0 05 to round prices up to the nearest nickel.

Ceiling works like the mround function but unlike mround which rounds to the nearest multiple ceiling always rounds up. Example 2 using ceiling with. To understand the uses of the ceiling function let s consider a few examples.