CEILING.MATH function
Rounds a number up, to the nearest integer or to the nearest multiple of significance
Syntax
CEILING.MATH(number, [significance], [mode])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| number | Yes | The value you want to round.-5.5 |
| significance | No | The multiple to which you want to round.2 |
| mode | No | For negative numbers, controls whether Number is rounded toward or away from zero.-1 |
Try CEILING.MATH
Round a negative value toward zero
=CEILING.MATH(-4.3,2)With the default negative-number mode, the next multiple of two toward zero is -4.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
CEILING.MATH · top-level call
=CEILING.MATH(-4.3,2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.