In general, positive values are rounded away from zero and negative numbers are rounded towards zero. However, the user can reverse the direction of the rounding for negative numbers.
The Excel Ceiling.Math function rounds a supplied numberupto a supplied multiple of significance.
An optional numeric argument that reverses the direction of roundingfor negative numbers only.
If you get an error from the Excel Ceiling.Math function, this is likely to be the VALUE! error:
argument is omitted, it takes on the default value of 1 (see cell B1).
An optional argument that specifies the multiple of significance to round the supplied number to.
If omitted, the[significance]argument takes on the default value 1 (i.e. round up to the nearest integer).
For further details and examples of the Excel Ceiling.Math function, see theMicrosoft Office website.
argument is provided and is non-zero, negative numbers are rounded away from zero (see cell B5).
In column B of the following spreadsheet, the Excel Ceiling.Math function is used to round the positive and negative numbers 15.25 and -15.25, to different significance values.
the Ceiling.Math function generally rounds positive numbers away from zero and negative numbers towards zero. However, if the
The Excel Ceiling.Math function is one of fifteen rounding functions in Excel.
Note:the Ceiling.Math function was first introduced in Excel 2013 and so is not available in earlier versions of Excel.