Investment Studio > Expressions > Functions > Math & Trig > CEILING

float ceiling(float number, float step)

Returns the number rounded away from zero in multiples of the specified step. The number and the step must have the same sign.

Examples

=ceiling(3.5, 1)

equals 4 (first step after 3.5 in the sequence 0, 1, 2, 3, 4)

=ceiling(-6.5, -2)

equals -8 (first step after 6.5 in the sequence 0, -2, -4, -6, -8)

=ceiling(-4.5, 2)

equals #VALUE! (number and step must have the same sign!)

=ceiling(2.5, 0.1)

equals 2.5 (the number is already a multiple of the step)

=ceiling(0.123, 0.01)

equals 0.13.

See also even, floor, frac, int, mround, odd, round, rounddown, roundup, trunc.