CEILING.MATH Function Explained
The CEILING.MATH Function in Microsoft Excel rounds a number up to the nearest multiple of a specified number. It takes two arguments: the number to round and the multiple to round to. It returns a number that is the smallest multiple of the specified number that is greater than or equal to the number provided.
CEILING.MATH Function Syntax
CEILING.MATH(number, significance, [mode])
- number: The number you want to round up to the nearest multiple of significance.
- significance: The multiple to which you want to round number.
- mode: (optional) A number that specifies the type of rounding. If mode is omitted, it is assumed to be 0.