Ceil

Description of formula:
Rounds a number up. Returns the smallest integer which is greater than or equal to the value passed as a parameter, e.g.
ceil(3.28) = 4
ceil(2.75) = 3
ceil(7) = 7
ceil(-2.56) = -2
Syntax:
ceil(number)
or
ceil(number, significance)
Parameters:
number
(type: Number) The number you want to round
significance
(type: Number) specifies the resolution of the number to n decimal places, e.g:
=round(4.12345,0.01)
will be:
4.13
Returned type:
Number
Examples:
=ceil(1.123)
=ceil(Section1.A)
=ceil(A1)
=ceil(Section1.A, 0.01)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk