CEILING.MATH

Excel Functions

Round a number up to nearest multiple

Syntax

EXCEL

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

Arguments

Parameter	Description
`number`	The number that should be rounded.
`significance`	[optional] Multiple to use when rounding. Default is 1.
`mode`	[optional] Round negative numbers toward or away from zero. Default is 0.

Return Value

A rounded number.

Details

The Excel CEILING.MATH function rounds a number up to a given multiple, where multiple is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned. The CEILING.MATH function takes three arguments, number, significance, and mode. Number is the numeric value to round up, and is the only required argument. With no other input, CEILING.MATH will round number up to the next integer. The significance argument is the multiple to which number should be rounded. In most cases, significance is provided as a numeric value, but CEILING.MATH can also understand time entered as text like "0:15". The default value of significance is 1. The mode argument controls the direction negative values are rounded. By default, CEILING.

Examples

By default, CEILING.MATH rounds to the nearest integer, using a significance of 1.

EXCEL

=CEILING.MATH(1.25) // returns 2

Examples

Provide a value for significance to round to a different multiple:

EXCEL

=CEILING.MATH(1.25,3) // returns 3
=CEILING.MATH(4.1,3) // returns 6
=CEILING.MATH(4.1,0.5) // returns 4.5

Rounding negative numbers

By default, positive numbers with decimal portions are rounded up to the nearest integer and negative numbers with decimal portions are rounded toward

EXCEL

=CEILING.MATH(6.3) // returns 7
=CEILING.MATH(-6.3) // returns -6

Rounding negative numbers

Control for rounding negative numbers toward zero or away from zero is provided via the optional mode argument. Mode defaults to zero. When mode is ze

EXCEL

=CEILING.MATH(-4.1) // returns -4
=CEILING.MATH(-4.1,1) // returns -4
=CEILING.MATH(-4.1,1,1) // returns -5
=CEILING.MATH(-4.1,1,TRUE) // returns -5

CEILING.MATH

Syntax

Arguments

Return Value

Details

Examples

See Also