326 and the supplied number is negative the result also will be negative only -6. The multiple to use for rounding is provided as the significance argument. Syntax CEILINGMATH number significance mode Syntax Breakdown number The number argument is required in the CEILINGMATH function.
The Excel CEILING function rounds a number up to a given multiple.
CEILINGMATH is useful for users looking for increased functionality when handling negative numbers. For example CEILING 101202 returns 102 it round 1012 to nearest multiple of 02. 63 is rounded up to 7 and negative numbers with decimal portions are rounded toward zero eg. It rounds up the given function to a defined multiple.