CEILING.MATH Function in Excel

CEILING.MATH Function in Excel rounds a supplied number up (regardless of the significance’s sign), to the nearest multiple of a given number.

  • Positive values are rounded away from zero(which becomes more positive)
  • If mode=0 then Negative numbers are rounded towards zero(which becomes less negative)
  • If mode=any other value then Negative numbers are rounded away from zero

 

Syntax of CEILING.MATH Function in Excel

CEILING.MATH( number, [significance],[mode])

number – The Number to be rounded up

significance– Multiple of Significance to which the number has to be rounded to

mode – If [mode] = 0 (or is omitted), negative numbers are rounded towards zero.

               If [mode]= any other numeric value, negative numbers are rounded away from zero

Note: the arithmetic sign of the [significance] argument is ignored.

 

Example of CEILING.MATH Function in Excel

Formula

CEILING.MATH FUNCTION IN EXCEL 1

  • 15.25 with significance 1 and -1 will result in 16  irrespective of mode value
  • Mode value matters when number is negative (highlighted in pink color)
  • -15.25 with significance 1 and mode 0 will result in -15 (rounded toward zero)
  • -15.25 with significance -1 and mode non ZERO will result in -16 (rounded away from zero)
  • CEILING.MATH rounds up regardless of significance sign, which means that there is no difference between -1 and 1 of significance values

Result

CEILING.MATH FUNCTION IN EXCEL 2

Note: #VALUE! Error occurs if the supplied arguments are non-numeric.

previous CEILING.MATH Function in Excel                                                                                                                next CEILING.MATH Function in Excel