CEILING

x: number

significance: base multiple (defaults to 1 for x > 0 and -1 for x <0)

CEILING(x,significance) is the nearest multiple of significance whose absolute value is at least ABS(x).

If x or significance is non-numeric, CEILING returns a #VALUE! error. If x and significance have different signs, CEILING returns a #NUM! error.

This function is Excel compatible.

CEILING(x) is exported to ODF as CEILING(x,SIGN(x),1). CEILING(x,significance) is the OpenFormula function CEILING(x,significance,1).

CEIL, FLOOR, ABS, INT, MOD.