Excel Function : CEILING.MATH

Download now!

Excel Function : CEILING.MATH

Category

Math and trigonometry

Description

Rounds a number up, to the nearest integer or to the nearest multiple of significance

Microsoft Excel Reference Page

https://support.office.com/en-us/article/CEILINGMATH-function-80f95d2f-b499-4eee-9f16-f795a8e306c8

Syntax and Description of the CEILING.MATH Excel Function

syntax in JavaScript. math.ceil(x) Return the smallest integer greater than or equal to x. Description. Math.ceil( ) returns the smallest integer greater than or equal to a given number. Syntax. Math.ceil(x). Parameter Values. Excel Math Ceil Function.Excel Ceiling Function. Excel Round to the Nearest 1000. Excel Round Down Function. Excel Round Up Function. Math.ceil(x) returns the smallest integer greater than or equal to x. Math.floor(x) returns the largest integer less than or equal to x. Math.hypot(x, y) returns sqrt(x2 y2) Math.min(x, y) returns the

About CEILING.MATH Excel Function

The CEILING.MATH function rounds a number up to the nearest integer or multiple of significance.