CEIL rounds a number up to the next ceiling value.
Like the RND() operation, the CEIL operation has two arguments:
CEIL(<number>, <dec places>)
Examples:
CEIL(5,0)
returns an answer of 5
CEIL(5.1,0)
returns an answer of 6
CEIL(5.9,0)
returns an answer of 6
CEIL(3.5+2.4+2.7,0)
returns an answer of 9 (3.5+2.4+2.7 = 8.6)
CEIL(3.5,0)+CEIL(2.4,0)+CEIL(2.7,0)
returns an answer of 10 (4+3 +3)
CEIL(5.01,0)
returns an answer of 6
CEIL(5.01,1)
returns an answer of 5.1
CEIL(5.01,2)
returns an answer of 5.01