DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to Use Excel CEILING.MATH Function in Office 365?

#excelceilingmathfunc #excelfunctions

Excel CEILING.MATH Function:

CEILING.MATH Function
CEILING.MATH Function

In this tutorial, we will guide you to know the usage of Excel CEILING.MATH Function in Office 365 with its syntax, explanation, and examples. Let’s see them below!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

CEILING.MATH Function – Explanation:

  • This function will round the input number to the nearest integer or to the nearest multiple.
  • For example, CEILING.MATH(21.6,5) returns the output value as 25.

Syntax:

=CEILING.MATH(number, [significance], [mode])

  • If the significance value is a negative number and then it will print the rounded output value towards zero.
  • If the significance value is a positive number and then it will print the rounded output value away from zero.

Argument Explanation:

Number – The input number to be rounded.

Significance – It is optional. The multiple to use when rounding the number. If you omit this option, it will take 1 as a default value.

Mode – It is optional. It is used for rounding the negative numbers towards or away from zero. By default, it takes 0.

Note:

  • If any argument is a non-numeric value (letters and special characters) and then it returns #VALUE! Error.
  • By default, the significance is +1 for positive input numbers, and -1 for negative input numbers.

Examples:

Let’s see some examples to make it clear.

Example 1:

  • Refer to the below screenshot.
  • You can see the input numbers in Column A , significance values in Column B , and its mode values in Column C.
  • The rounded output numbers are listed in Column D.

Example 1
Example 1

Example 2:

  • If any of the arguments such as “Number, Significance, Mode” is a non-numeric value (letters and special characters) and then it returns #VALUE! Error.

Example 2
Example 2

Summary:

In this tutorial, you can understand the usage of Excel CEILING.MATH Function in Office 365 with its syntax, explanation, and examples. Share your feedback in the below comment section. Thanks for visiting Geek Excel. Keep Learning!!

Similar Articles:

See Also:

Top comments (0)