floor

Round toward negative infinity.

Syntax

B = floor(A)             % script mode
B = floor(A, sig)        % Excel-compatible mode

Description

In script mode, returns the largest integer less than or equal to each element of A.

In Excel-compatible mode (cell formulas), takes a second argument sig and rounds each element down to the nearest multiple of sig. sig must be a positive number; otherwise a #VALUE! cell error is returned.

Examples

floor(3.7)         % 3
floor(-2.3)        % -3
floor(7.3, 0.5)    % 7   (Excel-compat: nearest 0.5 below)

See also

• round — Round to the nearest integer (or to a specified number of digits).
• nthroot — Real n-th root of an array.