Skip to content

ISO.CEILING

A number rounded up to a multiple of a significance (1 by default), whatever the significance's sign.

Group: Math. Compatible with DAX.

Syntax

ISO.CEILING ( <number> [, <significance>] )

Parameter	Type	Description
`number`	Number	The number to take up to a multiple.
`significance`	Number optional	The multiple to round to; its sign makes no difference. 1 when left out.

Returns

Number. The number rounded up, towards plus infinity, to a multiple of the significance.

Remarks

Always up, whatever the signs: ISO.CEILING ( -4.3 ) is -4, and ISO.CEILING ( -20, -3 ) is -18 where CEILING ( -20, -3 ) gives -21.
A positive number with a negative significance is no error here: ISO.CEILING ( 4.3, -2 ) is 6.
For positive numbers and significances, it gives what CEILING gives.
A significance of 0 gives 0. A blank number gives BLANK.

Examples

ISO.CEILING against CEILING

EVALUATE
ROW (
    "ISO.CEILING ( -20, -3 )", ISO.CEILING ( -20, -3 ),
    "CEILING ( -20, -3 )", CEILING ( -20, -3 ),
    "ISO.CEILING ( 20, -3 )", ISO.CEILING ( 20, -3 )
)

ISO.CEILING ( -20, -3 )	CEILING ( -20, -3 )	ISO.CEILING ( 20, -3 )
-18	-21	21

Without a significance

EVALUATE
ROW ( "Of 4.3", ISO.CEILING ( 4.3 ), "Of -4.3", ISO.CEILING ( -4.3 ) )

Of 4.3	Of -4.3
5	-4

CEILING, FLOOR, ROUNDUP, MROUND.

Last updated 3 November 2026 · OpenBI Studio 0.3.74