Excel Ceiling
The excel round function returns a number rounded to a given number of digits.
Excel ceiling. Ms excel 2016 handles both positive and negative arguments. Number must be. By default ceiling math rounds to the nearest integer using a significance of 1.
Ceiling function in excel. 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. The excel ceiling function rounds a number up to a given multiple.
The multiple to use for rounding is provided as the significance argument. If the number is already an exact multiple no rounding occurs and the original number is returned. A full list along with comparison tables is provided on the excel rounding functions page.
Positive numbers with decimal portions are rounded up to the nearest integer e g. This article describes the formula syntax and usage of the ceiling math function in microsoft excel. 6 3 is rounded up to 7 and negative numbers with decimal portions.
The excel ceiling function rounds a supplied number away from zero to the nearest multiple of a given number. Returns number rounded up away from zero to the nearest multiple of significance. The excel ceiling function rounds a given number up to the nearest specified multiple.
The function will return a number that is rounded up to a supplied number that is away from zero to the nearest multiple of a given number. However if backward compatibility is not required you should consider using the new functions from now on because they more accurately describe their functionality. The excel ceiling function is one of fifteen rounding functions in excel.