Math & Trig
Excel 2013
◉ 42 views
=CEILING.MATH()
The CEILING.MATH function rounds a number up to the nearest integer or, optionally, to the nearest multiple of significance.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=CEILING.MATH(number, [significance], [mode])
Hover argument names in the table for details.
Output typeNumber
Popularity40 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =CEILING.MATH() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number |
Number | Required | (must be between -2.229E-308.and 9.99E+307.) |
significance |
Number | Optional | This is the number of significant digits after the decimal point to which |
mode |
Number | Optional | This controls whether negative numbers are rounded toward or away from zero. |
▣ Examples
Rounds 24.3 up to the nearest integer that is a multiple of 5.
=CEILING.MATH(24.3,5)
Result:
25
Rounds 6.7 up to the nearest integer.
=CEILING.MATH(6.7)
Result:
7
Rounds -8.1 up (toward 0) to the nearest integer that is a multiple of 2.
=CEILING.MATH(-8.1,2)
Result:
-8
Rounds -5.5 down (away from 0) to the nearest integer that is a multiple of 2 with a mode of -1 which reverses rounding direction.
=CEILING.MATH(-5.5,2,-1)
Result:
-6
§ Remarks
- By default, significance is +1 for positive numbers and -1 for negative numbers.
- By default, positive numbers with decimal portions are rounded up to the nearest integer. For example, 6.3 is rounded up to 7.
- By default, negative numbers with decimal portions are rounded up (toward 0) to the nearest integer. For example, -6.7 is rounded up to -6.
- Using the significance and mode arguments, you can change the direction of the rounding for negative numbers. For example, rounding -6.3 to a significance of 1 with a mode of 1 will round away from 0, to -7. Combinations of Significance and Mode values can affect rounding of negative numbers in different ways.
- The mode argument does not affect positive numbers.
- The significance argument rounds the number up to the nearest integer that is a multiple of the specified significance. The exception is where the number to be rounded is an integer. For example, for a significance of 3 the number is rounded up to the next integer that is a multiple of 3.
- If number divided by a significance of 2 or greater results in a remainder, the result is rounded up.
✦ Tips
- By default, significance is +1 for positive numbers and -1 for negative numbers.
- By default, positive numbers with decimal portions are rounded up to the nearest integer. For example, 6.3 is rounded up to 7.
- By default, negative numbers with decimal portions are rounded up (toward 0) to the nearest integer. For example, -6.7 is rounded up to -6.
- Using the significance and mode arguments, you can change the direction of the rounding for negative numbers. For example, rounding -6.3 to a significance of 1 with a mode of 1 will round away from 0, to -7. Combinations of Significance and Mode values can affect rounding of negative numbers in different ways.
- The mode argument does not affect positive numbers.
- The significance argument rounds the number up to the nearest integer that is a multiple of the specified significance. The exception is where the number to be rounded is an integer. For example, for a significance of 3 the number is rounded up to the next integer that is a multiple of 3.
- If number divided by a significance of 2 or greater results in a remainder, the result is rounded up.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!