Excel Function : CEILING
Category
Math and trigonometry
Description
Rounds a number to the nearest integer or to the nearest multiple of significance
Microsoft Excel Reference Page
https://support.office.com/en-us/article/CEILING-function-0a5cd7c8-0720-4f0a-bd2c-c943e510899f
Syntax and Description of the CEILING Excel Function
Syntax: =CEILING(number,significance) Arguments: number - The number you want to round. significance - The multiple to which you want to round.
About CEILING Excel Function
CEILING rounds a number up to the nearest integer multiple of a specified value. For example, if you want to round up to the nearest multiple of 10, use this formula: =CEILING(A1,10)
