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

float floor(float number, float step)

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

Examples

=floor(3.5, 1)

equals 3

=floor(-6.5, -2)

equals -6

=floor(-4.5, 2)

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

=floor(2.5, 0.1)

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

=floor(0.123, 0.01)

equals 0.12.

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