CEILINGMATH

  • Updated

Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.

Sample Usage

CEILINGMATH(-5.25, 10, 1)
CEILINGMATH(A4, A5)

Syntax

CEILINGMATH(number, [significance], [mode])

  • number - The number to be rounded.
  • significance - [OPTIONAL] The number to whose multiples the value will be rounded.
  • mode - [OPTIONAL] Specifies the rounding direction in case of negative numbers.
    •  If set to 0 or left blank, the number is rounded up towards zero. Otherwise, it's rounded down away from zero.

Examples

CEILINGMATH(-15.5100) rounds the number towards zero, and returns the number -10.
CEILINGMATH(-15.5102) rounds the number away from zero, and returns the number -20.

Notes

  • By default, significance is +1 for positive numbers and -1 for negative numbers. By specifying the significance and mode arguments, you can change the direction of the rounding.
  • By default, positive numbers with decimal places are rounded up to the nearest integer.
  • By default, negative numbers with decimal places are rounded up towards zero to the nearest integer. For example, -2.6 is rounded up to -2.