VBA does not have a CeilingMath function equivalent so if you want to round a number up to the nearest integer or to the nearest specified multiple of significance then you can call the CeilingMath worksheet function from your VBA code. It will return a number that is rounded up to the nearest integer or multiple of significance. Popular Course in this category.
Ceiling function In mathematics and computer science the floor function is the function that takes as input a real number displaystyle x and gives as output the greatest integer less than or equal to displaystyle x denoted.
VBA does not have a CeilingMath function equivalent so if you want to round a number up to the nearest integer or to the nearest specified multiple of significance then you can call the CeilingMath worksheet function from your VBA code. The Excel CEILING function is categorized under Math and Trigonometry functions. In general positive values are rounded away from zero and negative numbers are rounded towards zero. Excel released the CEILINGMATH function as a successor of the CEILING function.